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

Switch to Threaded View
Hive, mail # user - Hive partition problem


Copy link to this message
-
Re: Hive partition problem
Aniket Mokashi 2012-05-31, 07:34
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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]>
> 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 <[EMAIL PROTECTED]>
> > 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 <[EMAIL PROTECTED]> 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"