Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive >> mail # user >> FAILED: Error in semantic analysis: line 1:29 Invalid Table Alias or Column Reference comment_id


+
rajesh.bawal@...) 2012-06-25, 10:27
+
rajesh.bawal@...) 2012-06-27, 12:36
+
Nitin Pawar 2012-06-27, 12:50
+
rajesh.bawal@...) 2012-06-27, 12:55
Copy link to this message
-
Re: FAILED: Error in semantic analysis: line 1:29 Invalid Table Alias or Column Reference
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, [EMAIL PROTECTED] <
[EMAIL PROTECTED]> 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, [EMAIL PROTECTED] <
> [EMAIL PROTECTED]> 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
+
Jamal B 2013-06-03, 19:49