Re: Need help with query

2016-09-22 Thread Andrew Sears
Hi there, The detailed error should be in the hiveserver2.log Cheers, Andrew On Wed, Sep 21, 2016 at 3:36 PM, Igor Kravzov < igork.ine...@gmail.com [igork.ine...@gmail.com] > wrote: I run MSCK REPAIR TABLE mytable; and got Error while processing statement: FAILED: Execution Error, return code

Re: Need help with query

2016-09-21 Thread Igor Kravzov
I run MSCK REPAIR TABLE mytable; and got Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask On Mon, Sep 12, 2016 at 6:56 PM, Lefty Leverenz wrote: > Here's a list of the wikidocs about dynamic partitions >

Re: Need help with query

2016-09-12 Thread Lefty Leverenz
Here's a list of the wikidocs about dynamic partitions . -- Lefty On Mon, Sep 12, 2016 at 3:25 PM, Devopam Mittra wrote: > Kindly learn dynamic partition from cwiki. That will be the perfe

Re: Need help with query

2016-09-12 Thread Devopam Mittra
Kindly learn dynamic partition from cwiki. That will be the perfect solution to your requirement in my opinion. Regards Dev On 13 Sep 2016 12:49 am, "Igor Kravzov" wrote: > Hi, > > I have a query like this one > > alter table my_table > add if not exists partition (mmdd=20160912) location