Member since
03-08-2020
1
Post
0
Kudos Received
0
Solutions
03-08-2020
04:02 PM
Creating table throws error but database creation works fine. (base) [cloudera@quickstart ~]$ beeline -u jdbc:hive2://quickstart:10000/default --hiveconf hive.root.logger=DEBUG,console -e "create table test(i int)" 20/03/08 15:55:10 DEBUG util.VersionInfo: version: 2.6.0-cdh5.16.2 OpenJDK 64-Bit Server VM warning: If the number of processors is expected to increase from one, then you should configure the number of parallel GC threads appropriately using -XX:ParallelGCThreads=N scan complete in 8ms Connecting to jdbc:hive2://quickstart:10000/default Connected to: Apache Hive (version 1.1.0-cdh5.16.2) (base) [cloudera@quickstart ~]$ beeline -u jdbc:hive2://quickstart:10000/default --hiveconf hive.root.logger=DEBUG,console -e "create database test" 20/03/08 15:57:51 DEBUG util.VersionInfo: version: 2.6.0-cdh5.16.2 OpenJDK 64-Bit Server VM warning: If the number of processors is expected to increase from one, then you should configure the number of parallel GC threads appropriately using -XX:ParallelGCThreads=N scan complete in 5ms Connecting to jdbc:hive2://quickstart:10000/default Connected to: Apache Hive (version 1.1.0-cdh5.16.2) Driver: Hive JDBC (version 1.1.0-cdh5.16.2) Transaction isolation: TRANSACTION_REPEATABLE_READ INFO : Compiling command(queryId=hive_20200308155858_019a49da-ea7d-441c-863d-f37ff4c86d32): create database test INFO : Semantic Analysis Completed INFO : Returning Hive schema: Schema(fieldSchemas:null, properties:null) INFO : Completed compiling command(queryId=hive_20200308155858_019a49da-ea7d-441c-863d-f37ff4c86d32); Time taken: 0.096 seconds INFO : Concurrency mode is disabled, not creating a lock manager INFO : Executing command(queryId=hive_20200308155858_019a49da-ea7d-441c-863d-f37ff4c86d32): create database test INFO : Starting task [Stage-0:DDL] in serial mode INFO : Completed executing command(queryId=hive_20200308155858_019a49da-ea7d-441c-863d-f37ff4c86d32); Time taken: 3.029 seconds INFO : OK No rows affected (3.281 seconds) Beeline version 1.1.0-cdh5.16.2 by Apache Hive Driver: Hive JDBC (version 1.1.0-cdh5.16.2) Transaction isolation: TRANSACTION_REPEATABLE_READ INFO : Compiling command(queryId=hive_20200308155555_9a444e04-9523-4443-b312-64a94e5a5138): create table test(i int) INFO : Semantic Analysis Completed INFO : Returning Hive schema: Schema(fieldSchemas:null, properties:null) INFO : Completed compiling command(queryId=hive_20200308155555_9a444e04-9523-4443-b312-64a94e5a5138); Time taken: 0.268 seconds INFO : Concurrency mode is disabled, not creating a lock manager INFO : Executing command(queryId=hive_20200308155555_9a444e04-9523-4443-b312-64a94e5a5138): create table test(i int) INFO : Starting task [Stage-0:DDL] in serial mode ERROR : FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:Exception thrown when executing query) INFO : Completed executing command(queryId=hive_20200308155555_9a444e04-9523-4443-b312-64a94e5a5138); Time taken: 20.625 seconds Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:Exception thrown when executing query) (state=08S01,code=1)
... View more