Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive, mail # dev - Hive Connection Error


Copy link to this message
-
Hive Connection Error
deepak.talim@... 2012-07-03, 12:13
Hi,

While trying to connect to Hive using talend 5 'HiveConnection' getting following error:

Technical details:
Coludera ver CDH3
Apache ver 1
Hive ver 7.0
HDFS

Error:
While connecting it's trying to create directory with the 'windows AD user id' on hdfs tmp directory, what permissions are required to provide or what is the solution.

Error details:
======================================================[statistics] connecting to socket on port 3338
[statistics] connected
12/07/03 16:49:53 WARN conf.HiveConf: hive-site.xml not found on CLASSPATH
12/07/03 16:49:54 INFO metastore.HiveMetaStore: 0: Opening raw store with implemenation class:org.apache.hadoop.hive.metastore.ObjectStore
12/07/03 16:49:54 INFO metastore.ObjectStore: ObjectStore, initialize called
12/07/03 16:49:54 INFO DataNucleus.Persistence: Property datanucleus.cache.level2 unknown - will be ignored
12/07/03 16:49:54 INFO DataNucleus.Persistence: Property javax.jdo.option.NonTransactionalRead unknown - will be ignored
12/07/03 16:49:54 INFO DataNucleus.Persistence: ================= Persistence Configuration ==============12/07/03 16:49:54 INFO DataNucleus.Persistence: DataNucleus Persistence Factory - Vendor: "DataNucleus"  Version: "2.0.3"
12/07/03 16:49:54 INFO DataNucleus.Persistence: DataNucleus Persistence Factory initialised for datastore URL="jdbc:derby:;databaseName=metastore_db;create=true" driver="org.apache.derby.jdbc.EmbeddedDriver" userName="APP"
12/07/03 16:49:54 INFO DataNucleus.Persistence: ==========================================================12/07/03 16:49:57 INFO Datastore.Schema: Initialising Catalog "", Schema "APP" using "None" auto-start option
12/07/03 16:49:57 INFO Datastore.Schema: Catalog "", Schema "APP" initialised - managing 0 classes
12/07/03 16:49:57 INFO metastore.ObjectStore: Setting MetaStore object pin classes with hive.metastore.cache.pinobjtypes="Table,StorageDescriptor,SerDeInfo,Partition,Database,Type,FieldSchema,Order"
12/07/03 16:49:57 INFO DataNucleus.MetaData: Registering listener for metadata initialisation
12/07/03 16:49:57 INFO metastore.ObjectStore: Initialized ObjectStore
12/07/03 16:49:58 WARN DataNucleus.MetaData: MetaData Parser encountered an error in file "jar:file:/D:/Deepak%20Talim/Technical/Talend5/Talend%20Project/.Java/lib/hive-metastore-0.8.1.jar!/package.jdo" at line 11, column 6 : cvc-elt.1: Cannot find the declaration of element 'jdo'. - Please check your specification of DTD and the validity of the MetaData XML that you have specified.
12/07/03 16:49:58 WARN DataNucleus.MetaData: MetaData Parser encountered an error in file "jar:file:/D:/Deepak%20Talim/Technical/Talend5/Talend%20Project/.Java/lib/hive-metastore-0.8.1.jar!/package.jdo" at line 321, column 13 : The content of element type "class" must match "(extension*,implements*,datastore-identity?,primary-key?,inheritance?,version?,join*,foreign-key*,index*,unique*,column*,field*,property*,query*,fetch-group*,extension*)". - Please check your specification of DTD and the validity of the MetaData XML that you have specified.
12/07/03 16:49:58 WARN DataNucleus.MetaData: MetaData Parser encountered an error in file "jar:file:/D:/Deepak%20Talim/Technical/Talend5/Talend%20Project/.Java/lib/hive-metastore-0.8.1.jar!/package.jdo" at line 368, column 13 : The content of element type "class" must match "(extension*,implements*,datastore-identity?,primary-key?,inheritance?,version?,join*,foreign-key*,index*,unique*,column*,field*,property*,query*,fetch-group*,extension*)". - Please check your specification of DTD and the validity of the MetaData XML that you have specified.
12/07/03 16:49:59 WARN DataNucleus.MetaData: MetaData Parser encountered an error in file "jar:file:/D:/Deepak%20Talim/Technical/Talend5/Talend%20Project/.Java/lib/hive-metastore-0.8.1.jar!/package.jdo" at line 390, column 13 : The content of element type "class" must match "(extension*,implements*,datastore-identity?,primary-key?,inheritance?,version?,join*,foreign-key*,index*,unique*,column*,field*,property*,query*,fetch-group*,extension*)". - Please check your specification of DTD and the validity of the MetaData XML that you have specified.
12/07/03 16:49:59 WARN DataNucleus.MetaData: MetaData Parser encountered an error in file "jar:file:/D:/Deepak%20Talim/Technical/Talend5/Talend%20Project/.Java/lib/hive-metastore-0.8.1.jar!/package.jdo" at line 425, column 13 : The content of element type "class" must match "(extension*,implements*,datastore-identity?,primary-key?,inheritance?,version?,join*,foreign-key*,index*,unique*,column*,field*,property*,query*,fetch-group*,extension*)". - Please check your specification of DTD and the validity of the MetaData XML that you have specified.
12/07/03 16:49:59 WARN DataNucleus.MetaData: MetaData Parser encountered an error in file "jar:file:/D:/Deepak%20Talim/Technical/Talend5/Talend%20Project/.Java/lib/hive-metastore-0.8.1.jar!/package.jdo" at line 462, column 13 : The content of element type "class" must match "(extension*,implements*,datastore-identity?,primary-key?,inheritance?,version?,join*,foreign-key*,index*,unique*,column*,field*,property*,query*,fetch-group*,extension*)". - Please check your specification of DTD and the validity of the MetaData XML that you have specified.
12/07/03 16:49:59 WARN DataNucleus.MetaData: MetaData Parser encountered an error in file "jar:file:/D:/Deepak%20Talim/Technical/Talend5/Talend%20Project/.Java/lib/hive-metastore-0.8.1.jar!/package.jdo" at line 503, column 13 : The content of element type "class" must match "(extension*,implements*,datastore-identity?,primary-key?,inheritance?,version?,join*,foreign-key*,index*,unique*,column*,field*,property*,query*,fetch-group*,extension*)". - Please check your specification of DTD and the validity of the MetaData XML that you have specified.
12/07/03 16:49:59 WARN DataNucleus.MetaData: MetaData Parser encountered an error in file "jar:file:/D:/Deepak%20Talim/Technical/Talend5/Talend%20Project/.Java/lib/hive-metastore-0
+
deepak.talim@... 2012-10-04, 05:53