can u provide your query On Wed, Jun 27, 2012 at 6:06 PM, rajesh.ba...@orkash.com < 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
