FAILED: Error in semantic analysis: line 1:29 Invalid Table Alias or Column Reference comment_id
Hi, I have a column family named comments with data in following format : KeyValue comment_id502587858 CommentSome comments crawled_page_id 23821746 date2012-04-19_14:14:55 depth 0 dislikes 0 5329 display name Mike id5329 username Mike OB and so on when I try to run a query using where clause, order by or sort by I get this error : FAILED: Error in semantic analysis: line 1:29 Invalid Table Alias or Column Reference comment_id 2012-06-25 15:33:20,702 ERROR ql.Driver (SessionState.java:printError(343)) - FAILED: Error in semantic analysis: line 1:29 Invalid Table Alias or Column Reference comment_id org.apache.hadoop.hive.ql.parse.SemanticException: line 1:29 Invalid Table Alias or Column Reference comment_id at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genExprNodeDesc(SemanticAnalyzer.java:6761) at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genFilterPlan(SemanticAnalyzer.java:1349) at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genFilterPlan(SemanticAnalyzer.java:1330) at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genBodyPlan(SemanticAnalyzer.java:5401) at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genPlan(SemanticAnalyzer.java:6016) at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:6601) at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:238) at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:340) at org.apache.hadoop.hive.ql.Driver.run(Driver.java:736) at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:164) at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:241) at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:456) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.hadoop.util.RunJar.main(RunJar.java:156) Could someone tellme what am I doing wrong and how to fix the problem. Thanks Rajesh Kumar
FAILED: Error in semantic analysis: line 1:29 Invalid Table Alias or Column Reference
Hi Everyone, I have a column family(table) named comments in Cassandra with data in following format : KeyValue comment_id502587858 CommentSome comments crawled_page_id 23821746 date2012-04-19_14:14:55 depth 0 dislikes 0 5329 display name Mike id5329 username Mike OB and so on when I try to run a query on hive using where clause, order by or sort by I get this error : FAILED: Error in semantic analysis: line 1:29 Invalid Table Alias or Column Reference comment_id 2012-06-25 15:33:20,702 ERROR ql.Driver (SessionState.java:printError(343)) - FAILED: Error in semantic analysis: line 1:29 Invalid Table Alias or Column Reference comment_id org.apache.hadoop.hive.ql.parse.SemanticException: line 1:29 Invalid Table Alias or Column Reference comment_id at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genExprNodeDesc(SemanticAnalyzer.java:6761) at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genFilterPlan(SemanticAnalyzer.java:1349) at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genFilterPlan(SemanticAnalyzer.java:1330) at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genBodyPlan(SemanticAnalyzer.java:5401) at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genPlan(SemanticAnalyzer.java:6016) at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:6601) at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:238) at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:340) at org.apache.hadoop.hive.ql.Driver.run(Driver.java:736) at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:164) at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:241) at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:456) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.hadoop.util.RunJar.main(RunJar.java:156) Could someone tellme what am I doing wrong and how to fix the problem. Thanks in advance Rajesh Kumar
Re: FAILED: Error in semantic analysis: line 1:29 Invalid Table Alias or Column Reference
The query : SELECT * FROM comments where comment_id = 502587858; Select * from comments works fine. But whenever I use where, group by , order by, sort by ...I get the same error. Thanks Rajesh Kumar On Wednesday 27 June 2012 06:20 PM, Nitin Pawar wrote: can u provide your query On Wed, Jun 27, 2012 at 6:06 PM, rajesh.ba...@orkash.com <mailto:rajesh.ba...@orkash.com> <mailto:rajesh.ba...@orkash.com>> wrote: Hi Everyone, I have a column family(table) named comments in Cassandra with data in following format : KeyValue comment_id502587858 CommentSome comments crawled_page_id 23821746 date2012-04-19_14:14:55 depth 0 dislikes 0 5329 display name Mike id5329 username Mike OB and so on when I try to run a query on hive using where clause, order by or sort by I get this error : FAILED: Error in semantic analysis: line 1:29 Invalid Table Alias or Column Reference comment_id 2012-06-25 15:33:20,702 ERROR ql.Driver (SessionState.java:printError( 343)) - FAILED: Error in semantic analysis: line 1:29 Invalid Table Alias or Column Reference comment_id org.apache.hadoop.hive.ql. parse.SemanticException: line 1:29 Invalid Table Alias or Column Reference comment_id at org.apache.hadoop.hive.ql. parse.SemanticAnalyzer. genExprNodeDesc( SemanticAnalyzer.java:6761) at org.apache.hadoop.hive.ql. parse.SemanticAnalyzer. genFilterPlan( SemanticAnalyzer.java:1349) at org.apache.hadoop.hive.ql. parse.SemanticAnalyzer. genFilterPlan( SemanticAnalyzer.java:1330) at org.apache.hadoop.hive.ql. parse.SemanticAnalyzer. genBodyPlan(SemanticAnalyzer. java:5401) at org.apache.hadoop.hive.ql. parse.SemanticAnalyzer. genPlan(SemanticAnalyzer.java: 6016) at org.apache.hadoop.hive.ql. parse.SemanticAnalyzer. analyzeInternal( SemanticAnalyzer.java:6601) at org.apache.hadoop.hive.ql. parse.BaseSemanticAnalyzer. analyze(BaseSemanticAnalyzer. java:238) at org.apache.hadoop.hive.ql. Driver.compile(Driver.java: 340) at org.apache.hadoop.hive.ql. Driver.run(Driver.java:736) at org.apache.hadoop.hive.cli. CliDriver.processCmd( CliDriver.java:164) at org.apache.hadoop.hive.cli. CliDriver.processLine( CliDriver.java:241) at org.apache.hadoop.hive.cli. CliDriver.main(CliDriver.java: 456) at sun.reflect. NativeMethodAccessorImpl. invoke0(Native Method) at sun.reflect. NativeMethodAccessorImpl. invoke( NativeMethodAccessorImpl.java: 39) at sun.reflect. DelegatingMethodAccessorImpl. invoke( DelegatingMethodAccessorImpl. java:25) at java.lang.reflect.Method. invoke(Method.java:597) at org.apache.hadoop.util.RunJar. main(RunJar.java:156) Could someone tellme what am I doing wrong and how to fix the problem. Thanks in advance Rajesh Kumar -- Nitin Pawar
Where does hive store join query results
Hi Everyone, I am running a join query on two tables in hive. When I run the join query, hive runs a map-reduce job.I can't seem to find the results of the join query. Can someone tell me where hive stores the results of the join query. Thanks Rajesh Kumar
