[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,
Is your studio located on Windows? If this is the case, could you please confirm you have a "tmp" folder created in C:/ ?
Cheers,
Rémy.

[Anonymous]

Hi Remy,
I am getting the same error after creating a folder /tmp/hadoop under "C" drive..Here is the error..

Starting job Hive_connect at 14:26 05/11/2013.

connecting to socket on port 3743
connected
13/11/05 14:26:02 WARN conf.HiveConf: hive-site.xml not found on CLASSPATH
13/11/05 14:26:02 INFO metastore.HiveMetaStore: 0: Opening raw store with implemenation class rg.apache.hadoop.hive.metastore.ObjectStore
13/11/05 14:26:02 INFO metastore.ObjectStore: ObjectStore, initialize called
13/11/05 14:26:03 INFO DataNucleus.Persistence: Property datanucleus.cache.level2 unknown - will be ignored 13/11/05 14:26:03 INFO DataNucleus.Persistence: Proper

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

[Anonymous]

What's your hadoop distribution?

[Anonymous]

I am using Apache stack.

[Anonymous]

What did you select as the distribution in the talend component?

[Anonymous]

As i showed my screenshot, i had selected "Apache" as distribution and Hive version as "Apache 1.0.0 (Hive 0.9.0).

[Anonymous]

Could you please confirm the "Connection Mode"? As of now, i am using "Embedded" mode.

[Anonymous]

Hi,
Embedded is good. Nevertheless, it would be gret you to confirm that the metastore is started on the port 9083.
What is the output of the command (to be launched on the namenode machine): netstat -ntlup | grep :9083

[Anonymous]

Finally i found the solution for this issue. Though it is very simple, i took a long time to find out.
1. Please make sure about port -> it should be 10000 for standalone mode
2. Start Hive Thrift Server by entering "hive --service hiveserver"
Also check in http://raj-hadoop.blogspot.in/2013/11/talend-open-studio-warn-confhiveconf.html
Thats it! you can play around Talend now!

[Anonymous]

Standalone = 10000
Embedded = 9083
There are default ports. Need to make sure this is the same for your clusters.