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
