SAS-->Hive integration

2013-08-28 Thread Sanjay Subramanian
Hi guys Anyone tried SAS-->Hive integration successfully ? I tried a simple query in SAS (select col1 from table1 limit 10) and it opened 3 connections to hive-server and killed it !!! :-( I will setup a dev environment for SAS and Hive to test all this But I was wondering if you guys had any

Re: hcatalog takes minutes talking to mysql metadata

2013-08-28 Thread Eugene Koifman
perhaps HIVE-4914 relevant On Wed, Aug 28, 2013 at 3:11 AM, Michał Czerwiński wrote: > Also what is worth mentioning I have tried running 0.4.0-cdh4.3.0-SNAPSHOT > jars (from > https://repository.cloudera.com/content/groups/public/org/apache/hcatalog/hcatalog-core/) > with exactly the same issu

The role of servers in HIVE

2013-08-28 Thread Jay Vyas
Its clear that we can run hive ql scripts without a running server. Im wondering, however, are the requirements that the server fulfills? For one, I have found this slide deck which is useful... https://cwiki.apache.org/confluence/download/attachments/27362054/Hive-client-server-deployment-modes

File does not exist in Hive Job

2013-08-28 Thread Punnoose, Roshan
Hi, I am using Hive 0.11 with Hadoop 2.1.0-beta1, and on running an INSERT OVERWRITE (with my own serde) I get this exception below in a lot of my mappers. Any ideas? I even turned hive.exec.parallel=false, with no luck. Caused by: org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.hdfs.s

Re: hcatalog takes minutes talking to mysql metadata

2013-08-28 Thread Michał Czerwiński
Also what is worth mentioning I have tried running 0.4.0-cdh4.3.0-SNAPSHOT jars (from https://repository.cloudera.com/content/groups/public/org/apache/hcatalog/hcatalog-core/) with exactly the same issue. That could possibly indicate that problem may be related to the actual hive-metastore componen