Failed Error In Semantic Analysis Unable To Fetch Table
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings semanticexception unable to fetch table and policies of this site About Us Learn more about Stack Overflow
Semantic Exception In Hive
the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation org.apache.hadoop.hive.ql.metadata.hiveexception: unable to fetch table Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up weird exception in Hive : Error in semantic analysis up vote 3 down vote favorite 1 Maybe when you see the "Error in semantic" in the title, you consider it as syntax error? Of course not, I will show you what happened. hive> use android; OK Time taken: 0.223 seconds hive> desc tb_user_basics; OK col_datetime string col_is_day_new string col_is_hour_new string col_ch string ... p_date string p_hourmin string Time taken: 0.189 seconds hive> select count(distinct col_udid) from android.tb_user_basics where p_date>='20121001' and p_date<='20121231'; FAILED: Error in semantic analysis: org.apache.thrift.transport.TTransportException: java.net.SocketTimeoutException: Read timed out hive> > > select count(distinct col_udid) from android.tb_user_basics where p_date>='20121001' and p_date<='20121231'; FAILED: Error in semantic analysis: Unable to fetch table tb_user_basics I'm very sure the table does exist in the database android. After the first statement failed, it appears that the table is missing.(Even I add the db prefix in the table name) I'm wonderring whether it's because of the volumn of data is very big, maybe you have noticed that the time range is [20121001, 20121231]. I run the command before many times, always raise this error. But if I change the contition to "p_date='20121001'", the statement can run normally. (since the volumn is smaller? ) I'm expecting your answers, Thanks. hadoop hive thrift share|improve this question asked Mar 2 '13 at 8:22 HaiWang 72311 add a comment| 1 Answer 1 active oldest votes up vote 1 down v
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 http://grokbase.com/t/cloudera/cdh-user/1363tdhg4f/hive-metastore-semanticexception-unable-to-fetch-table 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
throwing "HiveException: Unable to 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 Cannot connect to GIT repository byshivaraaj How to iterate in Big Data Batch Job bymiroslavnedved 7. Right Answers For The Question [...] bysreecharan rao yadagiri TALEND CDC Issues bymkurup Data problem with [...] byAlmeric 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 hive.metastore.cache.pinobjtypes="