Hive Failed Error In Semantic Analysis Unable To Fetch Table
192.168.1.1, and 192.168.1.2connects to metaserver on 192.168.1.1I login to the server 192.168.1.1, and create the table table_to_drop_test .I login to the server 192.168.1.2 to drop the table, but failed.The version of hive is hive-0.9.0-cdh4.1.1.Anyone can help?The error log is:ERROR ql.Driver (SessionState.java:printError(403)) - FAILED:SemanticException Unable to fetch table table_to_drop_testorg.apache.hadoop.hive.ql.parse.SemanticException: Unable to fetch tabletest_changeatorg.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getMetaData(SemanticAnalyzer.java:1130)atorg.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:7541)atorg.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:246)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:905)atorg.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:258)atorg.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:215)atorg.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:406)at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:744)at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:607)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)atsun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)at java.lang.reflect.Method.invoke(Method.java:597)at org.apache.hadoop.util.RunJar.main(RunJar.java:208)Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: Unable tofetch table test_changeat org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:897)at org.apache.hadoop.hive.ql.metadata.Hive.getTable(Hive.java:831)atorg.apache.hadoop.hive.ql.parse.SemanticAnalyzer.getMetaData(SemanticAnalyzer.java:960)... 15 moreCaused by: org.apache.thrift.transport.TTransportExceptionatorg.apache.thrift.transport.TIOStreamTransport.read(TIOStreamTransport.java:132)atorg.apache.thrift.transport.TTransport.readAll(TTransport.java:84)atorg.apache.thrift.protocol.TBinaryProtocol.readAll(TBinaryProtocol.java:378)atorg.apache.thrift.protocol.TBinaryProtocol.readI32(TBinaryProtocol.java:297)atorg.apache.thrift.protocol.TBinaryProtocol.readMessageBegin(TBinaryProtocol.java:204)atorg.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:69)-- reply Tweet Search Discussions Search All Groups Hadoop cdh-user 1 response Oldest Nested Liu Jack There are some error log in the file /tmp/root/hive.log: NestedThrowables: java.sql.SQLExc
with -e it works. If I run the same command inside hive (without -e) it still works...but if I exec it with a -e from php (so obviously the apache user), I get "Error in semantic analysis: Unable to fetch table [tablename]". Bear in mind that this overall system worked perfectly for weeks. I haven't modified the code or anything. What did change was I had to reinstall hadoop and hive and I'm sure some configuration parameter is not correct now. I found some Google references to this error but no clear-but solutions.What does this error mean http://grokbase.com/t/cloudera/cdh-user/1363tdhg4f/hive-metastore-semanticexception-unable-to-fetch-table and how do I fix it?Thanks.________________________________________________________________________________ Keith Wiley keithwiley.com music.keithwiley.com"The easy confidence with which I know another man's religion is folly teaches me to suspect that my own is also." -- Mark Twain ________________________________________________________________________________ hivefetchsemanticcommandtable asked Oct 18 2012 at 20:46 in Hive-User by Keith Wiley Facebook Google+ Twitter 4 Answers Followup: If I run "show tables" then while I get a list from the command line, I get https://qnalist.com/questions/19333/error-in-semantic-analysis-unable-to-fetch-table nothing from php. Furthermore, if I attempt to select from a bogus tablename on the command line, I get that same error, "semantic error" and whatnot...so it looks like the real problem is that when apache/php runs hive, it doesn't see the table list.Like I said, this used to work...so I'm sure I need to get something configured properly, I just don't remember how. I do see that I am defining HIVE_HOME in my .bashrc...Do I need to do something like this for the apache account or as a HIVE parameter?________________________________________________________________________________ Keith Wiley keithwiley.com music.keithwiley.com"What I primarily learned in grad school is how much I *don't* know. Consequently, I left grad school with a higher ignorance to knowledge ratio than when I entered." -- Keith Wiley ________________________________________________________________________________ answered Oct 18 2012 at 21:00 by Keith Wiley What php, you are using exec('hive -S -e "select * from some_table"') or something like that in php? answered Oct 19 2012 at 05:15 by MiaoMiao I never needed the -S. I would just call it with -e, but yeah, that's the basic idea. The output is gathered in the remaining optional arguments to exec(). answered Oct 19 2012 at 06:48 by Keith Wiley Hi KeithCan you get anythi
throwing "HiveException: Unable to http://osdir.com/ml/general/2013-02/msg14257.html fetch table
discuss with dev team? Forum is the right place! On break with the proprietary solutions, Talend Open Data Solutions has the most open, productive, powerful and flexible Data Management solutions or manage your data warehouse- Open Studio -to the data integration market. Talend integrates, consolidates, transforms any data - Business - Extract Transform Load - ETL - EAI - ERP Index Tags Timeline User list Rules Search You are not logged in. Topics: Active | Unanswered Announcement [2016-09-29] For Test Only, Talend Open Studio's 6.3.0 RC1 release is available [2016-09-20] Free Trial: Download the New Talend Big Data Sandbox [2016-09-15] Talend Open Studio v6.1.2 is now available for download [2016-09-14] Sign Up Now For Talend Connect 2016 in Paris [2016-09-09] Have a Talend Story Worth Sharing? You Too Can Be on The Podium Unanswered posts HTTP Header in tRest component byhansmei cannot connect to Azure (Ubuntu version) byjimggg Adjustment of tSetProxy for https byhansmei What type of analysis is this? byDL001 tMSSQLConnection does not reconnect after connection loss bymartin.pelikan Index »Big Data - Configuration, usage and feedback »WARN conf.HiveConf: hive-site.xml not found on CLASSPATH Pages: 1 Post reply #12013-04-19 11:28:27 l.mouna Member 40 posts l.mouna said: WARN conf.HiveConf: hive-site.xml not found on CLASSPATH Tags: [error] HelloI'm trying to execute a select query with Hive.As components I use: tHiveConnexion, tHiveRow and tLogRowi get the following error:13/04/19 11:21:33 WARN conf.HiveConf: hive-site.xml not found on CLASSPATH13/04/19 11:21:33 INFO metastore.HiveMetaStore: 0: Opening raw store with implemenation class:org.apache.hadoop.hive.metastore.ObjectStore13/04/19 11:21:33 INFO metastore.ObjectStore: ObjectStore, initialize called13/04/19 11:21:33 INFO DataNucleus.Persistence: Property datanucleus.cache.level2 unknown - will be ignored13/04/19 11:21:35 INFO metastore.ObjectStore: Setting MetaStore object pin classes with hi