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
+
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
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