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~~

答复: 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)

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()

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

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 seems

[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

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 c...@apache.org 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

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 mmccl...@hortonworks.com wrote: Congratulations! On Mon, Oct 27, 2014 at 3:38 PM, Carl Steinbach c...@apache.org wrote: I am pleased to announce that Alan Gates has been elected to the Hive Project Management Committee.

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 mmccl...@hortonworks.com wrote: Congratulations! On Mon, Oct 27, 2014 at 3:38 PM, Carl Steinbach

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 pjayachand...@hortonworks.com wrote: Congrats! - Prasanth On Mon, Oct 27, 2014 at 3:44 PM, Matthew McCline mmccl...@hortonworks.com wrote: Congratulations! On Mon, Oct 27, 2014 at 3:38 PM, Carl Steinbach

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 mmccl...@hortonworks.com wrote: Congratulations! On Mon, Oct 27, 2014 at 3:38 PM, Carl Steinbach c...@apache.org wrote: I am pleased to announce that Alan Gates has been elected to the Hive Project Management

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 xz...@hortonworks.com wrote: Alan, congrats! On Mon, Oct 27, 2014 at 3:45 PM, Xuefu Zhang xzh...@cloudera.com wrote: Congratulations, Alan! On Mon, Oct 27, 2014 at 3:43 PM, Matthew McCline mmccl...@hortonworks.com

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

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

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

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 cdr...@yahoo-inc.com wrote: Congratulations Alan! From: Carl Steinbach c...@apache.org Reply-To: user@hive.apache.org user@hive.apache.org Date: Monday, October 27, 2014 at 3:38 PM To: d...@hive.apache.org

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 vgumas...@hortonworks.com wrote: Congratulations Alan! On Mon, Oct 27, 2014 at 3:54 PM, Chris Drome cdr...@yahoo-inc.com wrote: Congratulations Alan! From: Carl Steinbach c...@apache.org Reply-To:

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, 2014 at 3:54 PM,

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 tedd...@gmail.com wrote: I have a query that does something like SELECT * from mytable where my_id in ('1', '2', '3', '4' ); now

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

Fwd: How to run TestCliDriver Unit Test

2014-10-27 Thread Gordon Wang
+ hive user group. :) -- Forwarded message -- From: Gordon Wang gw...@pivotal.io 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.

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 gw...@pivotal.io wrote: + hive user group. :) -- Forwarded message -- From: Gordon Wang gw...@pivotal.io Date: Tue, Oct 28, 2014 at 11:22 AM Subject: How to run

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 c...@apache.org 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