Friday 22 November 2013

Talend Open Studio - WARN conf.HiveConf: hive-site.xml not found on CLASSPATH

Need solution for below error in Talend Open Studio?

[WARN conf.HiveConf: hive-site.xml not found on CLASSPATH - TOS for Big Data]

3/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:org.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....




Here is the solution:

1. Make sure /tmp/ and /tmp/hadoop exists in local file system where you installed Talend Open Studio
2. Check your port number -> 10000 is the port for Standalone mode.
3. Start Hive Thrift Server by entering "hive --service hiveserver"



Please let me know if you are not able to solve the issue after following this.

1 comment: