beeline -u "jdbc:hive2://XXXXXXX:10000/default;principal=hive/XXXXXXX@SB3.1ACONOMY.COM" scan complete in 1ms Connecting to jdbc:hive2://XXXXXXX:10000/default;principal=hive/XXXXXXXX@SB3.1ACONOMY.COM Connected to: Apache Hive (version 1.1.0-cdh5.8.5) Driver: Hive JDBC (version 1.1.0-cdh5.8.5) Transaction isolation: TRANSACTION_REPEATABLE_READ Beeline version 1.1.0-cdh5.8.5 by Apache Hive I am able to login to beeline with the principal, but when i trying to insert the statement i am getting below issue as mentioned. 0: jdbc:hive2://ovhtisb3snnc01.sb3.1aconomy.c> insert into tmp_test values ('1','xxxxxxx'); INFO : Compiling command(queryId=hive_20171212111515_eda7838d-97b2-4050-a851-04d52b716ae7): insert into tmp_test values ('1','amadeus') INFO : Semantic Analysis Completed INFO : Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:_col0, type:int, comment:null), FieldSchema(name:_col1, type:string, comment:null)], properties:null) INFO : Completed compiling command(queryId=hive_20171212111515_eda7838d-97b2-4050-a851-04d52b716ae7); Time taken: 0.341 seconds INFO : Executing command(queryId=hive_20171212111515_eda7838d-97b2-4050-a851-04d52b716ae7): insert into tmp_test values ('1','xxxxxx') INFO : Query ID = hive_20171212111515_eda7838d-97b2-4050-a851-04d52b716ae7 INFO : Total jobs = 3 INFO : Launching Job 1 out of 3 INFO : Starting task [Stage-1:MAPRED] in serial mode INFO : Number of reduce tasks is set to 0 since there's no reduce operator INFO : number of splits:1 INFO : Submitting tokens for job: job_1512999567949_0007 INFO : Kind: kms-dt, Service: 172.16.8.160:16000, Ident: (kms-dt owner=dwhman, renewer=yarn, realUser=hive, issueDate=1513077316273, maxDate=1513682116273, sequenceNumber=7, masterKeyId=2) INFO : Kind: HDFS_DELEGATION_TOKEN, Service: ha-hdfs:sb3nameservice, Ident: (token for dwhman: HDFS_DELEGATION_TOKEN owner=dwhman, renewer=yarn, realUser=hive/ovhtisb3snnc01.sb3.1aconomy.com@SB3.1ACONOMY.COxDate=1513682115941, sequenceNumber=36, masterKeyId=53) INFO : Kind: HIVE_DELEGATION_TOKEN, Service: HiveServer2ImpersonationToken, Ident: 00 06 64 77 68 6d 61 6e 06 64 77 68 6d 61 6e 35 68 69 76 65 2f 6f 76 68 74 69 73 62 33 73 6e 6e 63 30 31 2e 73 62 33 2e 31 6d 40 53 42 33 2e 31 41 43 4f 4e 4f 4d 59 2e 43 4f 4d 8a 01 60 4a 6f 12 32 8a 01 60 6e 7b 96 32 04 01 INFO : Cleaning up the staging area /user/dwhman/.staging/job_1512999567949_0007 ERROR : Job Submission failed with exception 'java.io.IOException(org.apache.hadoop.yarn.exceptions.YarnException: Failed to submit application_1512999567949_0007 to YARN : Failed to renew token: Kind: kms-d, Ident: (kms-dt owner=dwhman, renewer=yarn, realUser=hive, issueDate=1513077316273, maxDate=1513682116273, sequenceNumber=7, masterKeyId=2))' java.io.IOException: org.apache.hadoop.yarn.exceptions.YarnException: Failed to submit application_1512999567949_0007 to YARN : Failed to renew token: Kind: kms-dt, Service: 172.16.8.160:16000, Ident: (kms-drealUser=hive, issueDate=1513077316273, maxDate=1513682116273, sequenceNumber=7, masterKeyId=2)
... View more
