Hi, I think I've isolated my Hive GROUP BY problem to this question,
In Hive, the GROUP BY needs to be strict. I mean hive> select property_id["property_id"], log_timestamp from trans group by property_id["property_id"]; FAILED: Error in semantic analysis: Line 1:35 Expression not in GROUP BY key log_timestamp and that error message means it. However, a similar quiery in MySQL SELECT ext_booking_id, product_id FROM offer_sets group by ext_booking_id; works just fine. HIve seems to be on the right about this, and MySQL should not allow this. What do you all think? Thank you, Mark
