Reply
Explorer
Posts: 12
Registered: ‎03-22-2014

HIVE Unable to Create Table

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.

Explorer
Posts: 12
Registered: ‎03-22-2014

Re: HIVE Unable to Create Table

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.