what version of hive are you using ?
On Sat, Apr 30, 2016 at 4:32 PM, Ashish Singh <[email protected]> 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
