trying to do on the JT level.
> hive -hiveconf hive.root.logger=ALL,console -e " DDL;"
> hive -hiveconf hive.root.logger=ALL,console -f ddl.sql ;
>
> Hope this helps .
>
> Thanks
> -Abdelrahman
>
>
> On Wed, Jan 30, 2013 at 3:16 PM, Marc Limotte wrote:
>
&g
essage is misleading. Thanks for reporting it!
>
> Mark
>
> On Thu, Jan 31, 2013 at 4:58 PM, Marc Limotte wrote:
>
>> Thanks, Harsh. My issues seems to be related to the one-user limitation
>> of the derby metastore. Once that issue was resolved the "table not found&
t changes anything
> for you?
>
> On Fri, Feb 1, 2013 at 3:27 AM, Marc Limotte wrote:
> > Hi Mark,
> >
> > A table. But it doesn't seem to matter. I get this error on the DROP,
> > before even attempting to create a table. I get the same thing for any
> >
e or a
> view you are trying to drop?
> Mind sharing the create table definition?
>
> Mark
>
>
> On Thu, Jan 31, 2013 at 10:42 AM, Marc Limotte wrote:
>
>> Hi,
>>
>> I'm testing with Hive 0.9.0 (in Amazon EC2, but NOT emr). I'm
>> experie
Hi,
I'm testing with Hive 0.9.0 (in Amazon EC2, but NOT emr). I'm experiencing
a problem where DROP TABLE does not respect the IF EXISTS clause, so it
still throws an error when the table doesn't exist and this causes the
script to stop executing. Here's what it looks like from the hive shell:
7;2010-09-30' AND
> HF.hr
> > < '07' )
> >
> > instead of:
> >
> > (HF.dt = '2010-09-29' AND HF.hr > '07' ) OR (HF.dt = '2010-09-30' AND
> HF.hr
> > <= '07' )
> >
> >
> >
>
ould be:
>
> (HF.dt = '2010-09-29' AND HF.hr >= '07' ) OR (HF.dt = '2010-09-30' AND
> HF.hr < '07' )
>
> instead of:
>
> (HF.dt = '2010-09-29' AND HF.hr > '07' ) OR (HF.dt = '2010-09-30' AND HF.hr
&g
