메뉴 건너뛰기

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)

번호 제목 날짜 조회 수
670 jdk 9이상 사용하려면 repository를 아래와 같이 지정해야한다. 2019.06.02 2770
669 [Kerberos]Kerberos authentication cache를 FILE로 지정해도 KCM으로 저장되는 경우 조치방법 2024.11.03 2772
668 magento2 설치후 초기화면이 깨지는 문제 file 2017.01.31 2775
667 java.lang.IllegalArgumentException: Does not contain a valid host:port authority: master 오류해결방법 2015.05.06 2781
666 에러 추적(Error Tracking) 및 로그 취합(logging aggregation) 시스템인 Sentry 설치 2018.03.14 2781
665 webid에서 google처럼 검색할 수 있도록 하는 프로그램 2017.05.16 2782
664 Spark에서 KafkaUtils.createStream()를 이용하여 이용하여 kafka topic에 접근하여 객채로 저장된 값을 가져오고 처리하는 예제 소스 2017.04.26 2802
663 슬라이딩 윈도우 예제 2016.07.28 2804
662 파일명 혹은 확장자 일괄 변경하는 방법 2017.01.26 2811
661 "암은 평범한 병, 심호흡만 잘해도 암세포 분열 저지” 2016.06.02 2815
660 springframework를 이용한 war를 생성하는 build.gradle파일(참고용) 2016.08.19 2818
659 uEnv.txt위치및 내용 2014.07.09 2828
658 git설명 한글판 2015.12.09 2829
657 failed to read local state, exiting...오류발생시 조치사항 2016.04.06 2832
656 servlet-api를 jar형태로 build할때 포함하지 말고 java 설치 위치의 jre/lib/ext에 복사하여 사용하는것이 좋다. 2016.08.10 2840
655 How-to: Build a Complex Event Processing App on Apache Spark and Drools file 2016.10.31 2849
654 namenode오류 복구시 사용하는 명령 2016.04.01 2851
653 다중 모듈 프로젝트 설정에 대한 설명 2016.09.21 2851
652 [Hue metadata]Oracle에 있는 Hue 메타정보 테이블을 이용하여 coordinator와 workflow관계 목록을 추출하는 방법 2023.08.22 2860
651 [SparkR]SparkR 설치 사용기 1 - Installation Guide On Yarn Cluster & Mesos Cluster & Stand Alone Cluster file 2016.11.04 2863
위로