The order should be the same.
Can you file a jira for this issue ? We should throw an error.
Thanks,
-namit
From: Thiruvel Thirumoolan [thiru...@yahoo-inc.com]
Sent: Friday, August 06, 2010 12:29 AM
To: hive-user@hadoop.apache.org
Subject: Shud partition order be same in create and insert?
Hello,
When the order of partitioning columns is different in create table and insert,
I am not able to query for any data. However if the order is the same its
possible to see data.
Should partitioning order be maintained through all inserts? As you see below,
kv2.txt is still on HDFS and 2 different partition orders are created. Running
off hive trunk.
hive CREATE TABLE invites (foo INT, bar STRING) PARTITIONED BY (ds STRING,
country STRING);
hive LOAD DATA LOCAL INPATH '/tmp/kv2.txt' OVERWRITE INTO TABLE invites
PARTITION (country='india', ds='2008-08-15');
hive select * from invites;
hive
[thiru...@hive]$ hadoop fs -lsr /user/hive/warehouse/invites
drwxr-xr-x - thiruvel supergroup 0 2010-08-06 12:52
/user/hive/warehouse/invites/country=india
drwxr-xr-x - thiruvel supergroup 0 2010-08-06 12:52
/user/hive/warehouse/invites/country=india/ds=2008-08-15
-rw-r--r-- 1 thiruvel supergroup 5791 2010-08-06 12:52
/user/hive/warehouse/invites/country=india/ds=2008-08-15/kv2.txt
drwxr-xr-x - thiruvel supergroup 0 2010-08-06 12:52
/user/hive/warehouse/invites/ds=2008-08-15
drwxr-xr-x - thiruvel supergroup 0 2010-08-06 12:52
/user/hive/warehouse/invites/ds=2008-08-15/country=india
[thiruvel@ hive]$
Thanks,
Thiruvel