메뉴 건너뛰기

검색창 닫기

Bigdata, Semantic IoT, Hadoop, NoSQL

Bigdata, Hadoop ecosystem, Semantic IoT등의 프로젝트를 진행중에 습득한 내용을 정리하는 곳입니다.
필요한 분을 위해서 공개하고 있습니다. 문의사항은 gooper@gooper.com로 메일을 보내주세요.


Cloudera CDH/CDP sentry설정후 beeline으로 hive2server에 접속하여 admin계정에 admin권한 부여하기

총관리자 2018.07.03 23:04 조회 수 : 336

$>beeline
beeline> !connect jdbc:hive2://gsda4:10000
Connecting to jdbc:hive2://gsda4:10000
Enter username for jdbc:hive2://gsda4:10000: admin
Enter password for jdbc:hive2://gsda4:10000: ********
Connected to: Apache Hive (version 1.1.0-cdh5.15.0)
Driver: Hive JDBC (version 1.1.0-cdh5.15.0)
Transaction isolation: TRANSACTION_REPEATABLE_READ
0: jdbc:hive2://gsda4:10000>
0: jdbc:hive2://gsda4:10000> create role admin_role;
INFO  : Compiling command(queryId=hive_20180806235757_87db8100-df9c-4209-97b8-20e5f1acf6f2): create role admin_role
INFO  : Semantic Analysis Completed
INFO  : Returning Hive schema: Schema(fieldSchemas:null, properties:null)
INFO  : Completed compiling command(queryId=hive_20180806235757_87db8100-df9c-4209-97b8-20e5f1acf6f2); Time taken: 0.114 seconds
INFO  : Executing command(queryId=hive_20180806235757_87db8100-df9c-4209-97b8-20e5f1acf6f2): create role admin_role
INFO  : Starting task [Stage-0:DDL] in serial mode
INFO  : Completed executing command(queryId=hive_20180806235757_87db8100-df9c-4209-97b8-20e5f1acf6f2); Time taken: 0.476 seconds
INFO  : OK
No rows affected (2.104 seconds)
0: jdbc:hive2://gsda4:10000> grant ALL on SERVER server1 to role admin_role;
Error: Error while compiling statement: FAILED: ParseException line 1:31 cannot recognize input near 'admin_role' '<EOF>' '<EOF>' in user|group|role name (state=42000,code=40000)
0: jdbc:hive2://gsda4:10000> grant ALL on SERVER server1 to role admin_role;
INFO  : Compiling command(queryId=hive_20180807000101_a93281e3-616d-4134-9510-dc87204af950): grant ALL on SERVER server1 to role admin_role
INFO  : Semantic Analysis Completed
INFO  : Returning Hive schema: Schema(fieldSchemas:null, properties:null)
INFO  : Completed compiling command(queryId=hive_20180807000101_a93281e3-616d-4134-9510-dc87204af950); Time taken: 0.151 seconds
INFO  : Executing command(queryId=hive_20180807000101_a93281e3-616d-4134-9510-dc87204af950): grant ALL on SERVER server1 to role admin_role
INFO  : Starting task [Stage-0:DDL] in serial mode
INFO  : Completed executing command(queryId=hive_20180807000101_a93281e3-616d-4134-9510-dc87204af950); Time taken: 0.24 seconds
INFO  : OK
No rows affected (0.428 seconds)
0: jdbc:hive2://gsda4:10000> grant role admin_role to group admin;
INFO  : Compiling command(queryId=hive_20180807000202_747dc4ce-0290-4545-b630-49050fff6f8f): grant role admin_role to group admin
INFO  : Semantic Analysis Completed
INFO  : Returning Hive schema: Schema(fieldSchemas:null, properties:null)
INFO  : Completed compiling command(queryId=hive_20180807000202_747dc4ce-0290-4545-b630-49050fff6f8f); Time taken: 0.088 seconds
INFO  : Executing command(queryId=hive_20180807000202_747dc4ce-0290-4545-b630-49050fff6f8f): grant role admin_role to group admin
INFO  : Starting task [Stage-0:DDL] in serial mode
INFO  : Completed executing command(queryId=hive_20180807000202_747dc4ce-0290-4545-b630-49050fff6f8f); Time taken: 0.074 seconds
INFO  : OK
No rows affected (0.185 seconds)
0: jdbc:hive2://gsda4:10000>





gooper@gsda1:~$ beeline -u 'jdbc:hive2://gsda4:10000/'     
scan complete in 5ms
Connecting to jdbc:hive2://gsda4:10000/
Connected to: Apache Hive (version 1.1.0-cdh5.15.0)
Driver: Hive JDBC (version 1.1.0-cdh5.15.0)
Transaction isolation: TRANSACTION_REPEATABLE_READ
Beeline version 1.1.0-cdh5.15.0 by Apache Hive
0: jdbc:hive2://gsda4:10000/> 


----test.mode설정이 안된 경우 오류내용(sentry.hive.testing.mode)------
[root@cloudera1 ~]# beeline -u 'jdbc:hive2://cloudera3:10000/'
Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=512M; support was removed in 8.0
Java HotSpot(TM) 64-Bit Server VM warning: Using incremental CMS is deprecated and will likely be removed in a future release
Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=512M; support was removed in 8.0
scan complete in 4ms
Connecting to jdbc:hive2://cloudera3:10000/
Connected to: Apache Hive (version 1.1.0-cdh5.15.0)
Driver: Hive JDBC (version 1.1.0-cdh5.15.0)
Transaction isolation: TRANSACTION_REPEATABLE_READ
Beeline version 1.1.0-cdh5.15.0 by Apache Hive
0: jdbc:hive2://cloudera3:10000/> show tables;
Error: Error while compiling statement: FAILED: InvalidConfigurationException hive.server2.authentication can't be none in non-testing mode (state=42000,code=40000)

이 게시물을
목록
번호 제목 글쓴이 날짜 조회 수
741 [CDP7.1.7] oozie sqoop action으로 import혹은 export수행시 발생한 오류에 대한 자세한 로그 확인 하는 방법 gooper 2024.04.19 0
740 [Impala] alter table구문수행시 "WARNINGS: Impala does not have READ_WRITE access to path 'hdfs://nameservice1/DATA/Temp/DB/source/table01_ccd'" 발생시 조치 gooper 2024.04.26 0
739 [CDP7.1.7]Hive Replication수행시 Target Cluster에서 Specified catalog.database.table does not exist 오류 gooper 2024.05.08 0
738 [CDP7.1.7, Replication]Encryption Zone내 HDFS파일을 비Encryption Zone으로 HDFS Replication시 User hdfs가 아닌 hadoop으로 수행하는 방법 gooper 2024.01.15 1
737 [CDP7.1.7]Hive Replication수행중 Specified catalog.database.table does not exist : hive.db명.table명 오류 발생시 조치방법 gooper 2024.04.05 1
736 [CDP7.1.7][Replication]Table does not match version in getMetastore(). Table view original text mismatch gooper 2024.01.02 2
735 ./gradlew :composeDown 및 ./gradlew :composeUp 를 성공했을때의 메세지 gooper 2023.02.20 6
734 호출 url현황 gooper 2023.02.21 6
733 [vue storefrontui]외부 API통합하기 참고 문서 총관리자 2022.02.09 7
732 [Cloudera Agent] Metadata-Plugin throttling_logger INFO (713 skipped) Unable to send data to nav server. Will try again. gooper 2022.05.16 7
731 [CDP7.1.7, Hive Replication]Hive Replication진행중 "The following columns have types incompatible with the existing columns in their respective positions " 오류 gooper 2023.12.27 7
730 [CDP7.1.7]Oozie job에서 ERROR: Kudu error(s) reported, first error: Timed out: Failed to write batch of 774 ops to tablet 8003f9a064bf4be5890a178439b2ba91가 발생하면서 쿼리가 실패하는 경우 gooper 2024.01.05 7
729 eclipse editor 설정방법 총관리자 2022.02.01 10
728 oozie의 sqoop action수행시 ooize:launcher의 applicationId를 이용하여 oozie:action의 applicationId및 관련 로그를 찾는 방법 gooper 2023.07.26 10
727 주문 생성 데이터 예시 총관리자 2022.04.30 11
726 주문히스토리 조회 총관리자 2022.04.30 11
725 [bitbucket] 2022년 3월 2일 부터 git 작업시 기존에 사용하던 비빌번호를 사용할 수 없도록 변경되었다. 총관리자 2022.04.30 11
724 [EncryptionZone]User:testuser not allowed to do "DECRYPT_EEK" on 'testkey' gooper 2023.06.29 11
723 [CDP7.1.7]Encryption Zone내부/외부 간 데이터 이동(mv,cp)및 CTAS, INSERT SQL시 오류(can't be moved into an encryption zone, can't be moved from an encryption zone) gooper 2023.11.14 11
722 [CDP7.1.7]impala-shell수행시 간헐적으로 "-k requires a valid kerberos ticket but no valid kerberos ticket found." 오류 gooper 2023.11.16 11
쓰기 태그

A personal place to organize information learned during the development of such Hadoop, Hive, Hbase, Semantic IoT, etc.
We are open to the required minutes. Please send inquiries to gooper@gooper.com.

위로