Re: ORC Table creation failure

2015-05-21 Thread vivek veeramani
Hi Abe, The column in the WHERE clause is also string. I tried creating without any filters, just a CTAS and that failed too. Thanks, Vivek On Thu, May 21, 2015 at 7:47 PM, Abe Weinograd wrote: > I think your WHERE clause is having casting issues. Is that column of the > right data type? Can

Re: ORC Table creation failure

2015-05-21 Thread Abe Weinograd
I think your WHERE clause is having casting issues. Is that column of the right data type? Can you run the SELECT by itself without the CREATE TABLE? Abe On Wed, May 20, 2015 at 11:23 PM, vivek veeramani < vivek.veeraman...@gmail.com> wrote: > > Hi , > > I'm trying to create a subset table fro