Re: DROP command fails with error message

2013-12-04 Thread prakash gujjar
I have implemented hive using jdbc but is there any dialect class to use it as ORM like hibernate implementation. Thanks Prakash On 4 Dec 2013 18:27, "Nitin Pawar" wrote: > Welcome to Hive :) > > Let us know if you faced any issues setting up hive (using pure apache > distribution) (just in case

Re: Using Hive with WebHCat

2013-12-04 Thread Jonathan Hodges
Hi Thejas, Thanks for your reply. The 'templeton.storage.root' property is set to the default value, '/templeton-hadoop'. Sorry I wasn't clear above but the directory listing is the 'templeton.storage.root' directory on HDFS. hadoop fs -ls /templeton-hadoop/jobs/job_201311281741_0020 Found 3 it

Re: DROP command fails with error message

2013-12-04 Thread Lefty Leverenz
You can find documentation for installation and configuration here: - Old versions of HCatalog: http://hive.apache.org/docs/hcat_r0.5.0/install.html - Current HCatalog: https://cwiki.apache.org/confluence/display/Hive/HCatalog+InstallHCat - Hive metastore: https://cwiki.apache.or

Re: Hive ODBC Error

2013-12-04 Thread Brad Ruderman
I have had much better luck with the Cloudera driver, especially since you are using the cloudera dist. Can you send the logs from /var/log/hive/hive-server2.out and hive-server2.log? Thanks! On Wed, Dec 4, 2013 at 8:26 AM, Joseph D Antoni wrote: > To all, > > I'm trying to connect Tableau to

Local job hashtable FileNotFoundException in YARN

2013-12-04 Thread Juan Martin Pampliega
Hi, I have a Hive 0.12 Job running on Hadoop 2.2 which is running as a local map join. The problem is that it skips one of the steps by dumping the table as a hashtable (according to the logs) but then in another step when it is trying to retrieve the hashtable to do a join hive searches for anoth

Re: Survey: What do you use to interface with Hive?

2013-12-04 Thread Timothy Potter
I'm a big user of HCatalog from Pig but wish the HCat code used the RESTful HTTP interface instead of Thrift because the version incompatibilities in Thrift are frankly mind-boggling. We get around them by shading the thrift classes used by HCat Also, have many of scripts that are launched as part

Survey: What do you use to interface with Hive?

2013-12-04 Thread John Omernik
This can be an interesting subject, I know orgs that are all over on this questions. I'd be interested in hearing what you use, how it works for you, and what you are wishing you had in your interface. I'll start: We've used a number of things: - CLI for scheduled jobs. Pros: Solid running, fair

Hive ODBC Error

2013-12-04 Thread Joseph D Antoni
To all, I'm trying to connect Tableau to Hive (0.10.0) running Hiveserver2. The connection works ok, until I go to pull in the data. The resulting M/R job is attempting to connect to port 8021 on one of my data nodes--I've tried both Cloudera and Hortonworks ODBC in an effort to rule that out,

Re: DROP command fails with error message

2013-12-04 Thread Biswajit Nayak
thanks a lot again for the quick response.. On Wed, Dec 4, 2013 at 8:02 PM, Nitin Pawar wrote: > From hive-0.11, hcatalog is part of hive ( before following steps below > wait for others to reply as well if I made any mistake) > > So you need not do anything specific to setup hcatalog. > > If y

Re: DROP command fails with error message

2013-12-04 Thread Nitin Pawar
>From hive-0.11, hcatalog is part of hive ( before following steps below wait for others to reply as well if I made any mistake) So you need not do anything specific to setup hcatalog. If you downloaded previous hcatalog code and building it, then you need to follow that document. if you have la

Re: DROP command fails with error message

2013-12-04 Thread Biswajit Nayak
Thanks a lot Nitin. I was able to drop the database. One question i have, is there any documentation how to configure hcatalog with hive. Thanks Biswa On Wed, Dec 4, 2013 at 6:26 PM, Nitin Pawar wrote: > Welcome to Hive :) > > Let us know if you faced any issues setting up hive (using pure ap

Re: DROP command fails with error message

2013-12-04 Thread Nitin Pawar
Welcome to Hive :) Let us know if you faced any issues setting up hive (using pure apache distribution) (just in case something missed in documentation) and keep raising your doubts :) On Wed, Dec 4, 2013 at 6:23 PM, Biswajit Nayak wrote: > Thanks a lot.. I am a naive to hive.. > On 4 Dec 20

Re: DROP command fails with error message

2013-12-04 Thread Biswajit Nayak
Thanks a lot.. I am a naive to hive.. On 4 Dec 2013 18:13, "Nitin Pawar" wrote: > Exception clearly says "You are not allowed to drop the default database" > > > On Wed, Dec 4, 2013 at 6:09 PM, Biswajit Nayak > wrote: > >> Hi All, >> >> I was trying to drop a database name "default" but every ti

Re: DROP command fails with error message

2013-12-04 Thread Nitin Pawar
Exception clearly says "You are not allowed to drop the default database" On Wed, Dec 4, 2013 at 6:09 PM, Biswajit Nayak wrote: > Hi All, > > I was trying to drop a database name "default" but every time it fails > with the below error message. While other commands works fine like " show > datab

DROP command fails with error message

2013-12-04 Thread Biswajit Nayak
Hi All, I was trying to drop a database name "default" but every time it fails with the below error message. While other commands works fine like " show database" hive> DROP DATABASE IF EXISTS default; FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaExcept