table1.item_id =
>>> prod_and_ts.product_id AND testingtable1.BUYER_ID = prod_and_ts.USER_ID AND
>>> abs(datediff(mi,
>>> testingtable1.created_time,FROM_UNIXTIME(cast(prod_and_ts.timestamps as
>>> BIGINT <= 15) where prod_and_ts.product_id IS NULL ORDER BY
&g
ct_id AND testingtable1.BUYER_ID = prod_and_ts.USER_ID AND
>> *abs(datediff(mi,
>> testingtable1.created_time,FROM_UNIXTIME(cast(prod_and_ts.timestamps as
>> BIGINT <= 15)* where prod_and_ts.product_id IS NULL ORDER BY
>> testingtable1.buyer_id, testingtable1.created_time
estingtable1.created_time,FROM_UNIXTIME(cast(prod_and_ts.timestamps as
> BIGINT <= 15)* where prod_and_ts.product_id IS NULL ORDER BY
> testingtable1.buyer_id, testingtable1.created_time desc) TT GROUP BY
> TT.BUYER_ID;
>
>
> I am getting below exception as - Its hap
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 Refe
mantic 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
5329 display name Mike
>id5329
>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 :
>
> FA
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
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