Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hive.apache.org
Received-SPF: pass (athena.apache.org: domain of kwiley@keithwiley.com
 designates 64.5.38.13 as permitted sender)
From: Keith Wiley <kwiley@keithwiley.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: quoted-printable
Subject: bucketed table problems
Date: Fri, 7 Mar 2014 11:46:47 -0800
Message-Id: <DB7966A5-1B34-4B5C-AA41-05BD25565C48@keithwiley.com>
To: user@hive.apache.org
Mime-Version: 1.0 (Apple Message framework v1085)

I want to convert a table to a bucketed table, so I made a new table =
with the same schema as the old table and specified a cluster column:

create table foo_bucketed
(
a string,
b int,
c float
)
clustered by (b) into 10 buckets;

Then I populate it from my original table:

set hive.enforce.bucketing =3D true;
insert overwrite table foo_bucketed
select * from foo;

All of the data goes into the first bucket, leaving the remaining 9 =
buckets empty (in the file system, the remaining 9 files are 0 size).  =
Furthermore, the cluster column is now NULL.  Its values have been =
completely erased by the insertion (which might explain how they all =
ended up in a single bucket of course).

=
__________________________________________________________________________=
______
Keith Wiley     kwiley@keithwiley.com     keithwiley.com    =
music.keithwiley.com

"Yet mark his perfect self-contentment, and hence learn his lesson, that =
to be
self-contented is to be vile and ignorant, and that to aspire is better =
than to
be blindly and impotently happy."
                                           --  Edwin A. Abbott, Flatland
=
__________________________________________________________________________=
______