Re: Handling hyphens in table/database/usernames

2011-10-31 Thread Sriram Krishnan
Thanks Jander. Not supporting "-" in database/table names is fine, we can work around that. What about usernames? Like I said, our main problem is that we have a user with a hyphenated username – and I would like to figure out if there is a "clean" way to add him to a certain role, or assign h

Re: Handling hyphens in table/database/usernames

2011-10-31 Thread Jander g
Hive does not support '-' as a database name, which pattern is "[\\w_]+", so you can use '_' instead On Tue, Nov 1, 2011 at 9:29 AM, Sriram Krishnan wrote: > Hi, > > Does anyone know how to handle hyphens in any of the following? > Specifically, we have a user with a hyphenated username – and I c

Handling hyphens in table/database/usernames

2011-10-31 Thread Sriram Krishnan
Hi, Does anyone know how to handle hyphens in any of the following? Specifically, we have a user with a hyphenated username – and I can't figure out a way to add him to a certain role. No amount of escaping my hyphen seems to help. I am using Hive version 0.7.1. Any ideas would be appreciated.

What is best way to load data into hive tables/hadoop file system

2011-10-31 Thread Shantian Purkad
Hello, We have multiple terabytes of data (currently in gz format approx size 2GB per file). What is best way to load that data into Hadoop? We have seen that (especially when loaded using hive's load data local inpath ) to load a gz file it takes around 12 seconds and when we decompress it

Re: testing out Phabricator for code review

2011-10-31 Thread John Sichi
Marek added support for svn, so that is working now too...give it a try! Instructions updated at https://cwiki.apache.org/confluence/display/Hive/PhabricatorCodeReview JVS On Oct 26, 2011, at 10:49 PM, wrote: > I've put up instructions for how anyone can start using Phabricator for code > r

pass entire row as parameter in hive UDF

2011-10-31 Thread Chen Song
Hi All In HIVE, I would like to write a UDF that accepts a sequence of parameters. Due to that the number of parameters is large and the particular function that I am writing is specific to a set of tables (joined in some way in the SQL), I am wondering if there is a way to pass the entire row

Hadoop Counters

2011-10-31 Thread Jason Rutherglen
How can one integrate Hadoop counters into Hive? Thanks!

Does hive support running on an existing NFS

2011-10-31 Thread Bing Li
When I distribute Hive to a NFS and execute a select command, it failed: hive> SELECT a.foo FROM invites a;Total MapReduce jobs = 1Launching Job 1 out of 1Number of reduce tasks is set to 0 since there's no reduce operatorStarting Job = job_201110310722_0001, Tracking URL = http://localhost:5003

High number of input files problems

2011-10-31 Thread Florin Diaconeasa
Hello, Lately our user base has increased so the input files have increased considerably in size and number. One of our processing steps is doing a query of the form found at the end of the email. My problem is that apparently, sometimes, the processing misses some of the input files (for the 2nd