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)