Re: FAILED: Error in semantic analysis: line 1:29 Invalid Table Alias or Column Reference

[rajesh.ba...@orkash.com]

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> <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 :
    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