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

Hi,

How to un-subscribe.
Thanks & Regards,
 
Deepak Talim
Architect | Analytics & Information Management | Wipro Technologies | Pune
Phone - VOIP: 8547081 | D: +91 +20 +39132608 | M: +91 98816 90900

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 03, 2012 5:44 PM
To: [EMAIL PROTECTED]
Subject: Hive Connection Error

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?,v