-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 <w...@wdicc.com> 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 <aniket...@gmail.com> > 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 <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" > -- "...:::Aniket:::... Quetzalco@tl"