Re: variable substitution doesn't for table name?

2012-08-31 Thread Yue Guan
I'm using Hive 0.7.0. Yeah, this is out of my expectation. On Fri, Aug 31, 2012 at 5:05 PM, Edward Capriolo wrote: > No. Variable substitution works for anything. Likely your version of hive is > old and does not support this at all. > > > On Friday, August 31, 2012, Yue Guan wrote: >> Hi, there

Re: variable substitution doesn't for table name?

2012-08-31 Thread Edward Capriolo
No. Variable substitution works for anything. Likely your version of hive is old and does not support this at all. On Friday, August 31, 2012, Yue Guan wrote: > Hi, there > > Is variable substitution good for tables? This is what I tried: > > set table_name=test_table; > explain select * from ${h

variable substitution doesn't for table name?

2012-08-31 Thread Yue Guan
Hi, there Is variable substitution good for tables? This is what I tried: set table_name=test_table; explain select * from ${hiveconf:table_name}; FAILED: Parse Error: line 1:22 cannot recognize input '$' in join source So I just want to confirm that variable substitution is only good for colum

Re: A question about HiveStatement.executeUpdate's exception

2012-08-31 Thread Carl Steinbach
Hi Ed, Namit has requested that I add negative testcases for each of the exceptions thrown by executeUpdate. I added a note to the phabricator review requesting clarification on this point. I think we should probably wait until Namit has had a chance to respond. Thanks. Carl On Fri, Aug 31, 201

Re: A question about HiveStatement.executeUpdate's exception

2012-08-31 Thread Edward Capriolo
I will commit that one later tonight. Seems like it is no big deal. On Fri, Aug 31, 2012 at 11:50 AM, Mark Grover wrote: > Hi Liyifan, > This seems like a bug. As a workaround, I would recommend using > HiveStatement.executeQuery() instead (since they both call execute() on the > Thrift client)

Re: A question about HiveStatement.executeUpdate's exception

2012-08-31 Thread Mark Grover
Hi Liyifan, This seems like a bug. As a workaround, I would recommend using HiveStatement.executeQuery() instead (since they both call execute() on the Thrift client). There is a JIRA already for this (https://issues.apache.org/jira/browse/HIVE-1450) and seems like a patch was uploaded as well

RE: Force number of records per map task

2012-08-31 Thread Elango, Vikram
Thanks buddy !! Thanks and regards, Vikram Elango The Home Depot, Nortel no: 0441-3806 Mobile: +91-8939662345 From: John Omernik [mailto:j...@omernik.com] Sent: Friday, August 31, 2012 5:44 PM To: user@hive.apache.org Subject: Force number of records per map task This is going to so

Force number of records per map task

2012-08-31 Thread John Omernik
This is going to sound very odd, but I am hoping to use a transform script in such a way that I pass a filepath to the transform script, to which it reads the file and produces a bunch of rows in hive. In this case the data is pcaps. I have a location accessible to all nodes, and I want to have m