Error In Semantic Analysis Unable To Fetch Table
Contents |
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
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 and how do http://grokbase.com/t/cloudera/cdh-user/1363tdhg4f/hive-metastore-semanticexception-unable-to-fetch-table I fix it?Thanks.________________________________________________________________________________Keith Wiley kwiley@keithwiley.com keithwiley.com music.keithwiley.com"The easy confidence with which I know another man's religion is folly teachesme to suspect that my own is also."-- Mark Twain________________________________________________________________________________ reply Tweet Search Discussions Search All Groups user 4 responses Oldest Nested Keith Wiley Followup: If I run "show tables" then while I get a list from the command line, I get nothing from php. Furthermore, if I attempt to select from http://grokbase.com/t/hive/user/12aj02mtse/error-in-semantic-analysis-unable-to-fetch-table 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 Keith Wiley at Oct 18, 2012 at 9:00 pm ⇧ Followup: If I run "show tables" then while I get a list from the command line, I get 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 kwiley@keithwiley.com 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 ignora
Data Ingestion & https://community.hortonworks.com/questions/34528/unable-to-fetach-table-hive-metaexceptionmessagefo.html Streaming Data Processing Design & Architecture Governance & Lifecycle Hadoop Core Sandbox & Learning Security Solutions All Tags All Questions http://www.bigdatatidbits.cc/2013/04/how-to-recover-from-errors-in-hive.html All Ideas All Repos All Articles All Users All Badges Leaderboard Login Home / Data Processing / 0 Question unable to by Vandana K R · May 20 at 11:43 AM · hiveserver2beelinehdp2.4 Unable to fetch table : Hive MetaException(message:For direct MetaStore DB connections, we don't support retries at the client level.) HDP: 2.3.4 ambari- 2.2.0 I had enabled hiverserver2 unable to fetch HA. I have all my hive services(hive server2, hive metastore, webhat server) in one node.Hive metastore is Mysql and it is in another node.I have properly configured the connection using mysql-connector-java.jar. I am getting an error when i try executing hive commands and jobs through beeline . I connect HA enabled hiverserver2 via beeline using !connect jdbc:hive2://
with different customers in the Big Data space. I will put my findings (mostly technical) to help others, the same way I have found solutions by way of looking at others' blogs .. Menu Widgets Social Links Search Skip to content Home LinkedIn GitHub StackOverflow Good reads - Books Twitter RSS Feed Contact Please email us at: info@bigdatatidbits.cc !doctype> Search for: Wednesday, April 3, 2013 How to recover from errors in Hive interactive mode Lately, working with a team offshore on the same instance of Hive, I would get errors like: hive> show tables; FAILED: Error in metadata: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreClient FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask hive> select count(*) from json_topic1; FAILED: SemanticException Unable to fetch table json_topic1 hive> I was told that generally we get this exception if we the hive console not terminated properly. The fix: Run the jps command, look for "RunJar" process and kill it using kill -9