hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "rajesh.bawal@orkash.com" <rajesh.ba...@orkash.com>
Subject Re: FAILED: Error in semantic analysis: line 1:29 Invalid Table Alias or Column Reference
Date Wed, 27 Jun 2012 12:55:38 GMT
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.bawal@orkash.com 
> <mailto:rajesh.bawal@orkash.com> <rajesh.bawal@orkash.com 
> <mailto:rajesh.bawal@orkash.com>> wrote:
>
>     Hi Everyone,
>     I have a column family(table) named comments in Cassandra with
>     data in following format :
>     Key        Value
>                   comment_id            502587858
>                   Comment                Some comments
>                   crawled_page_id     23821746
>                   date                        2012-04-19_14:14:55
>                   depth                       0
>                   dislikes                     0
>     5329       display name           Mike
>                    id                            5329
>                    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
>



Mime
View raw message