Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

HIVE Unable to Create Table

HIVE Unable to Create Table

Explorer

Hi, I am trying to create table but I am getting below issue:

 

hive> CREATE DATABASE TestDB;
FAILED: Error in metadata: MetaException(message:Unable to create database path file:/user/hive/warehouse/testdb.db, failed to create database TestDB)
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask

 

Can you please let me know as what can be the fault.

1 REPLY 1

Re: HIVE Unable to Create Table

Explorer

PFB the Log File:

 

14/04/28 09:01:40 WARN conf.HiveConf: DEPRECATED: Configuration property hive.metastore.local no longer has any effect. Make sure to provide a valid value for hive.metastore.uris if you are connecting to a remote metastore.
14/04/28 09:01:40 WARN conf.HiveConf: DEPRECATED: Configuration property hive.metastore.local no longer has any effect. Make sure to provide a valid value for hive.metastore.uris if you are connecting to a remote metastore.
14/04/28 09:01:42 INFO exec.HiveHistory: Hive history file=/tmp/hue/hive_job_log_981f7960-8317-47d5-a601-f4fcb377603c_1323504801.txt
14/04/28 09:01:42 WARN security.UserGroupInformation: No groups available for user admin
14/04/28 09:01:42 WARN security.UserGroupInformation: No groups available for user admin
14/04/28 09:01:43 WARN conf.HiveConf: DEPRECATED: Configuration property hive.metastore.local no longer has any effect. Make sure to provide a valid value for hive.metastore.uris if you are connecting to a remote metastore.
14/04/28 09:01:43 INFO ql.Driver: <PERFLOG method=Driver.run>
14/04/28 09:01:43 INFO ql.Driver: <PERFLOG method=TimeToSubmit>
14/04/28 09:01:43 INFO ql.Driver: <PERFLOG method=compile>
14/04/28 09:01:43 INFO parse.ParseDriver: Parsing command: use default
14/04/28 09:01:43 INFO parse.ParseDriver: Parse Completed
14/04/28 09:01:43 INFO ql.Driver: Semantic Analysis Completed
14/04/28 09:01:43 INFO ql.Driver: Returning Hive schema: Schema(fieldSchemas:null, properties:null)
14/04/28 09:01:43 INFO ql.Driver: </PERFLOG method=compile start=1398700903041 end=1398700903727 duration=686>
14/04/28 09:01:43 INFO zookeeper.ZooKeeper: Client environment:zookeeper.version=3.4.5-cdh4.6.0--1, built on 02/26/2014 09:19 GMT
14/04/28 09:01:43 INFO zookeeper.ZooKeeper: Client environment:host.name=localhost.localdomain
14/04/28 09:01:43 INFO zookeeper.ZooKeeper: Client environment:java.version=1.7.0_51
14/04/28 09:01:43 INFO zookeeper.ZooKeeper: Client environment:java.vendor=Oracle Corporation
14/04/28 09:01:43 INFO zookeeper.ZooKeeper: Client environment:java.home=/usr/java/jre1.7.0_51
14/04/28 09:01:43 INFO zookeeper.ZooKeeper: Client environment:java.class.path=/var/run/cloudera-scm-agent/process/110-hue-BEESWAX_SERVER/hive-conf:/var/run/cloudera-scm-agent/process/110-hue-BEESWAX_SERVER/hadoop-conf:/usr/lib/hadoop/lib/jasper-runtime-5.5.23.jar:/usr/lib/hadoop/lib/jackson-xc-1.8.8.jar:/usr/lib/hadoop/lib/commons-el-1.0.jar:/usr/lib/hadoop/lib/commons-compress-1.4.1.jar:/usr/lib/hadoop/lib/commons-logging-1.1.1.jar:/usr/lib/hadoop/lib/commons-io-2.1.jar:/usr/lib/hadoop/lib/protobuf-java-2.4.0a.jar:/usr/lib/hadoop/lib/commons-lang-2.5.jar:/usr/lib/hadoop/lib/commons-beanutils-core-1.8.0.jar:/usr/lib/hadoop/lib/snappy-java-1.0.4.1.jar:/usr/lib/hadoop/lib/paranamer-2.3.jar:/usr/lib/hadoop/lib/jersey-core-1.8.jar:/usr/lib/hadoop/lib/jsp-api-2.1.jar:/usr/lib/hadoop/lib/commons-digester-1.8.jar:/usr/lib/hadoop/lib/kfs-0.3.jar:/usr/lib/hadoop/lib/commons-net-3.1.jar:/usr/lib/hadoop/lib/jetty-util-6.1.26.cloudera.2.jar:/usr/lib/hadoop/lib/hue-plugins-2.5.0-cdh4.6.0.jar:/usr/lib/hadoop/lib/jackson-core-asl-1.8.8.jar:/usr/lib/hadoop/lib/jettison-1.1.jar:/usr/lib/hadoop/lib/commons-httpclient-3.1.jar:/usr/lib/hadoop/lib/commons-configuration-1.6.jar:/usr/lib/hadoop/lib/jetty-6.1.26.cloudera.2.jar:/usr/lib/hadoop/lib/zookeeper-3.4.5-cdh4.6.0.jar:/usr/lib/hadoop/lib/xz-1.0.jar:/usr/lib/hadoop/lib/slf4j-log4j12-1.6.1.jar:/usr/lib/hadoop/lib/jaxb-impl-2.2.3-1.jar:/usr/lib/hadoop/lib/jsch-0.1.42.jar:/usr/lib/hadoop/lib/junit-4.8.2.jar:/usr/lib/hadoop/lib/commons-math-2.1.jar:/usr/lib/hadoop/lib/log4j-1.2.17.jar:/usr/lib/hadoop/lib/jsr305-1.3.9.jar:/usr/lib/hadoop/lib/asm-3.2.jar:/usr/lib/hadoop/lib/cloudera-jets3t-2.0.0-cdh4.6.0.jar:/usr/lib/hadoop/lib/mockito-all-1.8.5.jar:/usr/lib/hadoop/lib/jackson-jaxrs-1.8.8.jar:/usr/lib/hadoop/lib/commons-cli-1.2.jar:/usr/lib/hadoop/lib/commons-beanutils-1.7.0.jar:/usr/lib/hadoop/lib/jackson-mapper-asl-1.8.8.jar:/usr/lib/hadoop/lib/servlet-api-2.5.jar:/usr/lib/hadoop/lib/jersey-server-1.8.jar:/usr/lib/hadoop/lib/commons-codec-1.4.jar:/usr/lib/hadoop/lib/jets3t-0.6.1.jar:/usr/lib/hadoop/lib/jline-0.9.94.jar:/usr/lib/hadoop/lib/activation-1.1.jar:/usr/lib/hadoop/lib/slf4j-api-1.6.1.jar:/usr/lib/hadoop/lib/jersey-json-1.8.jar:/usr/lib/hadoop/lib/guava-11.0.2.jar:/usr/lib/hadoop/lib/jaxb-api-2.2.2.jar:/usr/lib/hadoop/lib/xmlenc-0.52.jar:/usr/lib/hadoop/lib/avro-1.7.4.jar:/usr/lib/hadoop/lib/jasper-compiler-5.5.23.jar:/usr/lib/hadoop/lib/stax-api-1.0.1.jar:/usr/lib/hadoop/lib/commons-collections-3.2.1.jar:/usr/lib/hadoop/.//parquet-pig-1.2.5-cdh4.6.0.jar:/usr/lib/hadoop/.//parquet-thrift-1.2.5-cdh4.6.0.jar:/usr/lib/hadoop/.//parquet-scrooge-1.2.5-cdh4.6.0.jar:/usr/lib/hadoop/.//hadoop-common.jar:/usr/lib/hadoop/.//parquet-generator-1.2.5-cdh4.6.0.jar:/usr/lib/hadoop/.//parquet-test-hadoop2-1.2.5-cdh4.6.0.jar:/usr/lib/hadoop/.//hadoop-annotations-2.0.0-cdh4.6.0.jar:/usr/lib/hadoop/.//hadoop-common-2.0.0-cdh4.6.0-tests.jar:/usr/lib/hadoop/.//parquet-avro-1.2.5-cdh4.6.0.jar:/usr/lib/hadoop/.//hadoop-annotations.jar:/usr/lib/hadoop/.//parquet-format-1.0.0-cdh4.6.0.jar:/usr/lib/hadoop/.//parquet-common-1.2.5-cdh4.6.0.jar:/usr/lib/hadoop/.//parquet-encoding-1.2.5-cdh4.6.0.jar:/usr/lib/hadoop/.//parquet-hadoop-1.2.5-cdh4.6.0.jar:/usr/lib/hadoop/.//hadoop-common-2.0.0-cdh4.6.0.jar:/usr/lib/hadoop/.//parquet-hive-1.2.5-cdh4.6.0.jar:/usr/lib/hadoop/.//parquet-cascading-1.2.5-cdh4.6.0.jar:/usr/lib/hadoop/.//parquet-column-1.2.5-cdh4.6.0.jar:/usr/lib/hadoop/.//parquet-pig-bundle-1.2.5-cdh4.6.0.jar:/usr/lib/hadoop/.//hadoop-auth.jar:/usr/lib/hadoop/.//hadoop-auth-2.0.0-cdh4.6.0.jar:/usr/lib/hadoop-hdfs/./:/usr/lib/hadoop-hdfs/lib/jasper-runtime-5.5.23.jar:/usr/lib/hadoop-hdfs/lib/commons-el-1.0.jar:/usr/lib/hadoop-hdfs/lib/commons-logging-1.1.1.jar:/usr/lib/hadoop-hdfs/lib/commons-io-2.1.jar:/usr/lib/hadoop-hdfs/lib/protobuf-java-2.4.0a.jar:/usr/lib/hadoop-hdfs/lib/commons-lang-2.5.jar:/usr/lib/hadoop-hdfs/lib/jersey-core-1.8.jar:/usr/lib/hadoop-hdfs/lib/jsp-api-2.1.jar:/usr/lib/hadoop-hdfs/lib/jetty-util-6.1.26.cloudera.2.jar:/usr/lib/hadoop-hdfs/lib/jackson-core-asl-1.8.8.jar:/usr/lib/hadoop-hdfs/lib/jetty-6.1.26.cloudera.2.jar:/usr/lib/hadoop-hdfs/lib/zookeeper-3.4.5-cdh4.6.0.jar:/usr/lib/hadoop-hdfs/lib/commons-daemon-1.0.3.jar:/usr/lib/hadoop-hdfs/lib/log4j-1.2.17.jar:/usr/lib/hadoop-hdfs/lib/jsr305-1.3.9.jar:/usr/lib/hadoop-hdfs/lib/asm-3.2.jar:/usr/lib/hadoop-hdfs/lib/commons-cli-1.2.jar:/usr/lib/hadoop-hdfs/lib/jackson-mapper-asl-1.8.8.jar:/usr/lib/hadoop-hdfs/lib/servlet-api-2.5.jar:/usr/lib/hadoop-hdfs/lib/jersey-server-1.8.jar:/usr/lib/hadoop-hdfs/lib/commons-codec-1.4.jar:/usr/lib/hadoop-hdfs/lib/jline-0.9.94.jar:/usr/lib/hadoop-hdfs/lib/guava-11.0.2.jar:/usr/lib/hadoop-hdfs/lib/xmlenc-0.52.jar:/usr/lib/hadoop-hdfs/.//hadoop-hdfs-2.0.0-cdh4.6.0-tests.jar:/usr/lib/hadoop-hdfs/.//hadoop-hdfs-2.0.0-cdh4.6.0.jar:/usr/lib/hadoop-hdfs/.//hadoop-hdfs.jar:/usr/lib/hadoop-yarn/lib/netty-3.2.4.Final.jar:/usr/lib/hadoop-yarn/lib/commons-compress-1.4.1.jar:/usr/lib/hadoop-yarn/lib/guice-servlet-3.0.jar:/usr/lib/hadoop-yarn/lib/aopalliance-1.0.jar:/usr/lib/hadoop-yarn/lib/commons-io-2.1.jar:/usr/lib/hadoop-yarn/lib/javax.inject-1.jar:/usr/lib/hadoop-yarn/lib/protobuf-java-2.4.0a.jar:/usr/lib/hadoop-yarn/lib/snappy-java-1.0.4.1.jar:/usr/lib/hadoop-yarn/lib/paranamer-2.3.jar:/usr/lib/hadoop-yarn/lib/jersey-core-1.8.jar:/usr/lib/hadoop-yarn/lib/jackson-core-asl-1.8.8.jar:/usr/lib/hadoop-yarn/lib/xz-1.0.jar:/usr/lib/hadoop-yarn/lib/log4j-1.2.17.jar:/usr/lib/hadoop-yarn/lib/asm-3.2.jar:/usr/lib/hadoop-yarn/lib/guice-3.0.jar:/usr/lib/hadoop-yarn/lib/jackson-mapper-asl-1.8.8.jar:/usr/lib/hadoop-yarn/lib/jersey-server-1.8.jar:/usr/lib/hadoop-yarn/lib/jersey-guice-1.8.jar:/usr/lib/hadoop-yarn/lib/avro-1.7.4.jar:/usr/lib/hadoop-yarn/.//hadoop-yarn-api-2.0.0-cdh4.6.0.jar:/usr/lib/hadoop-yarn/.//hadoop-yarn-server-web-proxy.jar:/usr/lib/hadoop-yarn/.//hadoop-yarn-api.jar:/usr/lib/hadoop-yarn/.//hadoop-yarn-site.jar:/usr/lib/hadoop-yarn/.//hadoop-yarn-applications-unmanaged-am-launcher-2.0.0-cdh4.6.0.jar:/usr/lib/hadoop-yarn/.//hadoop-yarn-server-web-proxy-2.0.0-cdh4.6.0.jar:/usr/lib/hadoop-yarn/.//hadoop-yarn-server-tests-2.0.0-cdh4.6.0-tests.jar:/usr/lib/hadoop-yarn/.//hadoop-yarn-applications-distributedshell.jar:/usr/lib/hadoop-yarn/.//hadoop-yarn-server-nodemanager.jar:/usr/lib/hadoop-yarn/.//hadoop-yarn-server-resourcemanager.jar:/usr/lib/hadoop-yarn/.//hadoop-yarn-common-2.0.0-cdh4.6.0.jar:/usr/lib/hadoop-yarn/.//hadoop-yarn-client.jar:/usr/lib/hadoop-yarn/.//hadoop-yarn-server-common.jar:/usr/lib/hadoop-yarn/.//hadoop-yarn-server-nodemanager-2.0.0-cdh4.6.0.jar:/usr/lib/hadoop-yarn/.//hadoop-yarn-applications-distributedshell-2.0.0-cdh4.6.0.jar:/usr/lib/hadoop-yarn/.//hadoop-yarn-client-2.0.0-cdh4.6.0.jar:/usr/lib/hadoop-yarn/.//hadoop-yarn-server-resourcemanager-2.0.0-cdh4.6.0.jar:/usr/lib/hadoop-yarn/.//hadoop-yarn-server-tests.jar:/usr/lib/hadoop-yarn/.//hadoop-yarn-site-2.0.0-cdh4.6.0.jar:/usr/lib/hadoop-yarn/.//hadoop-yarn-server-common-2.0.0-cdh4.6.0.jar:/usr/lib/hadoop-yarn/.//hadoop-yarn-common.jar:/usr/lib/hadoop-yarn/.//hadoop-yarn-applications-unmanaged-am-launcher.jar:/usr/lib/hadoop-yarn/.//hadoop-yarn-server-tests-2.0.0-cdh4.6.0.jar:/usr/lib/hadoop-0.20-mapreduce/./:/usr/lib/hadoop-0.20-mapreduce/lib/jasper-runtime-5.5.23.jar:/usr/lib/hadoop-0.20-mapreduce/lib/jackson-xc-1.8.8.jar:/usr/lib/hadoop-0.20-mapreduce/lib/commons-el-1.0.jar:/usr/lib/hadoop-0.20-mapreduce/lib/commons-compress-1.4.1.jar:/usr/lib/hadoop-0.20-mapreduce/lib/commons-logging-1.1.1.jar:/usr/lib/hadoop-0.20-mapreduce/lib/commons-io-2.1.jar:/usr/lib/hadoop-0.20-mapreduce/lib/protobuf-java-2.4.0a.jar:/usr/lib/hadoop-0.20-mapreduce/lib/commons-lang-2.5.jar:/usr/lib/hadoop-0.20-mapreduce/lib/commons-beanutils-core-1.8.0.jar:/usr/lib/hadoop-0.20-mapreduce/lib/snappy-java-1.0.4.1.jar:/usr/lib/hadoop-0.20-mapreduce/lib/paranamer-2.3.jar:/usr/lib/hadoop-0.20-mapreduce/lib/jersey-core-1.8.jar:/usr/lib/hadoop-0.20-mapreduce/lib/ant-contrib-1.0b3.jar:/usr/lib/hadoop-0.20-mapreduce/lib/jsp-api-2.1.jar:/usr/lib/hadoop-0.20-mapreduce/lib/commons-digester-1.8.jar:/usr/lib/hadoop-0.20-mapreduce/lib/kfs-0.2.2.jar:/usr/lib/hadoop-0.20-mapreduce/lib/kfs-0.3.jar:/usr/lib/hadoop-0.20-mapreduce/lib/commons-net-3.1.jar:/usr/lib/hadoop-0.20-mapreduce/lib/jetty-util-6.1.26.cloudera.2.jar:/usr/lib/hadoop-0.20-mapreduce/lib/jackson-core-asl-1.8.8.jar:/usr/lib/hadoop-0.20-mapreduce/lib/hadoop-fairscheduler-2.0.0-mr1-cdh4.6.0.jar:/usr/lib/hadoop-0.20-mapreduce/lib/jettison-1.1.jar:/usr/lib/hadoop-0.20-mapreduce/lib/commons-httpclient-3.1.jar:/usr/lib/hadoop-0.20-mapreduce/lib/commons-configuration-1.6.jar:/usr/lib/hadoop-0.20-mapreduce/lib/jetty-6.1.26.cloudera.2.jar:/usr/lib/hadoop-0.20-mapreduce/lib/zookeeper-3.4.5-cdh4.6.0.jar:/usr/lib/hadoop-0.20-mapreduce/lib/xz-1.0.jar:/usr/lib/hadoop-0.20-mapreduce/lib/jaxb-impl-2.2.3-1.jar:/usr/lib/hadoop-0.20-mapreduce/lib/jsch-0.1.42.jar:/usr/lib/hadoop-0.20-mapreduce/lib/junit-4.8.2.jar:/usr/lib/hadoop-0.20-mapreduce/lib/commons-math-2.1.jar:/usr/lib/hadoop-0.20-mapreduce/lib/log4j-1.2.17.jar:/usr/lib/hadoop-0.20-mapreduce/lib/jsr305-1.3.9.jar:/usr/lib/hadoop-0.20-mapreduce/lib/asm-3.2.jar:/usr/lib/hadoop-0.20-mapreduce/lib/cloudera-jets3t-2.0.0-cdh4.6.0.jar:/usr/lib/hadoop-0.20-mapreduce/lib/mockito-all-1.8.5.jar:/usr/lib/hadoop-0.20-mapreduce/lib/jackson-jaxrs-1.8.8.jar:/usr/lib/hadoop-0.20-mapreduce/lib/commons-cli-1.2.jar:/usr/lib/hadoop-0.20-mapreduce/lib/commons-beanutils-1.7.0.jar:/usr/lib/hadoop-0.20-mapreduce/lib/jackson-mapper-asl-1.8.8.jar:/usr/lib/hadoop-0.20-mapreduce/lib/servlet-api-2.5.jar:/usr/lib/hadoop-0.20-mapreduce/lib/jersey-server-1.8.jar:/usr/lib/hadoop-0.20-mapreduce/lib/commons-codec-1.4.jar:/usr/lib/hadoop-0.20-mapreduce/lib/jets3t-0.6.1.jar:/usr/lib/hadoop-0.20-mapreduce/lib/jline-0.9.94.jar:/usr/lib/hadoop-0.20-mapreduce/lib/activation-1.1.jar:/usr/lib/hadoop-0.20-mapreduce/lib/avro-compiler-1.7.4.jar:/usr/lib/hadoop-0.20-mapreduce/lib/slf4j-api-1.6.1.jar:/usr/lib/hadoop-0.20-mapreduce/lib/hadoop-fairscheduler.jar:/usr/lib/hadoop-0.20-mapreduce/lib/jersey-json-1.8.jar:/usr/lib/hadoop-0.20-mapreduce/lib/guava-11.0.2.jar:/usr/lib/hadoop-0.20-mapreduce/lib/jaxb-api-2.2.2.jar:/usr/lib/hadoop-0.20-mapreduce/lib/xmlenc-0.52.jar:/usr/lib/hadoop-0.20-mapreduce/lib/avro-1.7.4.jar:/usr/lib/hadoop-0.20-mapreduce/lib/jasper-compiler-5.5.23.jar:/usr/lib/hadoop-0.20-mapreduce/lib/stax-api-1.0.1.jar:/usr/lib/hadoop-0.20-mapreduce/lib/commons-collections-3.2.1.jar:/usr/lib/hadoop-0.20-mapreduce/lib/hsqldb-1.8.0.10.jar:/usr/lib/hadoop-0.20-mapreduce/.//hadoop-examples.jar:/usr/lib/hadoop-0.20-mapreduce/.//hadoop-test-2.0.0-mr1-cdh4.6.0.jar:/usr/lib/hadoop-0.20-mapreduce/.//hadoop-examples-2.0.0-mr1-cdh4.6.0.jar:/usr/lib/hadoop-0.20-mapreduce/.//hadoop-core-2.0.0-mr1-cdh4.6.0.jar:/usr/lib/hadoop-0.20-mapreduce/.//hadoop-ant.jar:/usr/lib/hadoop-0.20-mapreduce/.//hadoop-core.jar:/usr/lib/hadoop-0.20-mapreduce/.//hadoop-test.jar:/usr/lib/hadoop-0.20-mapreduce/.//hadoop-tools.jar:/usr/lib/hadoop-0.20-mapreduce/.//hadoop-tools-2.0.0-mr1-cdh4.6.0.jar:/usr/lib/hadoop-0.20-mapreduce/.//hadoop-ant-2.0.0-mr1-cdh4.6.0.jar:/usr/lib/hadoop/lib/hue-plugins-2.5.0-cdh4.6.0.jar::/usr/lib/hive/lib/netty-3.4.0.Final.jar:/usr/lib/hive/lib/commons-logging-api-1.0.4.jar:/usr/lib/hive/lib/jackson-xc-1.8.8.jar:/usr/lib/hive/lib/hive-cli-0.10.0-cdh4.6.0.jar:/usr/lib/hive/lib/commons-compress-1.4.1.jar:/usr/lib/hive/lib/tempus-fugit-1.1.jar:/usr/lib/hive/lib/antlr-2.7.7.jar:/usr/lib/hive/lib/javolution-5.5.1.jar:/usr/lib/hive/lib/hive-shims-0.10.0-cdh4.6.0.jar:/usr/lib/hive/lib/hive-metastore-0.10.0-cdh4.6.0.jar:/usr/lib/hive/lib/servlet-api-2.5-20081211.jar:/usr/lib/hive/lib/snappy-java-1.0.4.1.jar:/usr/lib/hive/lib/paranamer-2.3.jar:/usr/lib/hive/lib/commons-dbcp-1.4.jar:/usr/lib/hive/lib/hbase.jar:/usr/lib/hive/lib/zookeeper.jar:/usr/lib/hive/lib/ST4-4.0.4.jar:/usr/lib/hive/lib/datanucleus-core-3.2.2.jar:/usr/lib/hive/lib/jackson-core-asl-1.8.8.jar:/usr/lib/hive/lib/JavaEWAH-0.3.2.jar:/usr/lib/hive/lib/stringtemplate-3.2.1.jar:/usr/lib/hive/lib/commons-configuration-1.6.jar:/usr/lib/hive/lib/hive-jdbc-0.10.0-cdh4.6.0.jar:/usr/lib/hive/lib/log4j-1.2.16.jar:/usr/lib/hive/lib/xz-1.0.jar:/usr/lib/hive/lib/hive-common-0.10.0-cdh4.6.0.jar:/usr/lib/hive/lib/antlr-runtime-3.4.jar:/usr/lib/hive/lib/avro-ipc-1.7.4-tests.jar:/usr/lib/hive/lib/hive-pdk-0.10.0-cdh4.6.0.jar:/usr/lib/hive/lib/hive-service-0.10.0-cdh4.6.0.jar:/usr/lib/hive/lib/avro-mapred-1.7.4-hadoop2.jar:/usr/lib/hive/lib/hive-contrib-0.10.0-cdh4.6.0.jar:/usr/lib/hive/lib/derby-10.4.2.0.jar:/usr/lib/hive/lib/jdo2-api-2.3-ec.jar:/usr/lib/hive/lib/jackson-jaxrs-1.8.8.jar:/usr/lib/hive/lib/commons-cli-1.2.jar:/usr/lib/hive/lib/hive-exec-0.10.0-cdh4.6.0.jar:/usr/lib/hive/lib/jackson-mapper-asl-1.8.8.jar:/usr/lib/hive/lib/hive-beeline-0.10.0-cdh4.6.0.jar:/usr/lib/hive/lib/commons-pool-1.5.4.jar:/usr/lib/hive/lib/json-20090211.jar:/usr/lib/hive/lib/commons-io-2.4.jar:/usr/lib/hive/lib/commons-codec-1.4.jar:/usr/lib/hive/lib/hive-hwi-0.10.0-cdh4.6.0.jar:/usr/lib/hive/lib/jline-0.9.94.jar:/usr/lib/hive/lib/libthrift-0.9.0-cdh4-1.jar:/usr/lib/hive/lib/slf4j-api-1.6.4.jar:/usr/lib/hive/lib/hive-serde-0.10.0-cdh4.6.0.jar:/usr/lib/hive/lib/hive-builtins-0.10.0-cdh4.6.0.jar:/usr/lib/hive/lib/datanucleus-api-jdo-3.2.1.jar:/usr/lib/hive/lib/postgresql-jdbc.jar:/usr/lib/hive/lib/libfb303-0.9.0.jar:/usr/lib/hive/lib/datanucleus-rdbms-3.2.1.jar:/usr/lib/hive/lib/hive-hbase-handler-0.10.0-cdh4.6.0.jar:/usr/lib/hive/lib/jetty-6.1.26.jar:/usr/lib/hive/lib/guava-11.0.2.jar:/usr/lib/hive/lib/commons-lang-2.4.jar:/usr/lib/hive/lib/jetty-util-6.1.26.jar:/usr/lib/hive/lib/avro-1.7.4.jar:/usr/lib/hive/lib/commons-collections-3.2.1.jar:/usr/lib/hive/lib/commons-logging-1.0.4.jar::/usr/share/cmf/lib/plugins/tt-instrumentation-4.8.2.jar:/usr/share/cmf/lib/plugins/navigator-plugin-4.8.2-shaded.jar:/usr/share/cmf/lib/plugins/event-publish-4.8.2-shaded.jar:/usr/share/java/mysql-connector-java.jar:/usr/share/cmf/lib/postgresql-9.0-801.jdbc4.jar:/usr/share/java/oracle-connector-java.jar
14/04/28 09:01:43 INFO zookeeper.ZooKeeper: Client environment:java.library.path=/usr/lib/hadoop/lib/native
14/04/28 09:01:43 INFO zookeeper.ZooKeeper: Client environment:java.io.tmpdir=/tmp
14/04/28 09:01:43 INFO zookeeper.ZooKeeper: Client environment:java.compiler=<NA>
14/04/28 09:01:43 INFO zookeeper.ZooKeeper: Client environment:os.name=Linux
14/04/28 09:01:43 INFO zookeeper.ZooKeeper: Client environment:os.arch=amd64
14/04/28 09:01:43 INFO zookeeper.ZooKeeper: Client environment:os.version=2.6.32-431.11.2.el6.x86_64
14/04/28 09:01:43 INFO zookeeper.ZooKeeper: Client environment:user.name=hue
14/04/28 09:01:43 INFO zookeeper.ZooKeeper: Client environment:user.home=/usr/share/hue
14/04/28 09:01:43 INFO zookeeper.ZooKeeper: Client environment:user.dir=/var/run/cloudera-scm-agent/process/110-hue-BEESWAX_SERVER
14/04/28 09:01:43 INFO zookeeper.ZooKeeper: Initiating client connection, connectString=localhost.localdomain:2181 sessionTimeout=600000 watcher=org.apache.hadoop.hive.ql.lockmgr.zookeeper.ZooKeeperHiveLockManager$DummyWatcher@3bc5578b
14/04/28 09:01:44 INFO ql.Driver: <PERFLOG method=acquireReadWriteLocks>
14/04/28 09:01:44 INFO ql.Driver: </PERFLOG method=acquireReadWriteLocks start=1398700904256 end=1398700904257 duration=1>
14/04/28 09:01:44 INFO ql.Driver: <PERFLOG method=Driver.execute>
14/04/28 09:01:44 INFO ql.Driver: Starting command: use default
14/04/28 09:01:44 INFO ql.Driver: </PERFLOG method=TimeToSubmit start=1398700903040 end=1398700904311 duration=1271>
14/04/28 09:01:44 INFO hive.metastore: Trying to connect to metastore with URI thrift://localhost.localdomain:9083
14/04/28 09:01:44 WARN security.UserGroupInformation: No groups available for user admin
14/04/28 09:01:44 INFO hive.metastore: Connected to metastore.
14/04/28 09:01:45 INFO ql.Driver: </PERFLOG method=Driver.execute start=1398700904257 end=1398700905326 duration=1069>
OK
14/04/28 09:01:45 INFO ql.Driver: OK
14/04/28 09:01:45 INFO ql.Driver: <PERFLOG method=releaseLocks>
14/04/28 09:01:45 INFO ql.Driver: </PERFLOG method=releaseLocks start=1398700905327 end=1398700905328 duration=1>
14/04/28 09:01:45 INFO ql.Driver: </PERFLOG method=Driver.run start=1398700903039 end=1398700905328 duration=2289>
14/04/28 09:01:45 INFO ql.Driver: <PERFLOG method=compile>
14/04/28 09:01:45 INFO parse.ParseDriver: Parsing command: CREATE DATABASE TestDB
14/04/28 09:01:45 INFO parse.ParseDriver: Parse Completed
14/04/28 09:01:45 INFO ql.Driver: Semantic Analysis Completed
14/04/28 09:01:45 INFO ql.Driver: Returning Hive schema: Schema(fieldSchemas:null, properties:null)
14/04/28 09:01:45 INFO ql.Driver: </PERFLOG method=compile start=1398700905331 end=1398700905340 duration=9>
Hive history file=/tmp/hue/hive_job_log_981f7960-8317-47d5-a601-f4fcb377603c_807343669.txt
14/04/28 09:01:45 INFO exec.HiveHistory: Hive history file=/tmp/hue/hive_job_log_981f7960-8317-47d5-a601-f4fcb377603c_807343669.txt
14/04/28 09:01:45 WARN security.UserGroupInformation: No groups available for user admin
14/04/28 09:01:45 WARN security.UserGroupInformation: No groups available for user admin
14/04/28 09:01:45 WARN conf.HiveConf: DEPRECATED: Configuration property hive.metastore.local no longer has any effect. Make sure to provide a valid value for hive.metastore.uris if you are connecting to a remote metastore.
14/04/28 09:01:45 INFO ql.Driver: <PERFLOG method=Driver.execute>
14/04/28 09:01:45 INFO ql.Driver: Starting command: CREATE DATABASE TestDB
14/04/28 09:01:45 INFO ql.Driver: </PERFLOG method=TimeToSubmit start=1398700903040 end=1398700905495 duration=2455>
14/04/28 09:01:45 INFO hive.metastore: Trying to connect to metastore with URI thrift://localhost.localdomain:9083
14/04/28 09:01:45 WARN security.UserGroupInformation: No groups available for user admin
14/04/28 09:01:45 INFO hive.metastore: Connected to metastore.
14/04/28 09:01:52 INFO ql.Driver: </PERFLOG method=Driver.execute start=1398700905494 end=1398700912426 duration=6932>
OK
14/04/28 09:01:52 INFO ql.Driver: OK
14/04/28 09:01:53 WARN conf.HiveConf: DEPRECATED: Configuration property hive.metastore.local no longer has any effect. Make sure to provide a valid value for hive.metastore.uris if you are connecting to a remote metastore.
Hive history file=/tmp/hue/hive_job_log_981f7960-8317-47d5-a601-f4fcb377603c_530618698.txt
14/04/28 09:01:53 INFO exec.HiveHistory: Hive history file=/tmp/hue/hive_job_log_981f7960-8317-47d5-a601-f4fcb377603c_530618698.txt
14/04/28 09:01:53 WARN security.UserGroupInformation: No groups available for user admin
14/04/28 09:01:53 WARN security.UserGroupInformation: No groups available for user admin
14/04/28 09:01:54 WARN conf.HiveConf: DEPRECATED: Configuration property hive.metastore.local no longer has any effect. Make sure to provide a valid value for hive.metastore.uris if you are connecting to a remote metastore.
Don't have an account?
Coming from Hortonworks? Activate your account here