hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Akansha Jain <akansha.15au...@gmail.com>
Subject Hive Bucketing
Date Fri, 22 Jan 2016 21:54:36 GMT
Hi All,
I have enabled bucketing in table. I created 256 buckets on user id. Now
when I am querying (select count(*) from table where userid =172839393)
that table, map reduce should only use single partitioned file as input to
mappers. But its considering all files as input to mapper and I don't see
any performance benefit when I run same query in unbucketed table.

Do I have to set any property before running queries on bucketed tables. I
tried join query also, but no performance improvement. In fact, I think
it's taking few more seconds as compared to unbucketed table.

Thanks,
AJ

Mime
View raw message