hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thejas Nair <thejas.n...@gmail.com>
Subject Re: Bucketing issue with Hive
Date Sun, 01 May 2016 05:00:02 GMT
what version of hive are you using ?


On Sat, Apr 30, 2016 at 4:32 PM, Ashish Singh <ashishleo25@gmail.com> wrote:
> Hi Friends,
>
> I am facing an issue with Buckets in Hive , Need some inputs / guidance
>
> We initially created one table and whenever query (simple aggregation query
> on one table) was executed multiple mappers were launched.
> Later on considering optimization perspective, we altered table to include
> bucketing on one column. Since then queries on this table are executing
> with single mapper and hence significant delay in production queries
> execution.
>
> As mentioned in hive documentation, altering table to include bucketing
> doesn't impact previous data, but this behavior was not expected.
>
> Table is ORC formatted and with Snappy Compression.
> Disk size of table is approx. 3.5 GB with 70 million records
>
>
> Thanks,
> Ashish Singh

Mime
View raw message