메뉴 건너뛰기

Cloudera, BigData, Semantic IoT, Hadoop, NoSQL

Cloudera CDH/CDP 및 Hadoop EcoSystem, Semantic IoT등의 개발/운영 기술을 정리합니다. gooper@gooper.com로 문의 주세요.


$>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)

번호 제목 날짜 조회 수
282 HiveServer2인증을 PAM을 이용하도록 설정하는 방법 2018.07.21 1018
281 [postgresql 9.x] PostgreSQL Replication 구축하기 2018.07.17 757
280 spark 2.3.0을 설치하가 위해서 parcel에 다음 url을 입력한다. 2018.07.15 402
» sentry설정후 beeline으로 hive2server에 접속하여 admin계정에 admin권한 부여하기 2018.07.03 994
278 upsert구현방법(년-월-일 파티션을 기준으로) 및 테스트 script file 2018.07.03 2146
277 resouce manager에 dr.who가 아닌 다른 사용자로 로그인 하기 2018.06.28 1782
276 CDH에서 Sentry 개념및 설정 file 2018.06.21 762
275 cloudera에서 spark-shell를 실행했을때 default master는 spark.master=yarn-client임 2018.06.20 1028
274 dr.who로 공격들어오는 경우 조치방법 file 2018.06.09 5801
273 spark-shell을 실행하면 "Attempted to request executors before the AM has registered!"라는 오류가 발생하면 2018.06.08 787
272 SCM서비스를 추가하는 동안 Unexpected error. Unable to verify database connection. 오류발생시 확인 사항 2018.06.08 842
271 Cloudera Manager에서 "Mismatched CDH versions: host has NONE but role expects 5 Suppress..."와 같이 오류 발생시 확인사항 2018.06.06 912
270 JAVA_HOME을 명시적으로 지정하는 방법 2018.06.04 613
269 spark 시동중 applicationHistory 로그 디렉토리가 없다고 하면서 기동되지 않는 경우 2018.06.01 808
268 impala2를 Cloudera Manager가 아닌 수동으로 설치하는 방법 2018.05.30 928
267 MapReduce2.0(YARN)기반의 CDH5 설치시 생성되는 사용자및 권한 부여 2018.05.30 904
266 HUE를 사용할 사용자를 추가 하는 절차 2018.05.29 1124
265 JobHistory 서버 기동시 HDFS상에 특정 폴더를 생성할 수 없어서 기동하지 못하는 경우 조치 2018.05.29 3150
264 DataNode를 기동할때 "Block pool ID needed, but service not yet registered with NN" 오류 발생에 따른 조치사항 2018.05.28 1521
263 Cloudera Manager설치및 Uninstall 방법(순서) 2018.05.28 2045
위로