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


+
wd 2012-05-31, 07:19
+
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
Copy link to this message
-
Re: Hive partition problem
wd 2012-05-31, 07:41
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 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