Re: Alter table using Thrift client

2018-07-12 Thread Sylvester Steele
Hi Peter, Here is what I see: mvn dependency:build-classpath | tr : "\n" | grep hive /some-path/.m2/repository/org/apache/hive/hive-metastore/3.0.0/hive-metastore-3.0.0.jar /some-path/.m2/repository/org/apache/hive/hive-serde/3.0.0/hive-serde-3.0.0.jar /some-path/.m2/repository/org/apache/hive/

Re: Alter table using Thrift client

2018-07-12 Thread Peter Vary
Hi Sylvester, I modified a random unit test (TestHiveMetaStoreTimeout.java) with client, and added these lines: client.setMetaConf("metastore.disallow.incompatible.col.type.changes", "false"); client.setMetaConf("hive.metastore.disallow.incompatible.col.type.changes", "false"); The unit test ru

Re: Alter table using Thrift client

2018-07-11 Thread Sylvester Steele
Hi Peter, client.setMetaConf("metastore.disallow.incompatible.col.type.changes", "false") gets me the same error: MetaException(message:Invalid configuration key metastore.disallow.incompatible.col.type.changes) Thanks On Wed, Jul 11, 2018 at 12:56 PM, Peter Vary wrote: > Hi Sylvester, > > Pr

Re: Alter table using Thrift client

2018-07-11 Thread Peter Vary
Hi Sylvester, Probably the deprecated configurations are not handled here. Could you please try metastore.disallow.incompatible.col.type.changes? Thanks, Peter > On Jul 11, 2018, at 15:20, Sylvester Steele > wrote: > > Hi Peter, > > I upgraded the metastore jar to 3.0.0 and when I do: > > T

Re: Alter table using Thrift client

2018-07-11 Thread Sylvester Steele
Hi Peter, I upgraded the metastore jar to 3.0.0 and when I do: ThriftHiveMetastore.Client client = new ThriftHiveMetastore.Client(protocol); client.setMetaConf("hive.metastore.disallow.incompatible.col.type.changes", "false"); I get: MetaException(message:Invalid configuration key hive.metastor

Re: Alter table using Thrift client

2018-07-11 Thread Peter Vary
Hi Sylvester, You can set this specific configuration value per session since HIVE-17832 - Fixed in: Hive 3.0.0, Hive 2.4.0 So you can do this change this value through thrift if your metastore version is higher or equal than 2.4.0, or 3.0.0, but not with 1.2.1 If you want to use 1.2.1 version

Re: Alter table using Thrift client

2018-07-10 Thread Sylvester Steele
To add more information: I also tried: EnvironmentContext context = new EnvironmentContext(); context.setProperties(ImmutableMap.of("hive.metastore.disallow.incompatible.col.type.changes", "false")); client.alter_table_with_environment_context(hiveSchema, table.getTableName(), table, context); I

Alter table using Thrift client

2018-07-10 Thread Sylvester Steele
Hello, I am using hive-metastore jar version 1.2.1 and Hive version 2.3.2. I'd like to make incompatible schema changes to my Hive tables. The change I'm trying to make is to drop a column, which I am doing like so: table.getSd().setCols(remaining_cols). I'm dropping an int column. The column fol

php thrift client for hiveserver2

2014-05-05 Thread Chen Song
I am using CDH5 with hive 0.12.0. I dig a bit myself in internet but could not find sample php code to connect to hiveserver2. I know there are php files generated by thrift but they seem broken, as shown below. php -l /usr/lib/hive/lib/php/packages/hive_service/TCLIService.php PHP Parse error:

Hive Thrift Client - Java example

2014-03-11 Thread Prasan Samtani
I did some looking around on the wiki, and couldn't find any examples connecting to the Thrift server using Java. I understand that JDBC is the preferred way with Java, but it seems that the Thrift client has a few additions that I would like to use (for example getQueryPlan). Fo

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

2013-04-23 Thread Prasad Mujumdar
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: Using Python thrift client for Hive Server 2 hangs.

2013-04-17 Thread Kishore Yellamraju
Any thoughts on this issue of running python scripts against hive/cdh4.2 ? -Thanks kishore kumar yellamraju |Ground control operations|kish...@rocketfuel.com| 408.203.042 4 On Tue, Apr 16, 2013 at 12:26 PM, Kishore Yellamraju < kish...@rocketfuelinc.com> wrote: > +1 . > > + user@hive.apache.o

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

2013-04-16 Thread Kishore Yellamraju
+1 . + user@hive.apache.org , may be this question is to hive users. even we are having issues with running python scripts against hive. ( cdh4 , hive 0.10 , python 2.7 ) . these were working fine before and stopped working after upgrade. i see the below exception when running my python script.

Re: Hive Thrift Client

2012-07-17 Thread Ben Kim
t;> into the same problem so I was wondering if I miss anything here. >>>>> 1) Do I need to sart any other services to make hive thrift server >>>>> work? >>>>> 2) I can't seem to find the log information for hive-thrift server. >>>&

Re: Hive Thrift Client

2012-07-16 Thread Navis류승우
gt; into the same problem so I was wondering if I miss anything here. >>>> 1) Do I need to sart any other services to make hive thrift server >>>> work? >>>> 2) I can't seem to find the log information for hive-thrift server. >>>> There i

Re: Hive Thrift Client

2012-07-16 Thread Ben Kim
ering if I miss anything here. >>> 1) Do I need to sart any other services to make hive thrift server work? >>> 2) I can't seem to find the log information for hive-thrift server. >>> There is a folder called "hivelogs" created in my home dir, but I only

Re: Hive Thrift Client

2012-07-16 Thread Navis류승우
on for hive-thrift server. There >> is a folder called "hivelogs" created in my home dir, but I only find the >> log information there when I use hive cli through terminal. Is there any >> log dir for hive-thrift server? or any way I can tract the trace of the >> thr

Re: Hive Thrift Client

2012-07-16 Thread Ben Kim
when I use hive cli through terminal. Is there any > log dir for hive-thrift server? or any way I can tract the trace of the > thrift client query (execute or getAlltables())?? > > Thanks > > > On Mon, Jun 25, 2012 at 2:15 PM, Aniket Mokashi wrote: > >> Can you do cl

Thrift Client

2012-07-13 Thread VanHuy Pham
Hi All, After using ThriftHive.Client.execute(query), how to get the value of each column individually? Instead of using fetchAll() or fetchN() or fetchOne(), which alway concatenate all the values of all columns in one row into a String (separated by a tab character). More specific: Suppos

Re: Hive Thrift Client

2012-06-25 Thread VanHuy Pham
older called "hivelogs" created in my home dir, but I only find the log information there when I use hive cli through terminal. Is there any log dir for hive-thrift server? or any way I can tract the trace of the thrift client query (execute or getAlltables())?? Thanks On Mon, Jun 25,

Re: Hive Thrift Client

2012-06-25 Thread Aniket Mokashi
Can you do client.getAllTables()? ~Aniket On Mon, Jun 25, 2012 at 12:43 PM, VanHuy Pham wrote: > Hi, >I am trying to use the hive thrift client to connect to hive. Even > though I have started the hive thrift server (it's running by checking > netstat -na | grep 1).

Hive Thrift Client

2012-06-25 Thread VanHuy Pham
Hi, I am trying to use the hive thrift client to connect to hive. Even though I have started the hive thrift server (it's running by checking netstat -na | grep 1). However, the thrift client justs hangs forever when I execute a query. here is the code: TS

RE: Hive-0.8.1 PHP Thrift client broken?

2012-06-18 Thread Ruben de Vries
Going to bump this one since I hope to be able to contribute some (worth a bump :P) -Original Message- From: Ruben de Vries [mailto:ruben.devr...@hyves.nl] Sent: Friday, June 15, 2012 11:59 AM To: user@hive.apache.org Subject: Hive-0.8.1 PHP Thrift client broken? Hey Guys, I've

Hive-0.8.1 PHP Thrift client broken?

2012-06-15 Thread Ruben de Vries
Hey Guys, I've been slamming my head into a wall before on this issue, but now that I'm a bit more familiar with Hive and Thrift (I got the python version working) I figured I should try fixing the problem or find out more about it to contribute some to the project too :) The php thriftclient

Managing resources from the Thrift client

2011-12-21 Thread mdefoinplatel.ext
und in the documentation that the commands "ADD", "LIST" and "DELETE" are there to help managing the resources from the command line but I don't know how to do it from th

RE: Hive Thrift Client - Getting the jobs IDs back

2011-12-15 Thread Chinna Rao Lalam
@hive.apache.org; Shantian Purkad Subject: Re: Hive Thrift Client - Getting the jobs IDs back Hi, Is there any answer for this question? Thanks, Gabor On Fri, Dec 2, 2011 at 12:39 PM, Shantian Purkad mailto:shantian_pur...@yahoo.com>> wrote: Hi, We want to get the job tracker Ids back in th

Re: Hive Thrift Client - Getting the jobs IDs back

2011-12-15 Thread Gabor Makrai
Hi, Is there any answer for this question? Thanks, Gabor On Fri, Dec 2, 2011 at 12:39 PM, Shantian Purkad wrote: > Hi, > > We want to get the job tracker Ids back in the code for logging purpose > for the queries we fire using Hive Thrift client. > > We also want to get so

Hive Thrift Client - Getting the jobs IDs back

2011-12-02 Thread Shantian Purkad
Hi, We want to get the job tracker Ids back in the code for logging purpose for the queries we fire using Hive Thrift client. We also want to get some stats that Hive displays on console like n rows inserted, through the Thrift client in our application java code. Is this possible in

Hive Thrift Client - Getting the jobs IDs back

2011-12-01 Thread Shantian Purkad
Hi, We want to get the job tracker Ids back in the code for logging purpose for the queries we fire using Hive Thrift client. We also want to get some stats that Hive displays on console like n number rows inserted, through the Thrift client in our application java code. Is this possible

Re: Error from thrift client

2011-09-15 Thread Krish Khambadkone
My bad. I wasn't using the right version libraries on the client. Issue is now fixed. On Sep 14, 2011, at 9:34 PM, Krish Khambadkone wrote: > Hi, I am trying to access Hive 0.70 through jdbc. The hive server is > running on port 6000. The server seems to be getting the call as I see a lo