Re: confused on different behavior of Bucketized tables do not support INSERT INTO

2012-05-31 Thread Mark Grover
e created a JIRA for this (https://issues.apache.org/jira/browse/HIVE-3077). Hope that helps, Mark - Original Message - From: "Bruce Bian" To: user@hive.apache.org Sent: Thursday, May 31, 2012 10:16:03 AM Subject: Re: confused on different behavior of Bucketized tables do not suppo

Re: confused on different behavior of Bucketized tables do not support INSERT INTO

2012-05-31 Thread Bruce Bian
So I did another test on this. hive> create table test(foo int,bar string) clustered by(foo) sorted by (foo asc) into 2 buckets; OK Time taken: 0.097 seconds hive> create table test2 (foo int,bar string) clustered by(foo) sorted by (foo asc) into 2 buckets; OK hive> LOAD DATA LOCAL INPATH 'hive/exa

Re: confused on different behavior of Bucketized tables do not support INSERT INTO

2012-05-31 Thread Bruce Bian
I'm using hive 0.9.0 On Thursday, May 31, 2012, Bruce Bian wrote: > Hi, > I've got a table vt_new_data which is defined as follows: > CREATE TABLE VT_NEW_DATA > ( > V_ACCOUNT_NUM string > ,V_ACCOUNT_MODIFIER_NUM string > ,V_DEPOSIT_TYPE_CD string > ,V_DEPOSIT_TERM int > ,V_LE