hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nitin Pawar <nitinpawar...@gmail.com>
Subject Re: FAILED: Error in semantic analysis: line 1:29 Invalid Table Alias or Column Reference
Date Wed, 27 Jun 2012 13:59:28 GMT
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.bawal@orkash.com <
rajesh.bawal@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.bawal@orkash.com <
> 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
>
>
>
>


-- 
Nitin Pawar

Mime
View raw message