Re: [ANNOUNCE] New Hive PMC Member - Alan Gates

2014-10-27 Thread Thejas Nair
Congrats Alan! On Mon, Oct 27, 2014 at 10:11 PM, Sergio Pena wrote: > Congratulations Alan!! > > On Mon, Oct 27, 2014 at 5:38 PM, Carl Steinbach wrote: > >> I am pleased to announce that Alan Gates has been elected to the Hive >> Project Management Committee. Please join me in congratulating Al

Re: [ANNOUNCE] New Hive PMC Member - Alan Gates

2014-10-27 Thread Devopam Mittra
Congratulations Alan ! regards Dev On Tue, Oct 28, 2014 at 4:08 AM, Carl Steinbach wrote: > I am pleased to announce that Alan Gates has been elected to the Hive > Project Management Committee. Please join me in congratulating Alan! > > Thanks. > > - Carl > -- Devopam Mittra Life and Relat

Re: How to run TestCliDriver Unit Test

2014-10-27 Thread Xuefu Zhang
You need to run the command in itests directory. --Xuefu On Mon, Oct 27, 2014 at 8:41 PM, Gordon Wang wrote: > + hive user group. :) > > -- Forwarded message -- > From: Gordon Wang > Date: Tue, Oct 28, 2014 at 11:22 AM > Subject: How to run TestCliDriver Unit Test > To: d...@hi

Fwd: How to run TestCliDriver Unit Test

2014-10-27 Thread Gordon Wang
+ hive user group. :) -- Forwarded message -- From: Gordon Wang Date: Tue, Oct 28, 2014 at 11:22 AM Subject: How to run TestCliDriver Unit Test To: d...@hive.apache.org Hi all, I am working on a hive issue and I want to add a Unit test for hive query parser. Before hive 0.13,

With different parameters or column number dense_rank function gets different count distinct results

2014-10-27 Thread ericni.ni
Hi Hive users, We create a table with sql which contains the dense_rank function,and then run count distinct on this table, we found that with diffrent dense_rank parameters or even defferent columns,we will get the defferent count distinct results: 1.Less data will be ok(in our test case,200 mil

Re: possible to pass in a list of values as param ?

2014-10-27 Thread 丁桂涛(桂花)
Hi Yang, try: hive -hiveconf myargs="1','2','3','4" SELECT * from mytable where my_id in ('${hiveconf:myargs}'); On Tue, Oct 28, 2014 at 5:57 AM, Yang wrote: > I have a query that does something like > > > SELECT * from mytable where my_id in ('1', '2', '3', '4' ); > > > now instead of hard

Re: [ANNOUNCE] New Hive PMC Member - Alan Gates

2014-10-27 Thread Szehon Ho
Congratulations, Alan! On Mon, Oct 27, 2014 at 4:17 PM, Hari Subramaniyan < hsubramani...@hortonworks.com> wrote: > Congrats Alan! > > Thanks > Hari > > On Mon, Oct 27, 2014 at 4:08 PM, Vaibhav Gumashta < > vgumas...@hortonworks.com > > wrote: > > > Congratulations Alan! > > > > On Mon, Oct 27, 2

Re: [ANNOUNCE] New Hive PMC Member - Alan Gates

2014-10-27 Thread Hari Subramaniyan
Congrats Alan! Thanks Hari On Mon, Oct 27, 2014 at 4:08 PM, Vaibhav Gumashta wrote: > Congratulations Alan! > > On Mon, Oct 27, 2014 at 3:54 PM, Chris Drome wrote: > >> Congratulations Alan! >> >> From: Carl Steinbach >> Reply-To: "user@hive.apache.org" >> Date: Monday, October 27, 2014 a

Re: [ANNOUNCE] New Hive PMC Member - Alan Gates

2014-10-27 Thread Vaibhav Gumashta
Congratulations Alan! On Mon, Oct 27, 2014 at 3:54 PM, Chris Drome wrote: > Congratulations Alan! > > From: Carl Steinbach > Reply-To: "user@hive.apache.org" > Date: Monday, October 27, 2014 at 3:38 PM > To: "d...@hive.apache.org" , "user@hive.apache.org" < > user@hive.apache.org>, "ga...@a

problems with beeline and "add file"

2014-10-27 Thread rohan monga
Hi, I'm running hiveserver2 on machine X and beeline on machine Y. Everything works fine in terms queries etc. However, if i try "add file blah.py" via beeline cli then it tries on find on machine X instead of shipping it locally from Y. Is this the expected behavior or have I misconfigured someth

Re: [ANNOUNCE] New Hive PMC Member - Alan Gates

2014-10-27 Thread Chris Drome
Congratulations Alan! From: Carl Steinbach mailto:c...@apache.org>> Reply-To: "user@hive.apache.org" mailto:user@hive.apache.org>> Date: Monday, October 27, 2014 at 3:38 PM To: "d...@hive.apache.org" mailto:d...@hive.apache.org>>, "user@

Re: [ANNOUNCE] New Hive PMC Member - Alan Gates

2014-10-27 Thread Eugene Koifman
Congratulations! On Mon, Oct 27, 2014 at 3:51 PM, Xiaobing Zhou wrote: > Alan, congrats! > > On Mon, Oct 27, 2014 at 3:45 PM, Xuefu Zhang wrote: > > > Congratulations, Alan! > > > > On Mon, Oct 27, 2014 at 3:43 PM, Matthew McCline < > mmccl...@hortonworks.com > > > > > wrote: > > > > > Congratu

Re: [ANNOUNCE] New Hive PMC Member - Alan Gates

2014-10-27 Thread Xuefu Zhang
Congratulations, Alan! On Mon, Oct 27, 2014 at 3:43 PM, Matthew McCline wrote: > Congratulations! > > On Mon, Oct 27, 2014 at 3:38 PM, Carl Steinbach wrote: > > > I am pleased to announce that Alan Gates has been elected to the Hive > > Project Management Committee. Please join me in congratula

Re: [ANNOUNCE] New Hive PMC Member - Alan Gates

2014-10-27 Thread Jason Dere
Congrats Alan! On Oct 27, 2014, at 3:45 PM, "Prasanth Jayachandran" wrote: > Congrats! > > - Prasanth > > > On Mon, Oct 27, 2014 at 3:44 PM, Matthew McCline > wrote: > > Congratulations! > > On Mon, Oct 27, 2014 at 3:38 PM, Carl Steinbach wrote: > > > I am pleased to announce that Al

Re: [ANNOUNCE] New Hive PMC Member - Alan Gates

2014-10-27 Thread Gunther Hagleitner
Congrats Alan! On Mon, Oct 27, 2014 at 3:45 PM, Prasanth Jayachandran < pjayachand...@hortonworks.com> wrote: > Congrats! > > - Prasanth > > > On Mon, Oct 27, 2014 at 3:44 PM, Matthew McCline > wrote: > >> Congratulations! >> >> On Mon, Oct 27, 2014 at 3:38 PM, Carl Steinbach wrote: >> >> > I a

Re: [ANNOUNCE] New Hive PMC Member - Alan Gates

2014-10-27 Thread Prasanth Jayachandran
Congrats! - Prasanth On Mon, Oct 27, 2014 at 3:44 PM, Matthew McCline wrote: > Congratulations! > On Mon, Oct 27, 2014 at 3:38 PM, Carl Steinbach wrote: >> I am pleased to announce that Alan Gates has been elected to the Hive >> Project Management Committee. Please join me in congratulating A

Re: [ANNOUNCE] New Hive PMC Member - Alan Gates

2014-10-27 Thread Matthew McCline
Congratulations! On Mon, Oct 27, 2014 at 3:38 PM, Carl Steinbach wrote: > I am pleased to announce that Alan Gates has been elected to the Hive > Project Management Committee. Please join me in congratulating Alan! > > Thanks. > > - Carl > -- CONFIDENTIALITY NOTICE NOTICE: This message is inte

[ANNOUNCE] New Hive PMC Member - Alan Gates

2014-10-27 Thread Carl Steinbach
I am pleased to announce that Alan Gates has been elected to the Hive Project Management Committee. Please join me in congratulating Alan! Thanks. - Carl

possible to pass in a list of values as param ?

2014-10-27 Thread Yang
I have a query that does something like SELECT * from mytable where my_id in ('1', '2', '3', '4' ); now instead of hard coding the value list in the (), I'd like to pass it in as a param I tried "in (${hiveconf:myargs}) " and hive -hiveconf myargs="'1','2','3','4'" or ='1,2,3,4' neither seem

Parquet OOME Java heap space on Large table on Insert Overwrite

2014-10-27 Thread Suraj Nayak
Hi Hive users, I have already asked Parquet users. Hoping to get quick reply from Hive and Hadoop Users! Has anyone came across the OOME (Java Heap Space) problem while using Parquet + Snappy file format? Need help in resolving this issue. Below is the detailed information regarding the error an

Sql statements respective to few metastore client apis

2014-10-27 Thread Hanish Bansal
Hi All, I am switching from HiveMetaStoreClient java api to HiveServer2 jdbc client api. I am unable to find respective sql queries for some of cases: 1. To get file format of a table: In HiveMetaStoreClient: String fileFormat = hiveClient.getTable(db,tablename).getSd() .ge

答复: Is there a metastore side authorization perform like SQL standard based authorization?

2014-10-27 Thread Zhanghe (D)
Hive 0.13.1 发件人: supriya sahay [mailto:supr...@datametica.com] 发送时间: 2014年10月27日 17:59 收件人: user@hive.apache.org 主题: Re: Is there a metastore side authorization perform like SQL standard based authorization? Yes, there is. Which Hive version are you using? On 27-10-2014 08:33, Zhanghe (D) wrote:

Re: Is there a metastore side authorization perform like SQL standard based authorization?

2014-10-27 Thread supriya sahay
Yes, there is. Which Hive version are you using? On 27-10-2014 08:33, Zhanghe (D) wrote: Dear all, Is there a metastore side authorization performlike SQL standard based authorization? Thanks~~