Re: Drop table if exists

2011-01-19 Thread Ajo Fod
Ah! ok. Thanks. -Ajo. On Wed, Jan 19, 2011 at 9:03 AM, Ping Zhu wrote: > I think only Hive 0,7 or later accepts syntax drop table if exists. >  http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL#Drop_Table > > > On Wed, Jan 19, 2011 at 8:54 AM, Ajo Fod wrote: >> >&g

Re: Drop table if exists

2011-01-19 Thread Ping Zhu
I think only Hive 0,7 or later accepts syntax drop table if exists. http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL#Drop_Table On Wed, Jan 19, 2011 at 8:54 AM, Ajo Fod wrote: > I don't think this works. > >> drop table if exists ; > ... it seems to fail on the if

Drop table if exists

2011-01-19 Thread Ajo Fod
I don't think this works. >> drop table if exists ; ... it seems to fail on the if exists part. Is anyone's experience different ?... I'm using CDH3 ... Hive 0.5.0. -Ajo