Re: [VOTE] Amend Hive Bylaws + Add HCatalog Submodule

Measure 1: +1 (non binding) Measure 2: +1 (non binding) thanks Prasad On Tue, Jan 29, 2013 at 2:57 PM, Shreepadma Venugopalan < shreepa...@cloudera.com> wrote: > Measure 1: +1 > Measure 2: +1 > > Thanks. > Shreepadma > > > On Tue, Jan 29, 2013 at 1:50 PM, Arvind Prabhakar > wrote: > > > Mea

Re: Re:RE: Problem with Hive JDBC server

hmm .. there's a possibility that the execute and close for a given statement are not handled by same thrift thread. Can you please verify the testcase with a single worker thread on the server side ? You can run the server using following : hive --service hiveserver --maxWorkerThreads 1 --minWo

Re: Hive insert into RCFILE issue with timestamp columns

Dilip, Looks like you are using the data from the original schema for this new table that has single timestamp column. When I tried with just the timestamp from your data, the query runs fine. I guess the original issue you hit on the data that didn't have fraction part (1969-12-31 19:00:00, no

Re: Using Python thrift client for Hive Server 2 hangs.

HiveServer2 by default uses ThriftSASL transport. The Thrift python library doesn't have the SASL transport. You can run the hiveserver2 in non-sasl mode by adding following to the hive-site.xml hive.server2.authentication NOSASL Also Hive 0.10 upgraded Thrift requirement from 0.7 to 0

Re: [VOTE] Apache Hive 0.11.0 Release Candidate 1

-1 (non-binding) My apologies, but HIVE-4505 is a regression that IMHO should be addressed. thanks Prasad On Tue, Apr 30, 2013 at 5:18 PM, Ashutosh Chauhan wrote: > Hey all, > > Based on feedback from folks, I have respun release candidate, RC1. > Please take a look. It basically fixes the si

Re: hiveserver2 Thrift Interface With Perl

HiveServer2 uses Thrift SASL transport by default. AFAIK, Thrift doesn't support sasl transport for perl. In order to connect from a perl thrift client, you need to turn off the SASL in HiveServer2. This can be done by setting a property hive.server2.authentication to NOSASL in the hive-site.xml

Re: Hive Server2 thrift java client

Hi Ghousia, You might want to look at the JDBC2 driver code as an example of handling the HiveServer2 thrift API in Java. The HiveServer2 thrift interface doesn't expose storage descriptor or partitions. This interface is more aligned with JDBC/ODBC spec for data and metadata operations. than

Re: Correct way to use Hive Java API

I think the new Table("default", "pokes")will create a dummy table object with only the db name and table name set. It will not retrieve the table information from metastore. If you are looking for the schema information and retrieve the data, you might want to consider using the JDBC interface

Re: [ANNOUNCE] New Hive Committer - Brock Noland

Congratulations !! thanks Prasad On Mon, Jul 15, 2013 at 10:42 PM, Jarek Jarcec Cecho wrote: > Congratulations Brock! > > Jarcec > > On Mon, Jul 15, 2013 at 10:29:51PM -0700, Carl Steinbach wrote: > > The Apache Hive PMC has passed a vote to make Brock Noland a new > committer > > on the pr

Re: [ANNOUNCE] New Hive Committer - Thejas Nair

Congrats Thejas! thanks Prasad On Tue, Aug 20, 2013 at 3:31 AM, Carl Steinbach wrote: > The Apache Hive PMC has voted to make Thejas Nair a committer on the Apache > Hive project. > > Please join me in congratulating Thejas! >

Re: Hive Query via Hue, Only column headers in downloaded CSV or XSL results, sometimes

+ hue-user thanks Prasad On Mon, Sep 30, 2013 at 11:05 AM, Martin, Nick wrote: > Mark - is the Hive table you're using for this fairly wide? If so, are you > doing a "select * from table_name limit 10"? > > We ran some tests this morning on one of the Hive tables giving us some > fits and if

Hive User Group Meetup NYC Edition 2013

The next NYC edition of the Hive User Group Meetup is happening on October 28th, 6:30pm ET at Hilton New York (East Suite) . The format will be a series of short 15 minute long talks followed by un-conference style sessions and networking. Space for the meetup along with food and refreshments are b

Re: HS2 ODBC incompatibility

The Apache Hive JDBC driver ( https://github.com/apache/hive/tree/trunk/jdbc/src/java/org/apache/hive/jdbc) is Java implementation of thrift client for HS2. thanks Prasad On Tue, Oct 22, 2013 at 7:04 AM, Haroon Muhammad wrote: > Thanks Carl and Tejas!! > > Actually my application ( written

Re: [ANNOUNCE] New Hive PMC Members - Thejas Nair and Brock Noland

Congratulations Thejas and Brock ! thanks Prasad On Thu, Oct 24, 2013 at 3:10 PM, Carl Steinbach wrote: > I am pleased to announce that Thejas Nair and Brock Noland have been > elected to the Hive Project Management Committee. Please join me in > congratulating Thejas and Brock! > > Thanks

Re: [ANNOUNCE] New Hive Committer - Xuefu Zhang

Congratulations Xuefu! thanks Prasad On Sun, Nov 3, 2013 at 8:06 PM, Carl Steinbach wrote: > The Apache Hive PMC has voted to make Xuefu Zhang a committer on the Apache > Hive project. > > Please join me in congratulating Xuefu! > > Thanks. > > Carl >

Re: [ANNOUNCE] New Hive PMC Member - Harish Butani

Congratulations !! thanks Prasad On Thu, Nov 14, 2013 at 5:17 PM, Carl Steinbach wrote: > I am pleased to announce that Harish Butani has been elected to the Hive > Project Management Committee. Please join me in congratulating Harish! > > Thanks. > > Carl >

Re: [ANNOUNCE] New Hive Committers - Jitendra Nath Pandey and Eric Hanson

Congrats!! thanks Prasad On Thu, Nov 21, 2013 at 3:29 PM, Carl Steinbach wrote: > The Apache Hive PMC has voted to make Jitendra Nath Pandey and Eric Hanson > committers on the Apache Hive project. > > Please join me in congratulating Jitendra and Eric! > > Thanks. > > Carl >

Re: Hive metastore is creating mysql instead of Derby.

Hi, Looks like you are passing the 'dbType' as derby however the Metastore connection URL is configured (hive-site.xml) for mysql. Both Hive and schemaTool will use the metastore URL and driver configured in the hive-site to connect to the database. If you intend to use derby as backend, please

Re: Configuring Apache Hive using Kerberos Authentication

If you are talking about embedded Hive client (CLI), then all you need is to have a TGT in the ticket cache (ie run kinit before invoking Hive). The underlying hadoop client handles communication with secure Hadoop services. As long as the Hadoop related security configuration is place, there's

Re: Configuring Apache Hive using Kerberos Authentication

incipal : hive/pg-server.foobar@foobar.com > > > > PFA for the hive-default.xml file and TerminalExceptionLog details. > > > > *If anything is wrong in above steps followed by me, will you please share > the detailed steps document[containing all small steps from start to

Re: Hiveserver2 + OpenLdap Authentication issue

What are your hive-site.xml settings of authentication and LDAP parameters ? thanks Prasad On Mon, Feb 24, 2014 at 9:40 AM, Vinod Kumar Vavilapalli wrote: > This is on the wrong mailing list, hence the non-activity. > > +user@hive > bcc:user@hadoop > > Thanks > +Vinod > > > On Feb 23, 2014

Re: [ANNOUNCE] New Hive PMC Member - Xuefu Zhang

Congratulations Xuefu !! thanks Prasad On Fri, Feb 28, 2014 at 1:20 AM, Carl Steinbach wrote: > I am pleased to announce that Xuefu Zhang has been elected to the Hive > Project Management Committee. Please join me in congratulating Xuefu! > > Thanks. > > Carl > >

Re: CLI, HiveServer2, Beeline

Hello Uber, Please see the comments inline. thanks Prasad On Fri, Mar 28, 2014 at 8:28 AM, Uber Slacker wrote: > Hi folks. I'm trying to wrap my head around the latest Hive architecture > (as of 0.12 at least). From what I've gathered: > > - HiveServer2 is the new Thrift based Hive server

Re: CLI, HiveServer2, Beeline

HiveServer2 is in embedded mode, do we need HiveServer2 service > even to be running, or can Beeline interact with the Hive driver without > going through HiveServer2? Can you give me a little more insight on what is > actually going on during embedded mode? > > Thanks much! > &

Re: [ANNOUNCE] New Hive Committers - Prasanth J and Vaibhav Gumashta

Congratulations !! thanks Prasad On Thu, Apr 24, 2014 at 7:33 PM, Carl Steinbach wrote: > + Prasanth's correct email address > > > On Thu, Apr 24, 2014 at 7:31 PM, Xuefu Zhang wrote: > >> Congratulations to Prasanth and Vaibhav! >> >> --Xuefu >> >> >> On Thu, Apr 24, 2014 at 7:26 PM, Carl

Re: Problem running Hive Jdbc Client

Do you have Hadoop jars in the classpath ? thanks Prasad On Fri, Nov 4, 2011 at 11:53 AM, Melchiades Blanco Junior wrote: > Hey there, it's my first msg here. I'm trying to work with hive server by > connecting with its jdbc driver... > > I have already hadoop and hive cli working... > > I'

Re: HIveserver jdbc set configurations

You can execute a 'set property=value' statements using Statement.execute(). Such change will only be visible in the current session. thanks Prasad On Fri, Oct 10, 2014 at 4:11 AM, Navdeep Agrawal < navdeep_agra...@symantec.com> wrote: > Hi, > > I am connecting to hive server2 through jdbc an

Re: Remote Beeline with kerberos issue.

What is your connection URL ? In case of Kerberos, it should be jdbc:hive2://:/;principal= thanks Prasad On Mon, Nov 3, 2014 at 1:16 AM, konark modi wrote: > Hi Vaibhav, > > Yes I have done that. I am on hive version. 0.12. > > But the same problem. > > Regards > Konark > On Nov 3, 2014 2:1

Re: JDBC/beeline client hangs with HiverServer2 (0.13.1)

By default the sasl auth is enabled, you don't need to set 'auth=noSasl' unless you configured non-sasl auth. What errors did you see in the server log initially when noSasl option was not passed ? thanks Prasad On Tue, Dec 2, 2014 at 10:08 AM, Atul Paldhikar (apaldhik) < apald...@cisco.com> w

Re: JDBC/beeline client hangs with HiverServer2 (0.13.1)

000/default > > Connected to: Apache Hive (version 0.13.1) > > Driver: Hive JDBC (version 0.13.1) > > Transaction isolation: TRANSACTION_REPEATABLE_READ > > 0: jdbc:hive2://finattr-comp-dev-01:1/def> > > 0: jdbc:hive2://finattr-comp-dev-01:1/def> show tabl

Re: samples for JDBC to connect and query Hive?

Hi Lin, Checkout https://cwiki.apache.org/confluence/display/Hive/HiveServer2+Clients#HiveServer2Clients-JDBCClientSampleCode thanks Prasad On Fri, Mar 27, 2015 at 2:31 PM, Lin Ma wrote: > Hello Hive masters, > > I am new to Hive and wondering if any good samples to refer to of using > JDBC

Re: "show databases" doesn't return all databases with Kerberos/Sentry enabled

- security@, bcc: user@hive +dev@sentry On Wed, May 13, 2015 at 12:05 PM, Szehon Ho wrote: > Hi Liping > > Do you want to check the Sentry mailing list as well? They might know > more about this scenario. > > Thanks > Szehon > > On Wed, May 13, 2015 at 10:18 AM, Liping Zhang > wrote: > >> Dea

Re: Use delegation token(from oozie in a java action) through hive JDBC to talk to hive server 2

Hi Jary, Hive JDBC does support delegation token based client connection for Oozie. Please refer to client connection details [1] on the wiki. The Hive side changes were added in Hive 0.13 and the Oozie side support for Hive2 action was added in Oozie 4.2. You might want to refer to Oozie docs