[resolved] hive-site.xml not found on CLASSPATH

[Anonymous]

Hi,
I use Talend 5.1 et and i have a Hive connection but i got a message error concerning the hive_site.xml

démarrage du job job_connect_2 a 15:03 13/09/2012.
connecting to socket on port 3977
connected
12/09/13 15:03:36 WARN conf.HiveConf: hive-site.xml not found on CLASSPATH
12/09/13 15:03:36 INFO metastore.HiveMetaStore: 0: Opening raw store with implemenation classrg.apache.hadoop.hive.metastore.ObjectStore
12/09/13 15:03:36 INFO metastore.ObjectStore: ObjectStore, initialize called
12/09/13 15:03:36 INFO DataNucleus.Persistence: Property datanucleus.cache.level2 unknown - will be ignored
12/09/13 15:03:36 INFO DataNucleus.Persistence: Property javax.jdo.option.NonTransactionalRead unknown - will be ignored
12/09/13 15:03:36 INFO DataNucleus.Persistence: ================= Persistence Configuration ===============
12/09/13 15:03:36 INFO DataNucleus.Persistence: DataNucleus Persistence Factory - Vendor: "DataNucleus" Version: "2.0.3"
12/09/13 15:03:36 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/09/13 15:03:36 INFO DataNucleus.Persistence:

Could you please tell me in which directory i must put the hive_site.xml and how to configure it ?

Thanks

[Anonymous]

Hi
It is an issue of hive, see
https://issues.apache.org/jira/browse/HIVE-1933?page=com.atlassian.jira.plugin.system.issuetabpanels...

[Anonymous]

Hi,
It is still an issue, i got someone from Talend in France, he told me to put the file hive-site.xml in the directory :
C:\TALEND_FOR_BIG_DATA\TOS_BD-r84309-V5.1.1\lib or C:\TALEND_FOR_BIG_DATA\TOS_BD-r84309-V5.1.1\lib\java
but the issue still exists.
I downloaded the Talend version 5.2 but i can't connect to hive.

If you have any solution for this issue , i will appreciate.

Thanks.

[Anonymous]

Hello,
You don't need to put a Hive site in the classpath. Actually, at runtime, Hive requires this file to be in the classpath but it's not mandatory. All the needed properties are overriden by the Talend components.
What is your error/problem? It's gonna be helpful to help you.
Rémy.

[Anonymous]

Hi all,
did you find the solution? i get the same error message!
thanks.

[Anonymous]

I am also getting the same error..Is there any solution for this?
13/10/29 12:14:10 WARN conf.HiveConf: hive-site.xml not found on CLASSPATH
13/10/29 12:14:11 INFO metastore.HiveMetaStore: 0: Opening raw store with implemenation class rg.apache.hadoop.hive.metastore.ObjectStore
13/10/29 12:14:11 INFO metastore.ObjectStore: ObjectStore, initialize called
13/10/29 12:14:11 INFO DataNucleus.Persistence: Property datanucleus.cache.level2 unknown - will be ignored
13/10/29 12:14:11 INFO DataNucleus.Persistence: Property javax.jdo.option.NonTransactionalRead unknown - will be ignored
13/10/29 12:14:11 INFO DataNucleus.Persistence: ================= Persistence Configuration ===============
13/10/29 12:14:11 INFO DataNucleus.Persistence: DataNucleus Persistence Factory - Vendor: "DataNucleus" Version: "2.0.3"
13/10/29 12:14:11 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"
13/10/29 12:14:11 INFO DataNucleus.Persistence: ===========================================================
13/10/29 12:14:12 INFO Datastore.Schema: Initialising Catalog "", Schema "APP" using "None" auto-start option
etc....

[Anonymous]

Hi,
It is just a warning. It's not an error and this missing file doesn't matter. Everything is supposed to be set up in the generated code. If you have an error, please attach the real problem.
Cheers,
Rémy.

[Anonymous]

Sending the complete error message..
13/10/29 12:14:10 WARN conf.HiveConf: hive-site.xml not found on CLASSPATH
13/10/29 12:14:11 INFO metastore.HiveMetaStore: 0: Opening raw store with implemenation class rg.apache.hadoop.hive.metastore.ObjectStore
13/10/29 12:14:11 INFO metastore.ObjectStore: ObjectStore, initialize called
13/10/29 12:14:11 INFO DataNucleus.Persistence: Property datanucleus.cache.level2 unknown - will be ignored
13/10/29 12:14:11 INFO DataNucleus.Persistence: Property javax.jdo.option.NonTransactionalRead unknown - will be ignored
13/10/29 12:14:11 INFO DataNucleus.Persistence: ================= Persistence Configuration =============== 13/10/29 12:14:11 INF

To see the whole post, download it here
OriginalPost.pdf

[Anonymous]

Hi,
It seems the folder /tmp doesn?t exist in HDFS.
Can you please confirm using:
- hadoop fs -ls /
If you confirm, please create the directory and set up the correct permissions:
- su hdfs
- hadoop fs -mkdir /tmp
- hadoop fs -chmod -R 777 /tmp

[Anonymous]

The error message still exists after changing the folder permission.
Here is the ls result..

:/usr/local/hadoop$ hadoop fs -ls /
Warning: $HADOOP_HOME is deprecated.
Found 5 items
drwxr-xr-x - ciber supergroup 0 2013-09-25 18:02 /app
drwxr-xr-x - ciber supergroup 0 2013-10-28 20:09 /home
drwxr-xr-x - ciber supergroup 0 2013-09-27 17:58 /system
drwxrwxrwx - ciber supergroup 0 2013-10-30 20:56 /tmp
drwxr-xr-x - ciber supergroup 0 2013-10-28 20:18 /user