Re: User accounts to execute hive queries

2013-09-18 Thread Nitin Pawar
The link I gave in previous mail explains how can you user level authorizations in hive. On Mon, Sep 16, 2013 at 7:57 PM, shouvanik.hal...@accenture.com wrote: Hi Nitin, ** ** I want it secured. ** ** Yes, I would like to give specific access to specific users. E.g. “select

Re: FAILED: ParseException line 12:0 mismatched input 'Comment' expecting Identifier near ',' in column specification

2013-09-18 Thread Justin Workman
Try putting back ticks around comment since its a reserved word. Sent from my iPhone On Sep 18, 2013, at 8:54 AM, Artem Ervits are9...@nyp.org wrote: Anyone? *From:* Artem Ervits [mailto:are9...@nyp.org are9...@nyp.org] *Sent:* Monday, September 16, 2013 5:07 PM *To:* user@hive.apache.org

Hive Query via Hue, Only column headers in downloaded CSV or XSL results, sometimes

2013-09-18 Thread Sunderlin, Mark
Using Hive V11, via Hue from CDH4, I can run my query, output 10 rows (limit 10) and download to a nice CSV or XSL file ... sometimes. :-( Sometimes, even when the run is error free, the download only downloads the column headers. This is true for both the CSV and XSL options. It is only ten

Re: Export/Import Table in Hive NPE

2013-09-18 Thread Brad Ruderman
Hi All- Just wondering if anyone had any ideas. The error message I am getting now when exporting a managed table from hive 0.9 to hive .10 is: 13/09/18 13:14:02 ERROR ql.Driver: FAILED: SemanticException Exception while processing org.apache.hadoop.hive.ql.parse.SemanticException: Exception

Re: User accounts to execute hive queries

2013-09-18 Thread Thejas Nair
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/confluence/display/HCATALOG/Storage+Based+Authorization On Tue, Sep 17, 2013 at 11:46 PM, Nitin Pawar nitinpawar...@gmail.com

Re: FAILED: ParseException line 12:0 mismatched input 'Comment' expecting Identifier near ',' in column specification

2013-09-18 Thread Artem Ervits
Thank you, will do. Artem Ervits Data Analyst New York Presbyterian Hospital From: Justin Workman [mailto:justinjwork...@gmail.com] Sent: Wednesday, September 18, 2013 11:01 AM To: user@hive.apache.org user@hive.apache.org Subject: Re: FAILED: ParseException line 12:0 mismatched input 'Comment'