Re: De-serializing Thrift Optional fields

2013-09-19 Thread Kanwaljit Singh
> > Hi, > > We are creating a table by De-serializing thrift file. We end up with an > extra hive column named *optionals* and of the type *struct<>*. > > This breaks the SELECT * option! How can we prevent it? >

Re: Operators && and || do not work

2013-09-19 Thread amareshwari sriramdasu
Yes, should not be because of HIVE-2439. Even in hive-0.7, it is not working, not sure if it worked at any version. Will create a jira to track. Thanks Amareshwari On Fri, Sep 20, 2013 at 6:03 AM, Thiruvel Thirumoolan < thiru...@yahoo-inc.com> wrote: > Hi Amareshwari/Ashutosh, > > Ashutosh is p

Re: Operators && and || do not work

2013-09-19 Thread Thiruvel Thirumoolan
Hi Amareshwari/Ashutosh, Ashutosh is probably right, I doubt if this ever worked. I couldn't find a clientpositive test case which uses && or ||. I also modified a unit test case in Hive9 to use "&&" instead of "AND" and that failed with the same error Amareshwari saw. Hive9 does not have HIVE-24

Re: Duplicate rows when using group by in subquery

2013-09-19 Thread Yin Huai
Maybe you were stilling using the cli which was pointing to hive 0.11 libs. After you build trunk (https://github.com/apache/hive.git), you need to use /build/dist as your hive home and use /build/dist/bin/hive to launch hive cli. You can find hive 0.13 libs in /build/dist/lib btw, seems trunk ha

Re: Export/Import Table in Hive NPE

2013-09-19 Thread Brad Ruderman
Hi All- I have opened up a ticket for this issue: https://issues.apache.org/jira/browse/HIVE-5318 Can anyone repo to confirm its a bug with Hive and not with a configuration within my instance? THanks, Brad On Tue, Sep 17, 2013 at 2:22 PM, Brad Ruderman wrote: > Hi All- > I am trying to export

Re: Hive 0.11.0 | Issue with ORC Tables

2013-09-19 Thread Owen O'Malley
On Thu, Sep 19, 2013 at 5:04 AM, Savant, Keshav < keshav.c.sav...@fisglobal.com> wrote: > Hi All, > > ** ** > > We have setup apache “hive 0.11.0” services on Hadoop cluster (apache > version 0.20.203.0). Hive is showing expected results when tables are > stored as * TextFile*. > > Where

Re: Operators && and || do not work

2013-09-19 Thread Ashutosh Chauhan
I have not tested it on historical versions, so don't know on which versions it used to work (if ever), but possibly antlr upgrade [1] may have impacted this. [1] : https://issues.apache.org/jira/browse/HIVE-2439 Ashutosh On Thu, Sep 19, 2013 at 4:52 AM, amareshwari sriramdasu < amareshw...@gma

Re: Hive 0.11.0 | Issue with ORC Tables

2013-09-19 Thread Nitin Pawar
How did you create "test.txt" as ORC file? On Thu, Sep 19, 2013 at 5:34 PM, Savant, Keshav < keshav.c.sav...@fisglobal.com> wrote: > Hi All, > > ** ** > > We have setup apache “hive 0.11.0” services on Hadoop cluster (apache > version 0.20.203.0). Hive is showing expected results when tabl

Hive 0.11.0 | Issue with ORC Tables

2013-09-19 Thread Savant, Keshav
Hi All, We have setup apache "hive 0.11.0" services on Hadoop cluster (apache version 0.20.203.0). Hive is showing expected results when tables are stored as TextFile. Whereas, Hive 0.11.0's new feature ORC(Optimized Row Columnar) is throwing an exception while running a select query, when we r

Operators && and || do not work

2013-09-19 Thread amareshwari sriramdasu
Hello, Though the documentation https://cwiki.apache.org/Hive/languagemanual-udf.html says they are same as AND and OR, they do not even get parsed. User gets parsing when they are used. Was that intentional or is it a regression? hive> select key from src where key=a || key =b; FAILED: Parse Err

Re: User accounts to execute hive queries

2013-09-19 Thread Rudra Tripathy
Thanks Nitin for the help, I would try. Thanks and Regards, Rudra On Wed, Sep 18, 2013 at 5:14 PM, Thejas Nair wrote: > You might find my slides on this topic useful - > http://www.slideshare.net/thejasmn/hive-authorization-models > > Also linked from last slide - > > https://cwiki.apache.org/

SV: Duplicate rows when using group by in subquery

2013-09-19 Thread Mikael Öhman
Hello again. I have now checked out latest code from trunk and built as per instructions. However, this query: select a.Symbol, count(*) from (select Symbol, catid from cat group by Symbol, catid) a group by a.Symbol; still returns an incorrect number of rows for table: create table cat(CATI