question about SQL Standard Based Hive Authorization

2014-11-10 Thread Guodong Wang
Hi all, I am looking for some tutorial about how to set up SQL Standard Based Hive Authorization in hive 0.13. I found this page https://cwiki.apache.org/confluence/display/Hive/SQL+Standard+Based+Hive+Authorization I have followed this page to setup the mentioned configuration. But authorization

Re: CREATE (PARTITIONED) TABLE AS error

2014-11-10 Thread Maciek
Could I ask any of you who are on Hive v0.14 to check if such CTAS syntax works? Many thanks! On Thu, Nov 6, 2014 at 10:32 AM, Maciek mac...@sonra.io wrote: What I'm referring to is CTAS statement and as per documentation it doesn't seem to work (Hive 0.13). I'm setting: SET

UNBOUNDED PRECEDING AND 1 PRECEDING

2014-11-10 Thread Maciek
Hi, Any reason ROWS BETWEEN UNBOUNDED PRECEDING AND 1 PRECEDING clause gives me error? FAILED: SemanticException End of a WindowFrame cannot be UNBOUNDED PRECEDING

FW: hive server2 jdbc

2014-11-10 Thread Sathi Chowdhury
Hello hive users , I am trying to use hive2 jdbc connection for the first time . publicclass MyHiveJDBCClient { privatestatic String driverName = org.apache.hive.jdbc.HiveDriver; private static final Logger LOG = LoggerFactory.getLogger(MyHiveJDBCClient.class); publicstatic void

Access Hive via ipython

2014-11-10 Thread Viral Parikh
Hi Hive Users! Has anyone tried to access Hive (which is on the Linux box) using Ipython / Python? I am using windows 7 64 bit machine and I am trying to use some python packages likes hive_utils but when I install I am having some issues? Is there any way to extract data from hive using