FAILED: Error in semantic analysis: line 1:29 Invalid Table Alias or Column Reference comment_id

Hi, I have a column family named comments with data in following format : KeyValue comment_id502587858 CommentSome comments crawled_page_id 23821746 date2012-04-19_14:14:55

FAILED: Error in semantic analysis: line 1:29 Invalid Table Alias or Column Reference

Hi Everyone, I have a column family(table) named comments in Cassandra with data in following format : KeyValue comment_id502587858 CommentSome comments crawled_page_id 23821746 date

Re: FAILED: Error in semantic analysis: line 1:29 Invalid Table Alias or Column Reference

27, 2012 at 6:06 PM, rajesh.ba...@orkash.com <mailto:rajesh.ba...@orkash.com> <mailto:rajesh.ba...@orkash.com>> wrote: Hi Everyone, I have a column family(table) named comments in Cassandra with data in following format : KeyValue

Where does hive store join query results

Hi Everyone, I am running a join query on two tables in hive. When I run the join query, hive runs a map-reduce job.I can't seem to find the results of the join query. Can someone tell me where hive stores the results of the join query. Thanks Rajesh Kumar