Re: Delete ORC partition

Thanks a lot. That worked for me. On Wed, Mar 25, 2015 at 2:40 AM, Steve Howard wrote: > What happens if you try it with the actual colon rather than the encoded > value? > > alter table my_tbl drop partition (date='2014-01-02 00:00:00.0') ; > > On Tue, Mar 24, 2015 at 12:37 AM, Megha Garg > w

Re: Delete ORC partition

What happens if you try it with the actual colon rather than the encoded value? alter table my_tbl drop partition (date='2014-01-02 00:00:00.0') ; On Tue, Mar 24, 2015 at 12:37 AM, Megha Garg wrote: > Thanks for correcting, that was a typo. My actual command is :- > > alter table my_tbl drop

Re: Delete ORC partition

Thanks for correcting, that was a typo. My actual command is :- alter table my_tbl drop partition (date='2014-01-02 00%3A00%3A00.0') ; On Tue, Mar 24, 2015 at 9:35 AM, Steve Howard wrote: > Do you have a typo in the partition name? There is a space in the list > you have between day and hour,

Re: Delete ORC partition

Do you have a typo in the partition name? There is a space in the list you have between day and hour, but not in your drop statement. Also %3A is hex for the ":" character, but you don't have that in you partition name to get dropped. Sent from my iPad > On Mar 23, 2015, at 11:46 PM, Megha Ga

Re: Delete ORC partition

I am not getting any error and my hive version is 0.13 On Mon, Mar 23, 2015 at 8:57 PM, Alan Gates wrote: > Are you getting an error or does the partition just not get deleted? If > you get an error message can you share it? What version of Hive are you > using? > > Alan. > > Megha Garg >

Re: Delete ORC partition

Are you getting an error or does the partition just not get deleted? If you get an error message can you share it? What version of Hive are you using? Alan. Megha Garg March 23, 2015 at 5:43 Hi, I am new to hive. I have created one ORC table with partitioning