hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rob Paul <urlop...@gmail.com>
Subject FAILED: SemanticException [Error 10007]: Ambiguous column reference product_class_id
Date Mon, 31 Mar 2014 19:12:04 GMT
Hi,
I am running this query of two versions of the hive:hive-0.9 and hive-0.11

SELECT `c_53`.`product_class_id` AS `C_0`, `c_53`.`product_class_id`
AS `C_1`, `c_53`.`brand_name` AS `c_43` FROM `dflo`.`product` `c_4133`
LEFT OUTER JOIN ( SELECT * FROM `dflo`.`product` `c_4131` JOIN
`dflo`.`product` `c_4132` ON (`c_4131`.`brand_name` =
`c_4132`.`brand_name`) )`c_53` ON (`c_4133`.`brand_name` =
`c_53`.`brand_name`) WHERE (`c_53`.`product_id` IS NULL ) ORDER BY
`C_1` DESC, `c_43` DESC;

FAILED: SemanticException [Error 10007]: Ambiguous column reference
product_class_id


Does anyone knows whats going on?
Any help is highly appreciated.
Thanks
Rob

Mime
View raw message