Thanks. :-) It's working better for me now.
On Mar 7, 2014, at 17:37 , Stephen Sprague wrote:
> short answer: its by position.
>
Keith Wiley kwi...@keithwiley.com keithwiley.commusic.keithwiley.com
short answer: its by position.
Admittedly the problem has gone away. I *think* I may have offered the schema
to the bucketed table creation in the wrong order the first time...I think.
All I know is the problem went away when I tried a second time. Should
inserting a table into another table match the columns by name or do
yeah. that's not right.
1. lets see the output of "show create table foo"
2. what version of hive are you using.
On Fri, Mar 7, 2014 at 11:46 AM, Keith Wiley wrote:
> 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 c
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.bucketi
