You should look at hive log and find exact exception. That will give you a hint.
On Thu, May 31, 2012 at 12:33 AM, wd <w...@wdicc.com> wrote: > No problem, thanks for your reply. > I'm very curious why this didn't work, this sql come from hive wiki. > The metadata is store in postgres, does it matter? > > On Thu, May 31, 2012 at 3:26 PM, Bhavesh Shah <bhavesh25s...@gmail.com> > wrote: > > Sorry for previous reply. Actually you had try that one, I didn't saw > that. > > Really Sorry. > > > > On Thu, May 31, 2012 at 12:53 PM, Bhavesh Shah <bhavesh25s...@gmail.com> > > wrote: > >> > >> Hello wd, > >> Try this one... I am not sure about this > >> ALTER TABLE t1 DROP PARTITION(dt = '111') > >> > >> > >> -- > >> Regards, > >> Bhavesh Shah > >> > >> > >> On Thu, May 31, 2012 at 12:49 PM, wd <w...@wdicc.com> wrote: > >>> > >>> 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? > >> > >> > >> > >> > >> > > > > > > > > -- > > Regards, > > Bhavesh Shah > > > -- "...:::Aniket:::... Quetzalco@tl"
