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

Wed, 27 Jun 2012 05:37:26 -0700 

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

Reply via email to