One Star

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

Hello
I'm trying to execute a select query with Hive.
As components I use: tHiveConnexion, tHiveRow and tLogRow
i get the following error:
13/04/19 11:21:33 WARN conf.HiveConf: hive-site.xml not found on CLASSPATH
13/04/19 11:21:33 INFO metastore.HiveMetaStore: 0: Opening raw store with implemenation classSmiley Surprisedrg.apache.hadoop.hive.metastore.ObjectStore
13/04/19 11:21:33 INFO metastore.ObjectStore: ObjectStore, initialize called
13/04/19 11:21:33 INFO DataNucleus.Persistence: Property datanucleus.cache.level2 unknown - will be ignored
13/04/19 11:21:35 INFO metastore.ObjectStore: Setting MetaStore object pin classes with hive.metastore.cache.pinobjtypes="Table,StorageDescriptor,SerDeInfo,Partition,Database,Type,FieldSchema,Order"
13/04/19 11:21:35 INFO metastore.ObjectStore: Initialized ObjectStore
Hive history file=/tmp/admin.qlv/hive_job_log_admin.qlv_201304191121_1731951740.txt
13/04/19 11:21:36 INFO exec.HiveHistory: Hive history file=/tmp/admin.qlv/hive_job_log_admin.qlv_201304191121_1731951740.txt
13/04/19 11:21:36 INFO service.HiveServer: Putting temp output to file \tmp\admin.qlv\admin.qlv_2013041911213195493883905264195.pipeout
13/04/19 11:21:36 INFO service.HiveServer: Running the query: set hive.fetch.output.serde = org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
13/04/19 11:21:36 INFO service.HiveServer: Putting temp output to file \tmp\admin.qlv\admin.qlv_2013041911213195493883905264195.pipeout
13/04/19 11:21:36 INFO service.HiveServer: Running the query: SELECT pokes.foo, pokes.bar FROM pokes
13/04/19 11:21:36 INFO ql.Driver:
13/04/19 11:21:36 INFO ql.Driver:
13/04/19 11:21:36 INFO parse.ParseDriver: Parsing command: SELECT pokes.foo, pokes.bar FROM pokes
13/04/19 11:21:36 INFO parse.ParseDriver: Parse Completed
13/04/19 11:21:36 INFO parse.SemanticAnalyzer: Starting Semantic Analysis
13/04/19 11:21:36 INFO parse.SemanticAnalyzer: Completed phase 1 of Semantic Analysis
13/04/19 11:21:36 INFO parse.SemanticAnalyzer: Get metadata for source tables
13/04/19 11:21:36 INFO hive.metastore: Trying to connect to metastore with URI thrift://:
13/04/19 11:21:36 ERROR parse.SemanticAnalyzer: org.apache.hadoop.hive.ql.metadata.HiveException: Unable to fetch table pokes
at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:897)
at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:831)
at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getMetaData(SemanticAnalyzer.java:954)
at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:7524)
at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:243)
at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:431)
at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:336)
at org.apache.hadoop.hive.ql.Driver.run(Driver.java:909)
at org.apache.hadoop.hive.service.HiveServer$HiveServerHandler.execute(HiveServer.java:191)
at org.apache.hadoop.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:187)
at org.apache.hadoop.hive.jdbc.HiveStatement.execute(HiveStatement.java:127)
at bigdataproject.requetehive_0_1.RequeteHive.tHiveRow_1Process(RequeteHive.java:745)
at bigdataproject.requetehive_0_1.RequeteHive.runJobInTOS(RequeteHive.java:1058)
at bigdataproject.requetehive_0_1.RequeteHive.main(RequeteHive.java:914)
Caused by: java.lang.NullPointerException
at org.apache.thrift.transport.TSocket.open(TSocket.java:166)
at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.openStore(HiveMetaStoreClient.java:264)
at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.open(HiveMetaStoreClient.java:197)
at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.(HiveMetaStoreClient.java:157)
at org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:2093)
at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:2103)
at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:889)
... 13 more
FAILED: Error in semantic analysis: Unable to fetch table pokes
13/04/19 11:21:36 ERROR ql.Driver: FAILED: Error in semantic analysis: Unable to fetch table pokes
org.apache.hadoop.hive.ql.parse.SemanticException: Unable to fetch table pokes
at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getMetaData(SemanticAnalyzer.java:1129)
at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:7524)
at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:243)
at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:431)
at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:336)
at org.apache.hadoop.hive.ql.Driver.run(Driver.java:909)
at org.apache.hadoop.hive.service.HiveServer$HiveServerHandler.execute(HiveServer.java:191)
at org.apache.hadoop.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:187)
at org.apache.hadoop.hive.jdbc.HiveStatement.execute(HiveStatement.java:127)
at bigdataproject.requetehive_0_1.RequeteHive.tHiveRow_1Process(RequeteHive.java:745)
at bigdataproject.requetehive_0_1.RequeteHive.runJobInTOS(RequeteHive.java:1058)
at bigdataproject.requetehive_0_1.RequeteHive.main(RequeteHive.java:914)
Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: Unable to fetch table pokes
at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:897)
at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:831)
at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getMetaData(SemanticAnalyzer.java:954)
... 11 more
Caused by: java.lang.NullPointerException
at org.apache.thrift.transport.TSocket.open(TSocket.java:166)
at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.openStore(HiveMetaStoreClient.java:264)
at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.open(HiveMetaStoreClient.java:197)
at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.(HiveMetaStoreClient.java:157)
at org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:2093)
at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:2103)
at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:889)
... 13 more
13/04/19 11:21:36 INFO ql.Driver:
13/04/19 11:21:36 INFO ql.Driver:
13/04/19 11:21:36 INFO ql.Driver:
Query returned non-zero code: 10, cause: FAILED: Error in semantic analysis: Unable to fetch table pokes
.---+---.
|tLogRow_1|
|=--+--=|
|foo|bar|
|=--+--=|
'---+---'
i get resultat without problem when i query from the console with hive command.
Any idea of what i should do?
ps: how can i join image?
Thanks..!

  • Big Data
9 REPLIES
Community Manager

Re: WARN conf.HiveConf: hive-site.xml not found on CLASSPATH

Hi l.mouna
As I known, this is related to Hadoops installation, we have nothing to do in Talend. You can refer to this page and follows the suggestion,
http://stackoverflow.com/questions/14353394/hive-site-xml-not-found-on-classpath
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: WARN conf.HiveConf: hive-site.xml not found on CLASSPATH

Hi Shong,
Ok, i see. i'm trying to find what's wrong since days but in vain. i think hat's like you said about the configuration. I'am trying to configure hive in the pseudo-distributed mode...
Thank you
Mouna
One Star

Re: WARN conf.HiveConf: hive-site.xml not found on CLASSPATH

Hi Shong,
i didn't find the solution, don't you have any idea about what it could be?
Thanks
Community Manager

Re: WARN conf.HiveConf: hive-site.xml not found on CLASSPATH

I have not personally installed hadoop yet, I use the hadoop installed by our colleague, I don't know the solution at the moment, but I will come back to this topic and share it once I found the solution.
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: WARN conf.HiveConf: hive-site.xml not found on CLASSPATH

Thank you very much Shong! It'll make me crazy... =(
One Star

Re: WARN conf.HiveConf: hive-site.xml not found on CLASSPATH

Hi Shong,
I am also facing the same issue and I am trying to connect to a Horton Works cluster. Could you please assist?
One Star

Re: WARN conf.HiveConf: hive-site.xml not found on CLASSPATH

IS there any solution for this issue? I am also getting the same.
One Star

Re: WARN conf.HiveConf: hive-site.xml not found on CLASSPATH

Dear All,
Same issue was faced by me.
I have resolved it by moving the temp table which is created in mysql for loading the data.
for detail information Please check db logs.
Regards,
Varun Kumar.P
Community Manager

Re: WARN conf.HiveConf: hive-site.xml not found on CLASSPATH

Hello All
You can find more discussions and a solution in this topic:
http://www.talendforge.org/forum/viewtopic.php?id=26142
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business