RE: Latest hive source code

2011-10-27 Thread vikas srivastava
Hey Ashu/anh Is this true that hive 0.8 supports insert and append data into table . With Regards Vikas Srivastava DWH & Analytics Team M: +91 9560885900 P: + 91 120 4770102 Email: vikas.srivast...@one97.net W: www.one97world.com One97 | Let's get talking ! From: Ashutosh Chauhan [ma

Re: Latest hive source code

2011-10-27 Thread Ashutosh Chauhan
You can get the latest hive trunk source from here: http://svn.apache.org/repos/asf/hive/trunk/ Hope it helps, Ashutosh On Thu, Oct 27, 2011 at 20:01, trang van anh wrote: > Thanks for your response, i check your link sent and i see that latest > source code version 0.7.1., But according to my

Re: Latest hive source code

2011-10-27 Thread trang van anh
Thanks for your response, i check your link sent and i see that latest source code version 0.7.1., But according to my knowledge from version 0.8 support insert append data to table. Can you tell me where i can get this chuck? Thanks. On 10/28/2011 9:47 AM, wd wrote: http://www.apache.org/d

Re: Latest hive source code

2011-10-27 Thread wd
http://www.apache.org/dyn/closer.cgi/hive/ On Fri, Oct 28, 2011 at 9:02 AM, trang van anh wrote: > Dear all, > > Anybody show me how to get latest hive source code? > > Thanks in advance. > > Trang. > > >

Latest hive source code

2011-10-27 Thread trang van anh
Dear all, Anybody show me how to get latest hive source code? Thanks in advance. Trang.

RE: Question on regexp_extract() , Index?

2011-10-27 Thread Sunderlin, Mark
Ah, easy enough! And if you have no groups, you just want the match, it seems index of 0 works just fine. select regexp_extract('junk:text:ua123','ua[0-9]+',0) from dual -- assumes you have created a dummy hive table called dual ua123 --- Mark E. Sunderlin Solutions Architect |AOL Data Wareho

Re: Question on regexp_extract() , Index?

2011-10-27 Thread Mark Grover
Mark, It specifies the group that you want to be extract after the Regex has been matched. Group numbers are 1-referenced. In the example you gave, the first group corresponds to "the", the second group corresponds to "bar". A group in Regex is specified by a pair of parenthesis. You can also l

Question on regexp_extract() , Index?

2011-10-27 Thread Sunderlin, Mark
I've been working with the hive regexp_extract(string subject, string pattern, int index) command. In the hive language manual, https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-StringFunctions, the following description for this function is given: Returns t

Re: Problem With HDFS USERS using JDBC

2011-10-27 Thread Sriram Krishnan
I had asked a similar question earlier - http://mail-archives.apache.org/mod_mbox/hive-user/201110.mbox/%3ccab13a97.2c54%25skrish...@netflix.com%3E. But I didn't get any responses. This may be a limitation of Hive JDBC. I would also be curious to know if there is a solution to this. Thanks, Sri

RE: UnixODBC and Hive setup

2011-10-27 Thread Tony Burton
** to fix the missing uint32_t i had to add to Thrift.h: #include Then there was a build error as follows: /usr/local/include/thrift/protocol/TBinaryProtocol.tcc:148:35: error: there are no arguments to 'htons' that depend on a template parameter, so a declaration of 'htons' must be available

RE: UnixODBC and Hive setup

2011-10-27 Thread Tony Burton
Hi, I have built fb303, it took a couple of fixes** but I got there. However, I still get the same error when building the Hive Client: fb303_types.h can't be found. Where should it be? One difference I have seen since building fb303 is that I now have a lbfb303.a in my /usr/local/lib/ - is th

Re: Problem With HDFS USERS using JDBC

2011-10-27 Thread Gabriel Eisbruch
Really My problem it's a little different, we have created all users that we need, but we can't set this users using jdbc, our system user it's different that we need to use to connect to hive, so when we try to do a LOAD action we saw that hive server try to use the user HIVE instead of the user t

How to replace a input table name inside Hive (How Hive pass input file names to Hadoop ?)

2011-10-27 Thread Hiroyuki Yamada
Hello, I am trying to understand how hive compiles and opmizes HiveQL queries for future development. I would like to know how to replace a input table name in the compilation process. For example, the following HiveQL is queried, SELECT l_orderkey FROM lineitem WHERE l_shipdate < '1993-01-01';