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
-hiveconf hive.root.logger=DEBUG,FA \
    -hiveconf hive.log.dir="$logDir" \
    -hiveconf hive.log.file="$logFile" \

On Thu, May 31, 2012 at 12:41 AM, wd <[EMAIL PROTECTED]> wrote:

> Nothing output in hive history file, is there an other log file or an
> option to output detail log ?
>
> On Thu, May 31, 2012 at 3:34 PM, Aniket Mokashi <[EMAIL PROTECTED]>
> wrote:
> > 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"
>

--
"...:::Aniket:::... Quetzalco@tl"