hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Kerzner <mark.kerz...@shmsoft.com>
Subject Does the "GROUP BY" need to be strict in Hive?
Date Wed, 19 Oct 2011 20:06:01 GMT
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

Mime
View raw message