Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive >> mail # user >> Hive partition problem


Copy link to this message
-
Hive partition problem
hi,

We setup a new hive 0.9 client, Found some sql did not work, for example

hive> create table t1(a int) partitioned by ( dt int );
OK
Time taken: 0.097 seconds
hive> load data local inpath '/tmp/t' into table t1 partition (dt=111);
Copying data from file:/tmp/t
Copying file: file:/tmp/t
Loading data to table default.t1 partition (dt=111)
OK
Time taken: 0.375 seconds
hive> show partitions t1;
OK
dt=111
Time taken: 0.108 seconds
hive> alter table t1 drop partition ( dt=111 );
FAILED: Error in semantic analysis: Partition not found dt = 111
hive> alter table t1 drop partition ( dt='111' );
FAILED: Error in semantic analysis: Partition not found dt = '111'
So, how to delete the partition?
+
Bhavesh Shah 2012-05-31, 07:23
+
Bhavesh Shah 2012-05-31, 07:26
+
wd 2012-05-31, 07:33
+
Aniket Mokashi 2012-05-31, 07:34
+
wd 2012-05-31, 07:41
+
Aniket Mokashi 2012-05-31, 07:48
+
wd 2012-05-31, 07:56
+
wd 2012-05-31, 08:31
+
Malcolm Tye 2012-05-31, 09:16
+
wd 2012-05-31, 09:37