Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB