Failed to move to trash [Re: Drop table skiptrash?]

2012-12-24 Thread Periya.Data
set x=y > > If that does not work it is possible to run dfs commands from hive. Just > do your normal hadoop dfs command without specifying hadoop. > > hive > dfs -rmr /user/hive/warehouse > > > On Mon, Dec 24, 2012 at 2:46 AM, Periya.Data wrote: > >> Hi, >

Drop table skiptrash?

2012-12-23 Thread Periya.Data
Hi, Is there a way to drop a table such that the contents do not go to the .Trash dir? I have limited diskQuota in hadoop and am running large Hive jobs in sequence. I would like to drop tables as and when they become unnecessary and also they must not end up in .Trash..as they occupy lot of spa

Re: Hive double-precision question

2012-12-08 Thread Periya.Data
loat and double type because of > some internal representation in the Java library, or the UDF. > > ** ** > > Ed Capriolo’s book has a good section about workarounds and caveats for > working with floats/doubles in hive. > > ** ** > > Thanks, > > Lauren

Re: Hive double-precision question

2012-12-07 Thread Periya.Data
ill have to look further to comment more. > > In the meanwhile take a look at the UDF code and see if your personal Java > code on Linux is equivalent to the Hive UDF code. > > Keep us posted! > Mark > > On Fri, Dec 7, 2012 at 1:27 PM, Periya.Data wrote: > >> Hi H

Re: Hive double-precision question

2012-12-07 Thread Periya.Data
the Java library, or the UDF. > > ** ** > > Ed Capriolo’s book has a good section about workarounds and caveats for > working with floats/doubles in hive. > > ** ** > > Thanks, > > Lauren > > *From:* Periya.Data [mailto:periya.d...

Cannot recognize input near..

2011-12-23 Thread Periya.Data
Hi, I am trying to run a simple query in my JDBC-Client java code: = // create mon_tbl - Monthly aggregated data String mon_tblName = "month_tbl"; sql = "DROP TABLE IF EXISTS " + mon_tblName; res = stmt.executeQuery(sql);

Re: Hive server not starting...on EC2 Ubuntu 10.04 instance

2011-12-18 Thread Periya.Data
-12-31-39-0E-C9-33:/var/lib/hive/metastore# -PD On Sun, Dec 18, 2011 at 4:34 AM, Vivek Mishra wrote: > try issuing with "sudo". as metastore_db is locked for root user. > else do sudo chmod 777 folder. > > > Vivek > ____ &

Hive server not starting...on EC2 Ubuntu 10.04 instance

2011-12-17 Thread Periya.Data
Hi all, I am trying to start hive server, but, after the command, it looks like nothing is happening. I am not even getting a prompt. Here are some details: - machine - EC2 Ubuntu 10.04 LTS - Hive version - 0.7.1-cdh3u2 (as seen from hive-default.xml) - Hadoop version - 0.20.2 - I currently h

Re: Hive Metadata URI error

2011-12-12 Thread Periya.Data
36 PM, Kirk True wrote: > >> To me it looks like the error message is getting a blank for the URI >> property value. Can you triple-check the property _name_ is correct >> (including capitalization)? >> >> >> On 12/11/11 9:35 PM, Periya.Data wrote: >> &

Re: Hive Metadata URI error

2011-12-11 Thread Periya.Data
t expecting? Thanks, PD. On Sun, Dec 11, 2011 at 9:15 PM, Sam Wilson wrote: > Try file:// in front of the property value... > > Sent from my iPhone > > On Dec 12, 2011, at 12:07 AM, "Periya.Data" wrote: > > Hi, >I am trying to create Hive tables on an EC2 ins

Hive Metadata URI error

2011-12-11 Thread Periya.Data
Hi, I am trying to create Hive tables on an EC2 instance. I get this strange error about URI schema and log4j properties not found. I do not know how to fix this. On EC2 instance : Ubuntu 10.04, Hive-0.7.1-cdh3u2. Initially I did not have an entry for hive.metastore.uris property in my hive-de