we will need the query error is at 29th char
may be some "," missing or like that On Wed, Jun 27, 2012 at 6:25 PM, rajesh.ba...@orkash.com < rajesh.ba...@orkash.com> wrote: > 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 < > 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 > > > > -- Nitin Pawar
