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