Format dillema

We are facing an issue of format. We would like to do bi style queries from hive using impala and that supports parquet but we would like the data to be compressed to the best ratio like orc. But impala cannot query orc formats. What can be a design consideration for this. Any help Thanks

Distinct clause in hive

When using distinct in hive query it runs for hours otherwise it's running for less than a minute. How can I optimise thisvquery. Thanks Get Outlook for Android

Moving hive data

Hi I have a peculiar problem of moving hive data from one hive environment say prod to another dev. The data runs into crores of rows. How can I do that in a less time consuming efficient manner. Thanks in advance Get Outlook for Android

RE: python libraries to execute or call hive queries

Hi Gopal Have you tried pyhs2 libraryIt has many useful functions to retrieve the data thanksrakesh > Date: Fri, 28 Aug 2015 11:53:20 -0700 > Subject: Re: python libraries to execute or call hive queries > From: gop...@apache.org > To: user@hive.apache.org > > > > Can anyone suggest any python

Using transform

Whats the use and purpose of transform in hiveAny help is appreciated thanksrakesh

Regex in hive

Hi All I am a beginner in hive And I am using '^O' with rlike, but it doesn't seem to be workingI am using hive 1.2.0. Please help thanksrakesh

RE: Running python UDF in hive

, 2015 8:28 AM To: user@hive.apache.org Subject: Re: Running python UDF in hive Did you test your python script stand alone to verify it works as expected? From: rakesh sharma rakeshsharm...@hotmail.com Reply-To: user@hive.apache.org user@hive.apache.org Date: Thursday, August 20, 2015

RE: Query doubt

select * from emp where name like 'r%'; or select * from emp where name rlike '^r'; or select * from emp where name regexp '^r'; Thanks.Pengcheng On Thu, Aug 20, 2015 at 11:40 AM, rakesh sharma rakeshsharm...@hotmail.com wrote: Hi All I am trying to get all the names starting with r.My query

Query doubt

Hi All I am trying to get all the names starting with r.My query looks like select * from emp where name like 'r~%'; But it doesn't result anything; Any help thanksrakesh

FileNotFound Exception

Hi All Please help hive insert into emp values (1, rakesh);Query ID = rakesh_20150820223622_e538e1d0-26b0-4747-a553-e68a96d58954Total jobs = 3Launching Job 1 out of 3Number of reduce tasks is set to 0 since there's no reduce operatorjava.io.FileNotFoundException: File does not exist:

Running python UDF in hive

Hi all I am running a python UDF in hive. I am getting the following error. hive select transform(id) using 'python transform_value.py' as (id string) from test;Query ID = 19659_20150820175050_ccb3b5e2-7e45-44a6-b16f-c4a4ad59e8f2Total jobs = 1Launching Job 1 out of 1 Status: Running

FW: Not able to build in eclipse

Hi I followed the instructions in hive developer page to import it as an eclipse projectBut I am running into errors. It build all fine in the shell prompt. After importing into eclipse it showed many errors. One on the dependency on tools.jar version 1.7. I think it is not being shippedin jdk