Thrift Client

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: Output from HiveQL query

The output can be printed out on terminal when you run it, or can be stored if you specify a location for it through the operator >. For example: /home/smith/bin/hive -f "file containing hive sql" > /home/smith/documents/output.txt On Thu, Jul 12, 2012 at 11:31 AM, Raihan Jamal wrote: > I have o

Insert not through any file

Hi All, Is it possible to insert and/or update some data in a hive table not through any local file? To be specific, I look to insert and update some data (not large amount) to a hive table through queries (like insert into...) in a traditional SQL style, where you specify the new data in the

Re: Thrift Server

est, JDBC supported about 25 connections in the same time without > delay. > If more connections , it will line up and timeout exception will happen. > > > Regards > Ransom > > > > -Original Message- > From: VanHuy Pham [mailto:huy.pham...@gmail.com] > S

Pulling off server's debug info to Client

Hi all, I have been interested in getting the debug information and display it to clients. Specifically, when you submit a job to hive cli (on terminal say you write "select * from somewhere ...) or through a thrift server, you will see they hive displays some debug information on the scree

Re: getting Hive table access times

I think it only makes sense to use getLastAccessTime() when you have already used setLastAccessTime() MANUALLY, otherwise hive does not automatically set the access time in its metastore. Correct me if I am wrong! On Mon, Jul 2, 2012 at 4:46 AM, Stephen R. Scaffidi < sscaff...@tripadvisor.com> wro

Re: Thrift Server

ummit2012BoF.pdf?version=1&modificationDate=1339790767000 > > > From: VanHuy Pham [mailto:huy.pham...@gmail.com] > Sent: Saturday, June 30, 2012 4:33 AM > To: user@hive.apache.org > Subject: Thrift Server > > Hi hive folks, > Does hive thrift server support multiple

Thrift Server

Hi hive folks, Does hive thrift server support multiple requests from clients at the same time? It looks like the server serves the request sequentially, which means it processes each request one by one. Am I wrong here? I make two clients, which make two requests (select data) to two d

Re: Dates in Hive

More specific, you need to use three functions in a row: 1) Use unix_timestamp(string date, string pattern) to convert the date variable, say dt, which you get from a hive query 2) Then use from_unixtime(bigint unixtime) to convert the bigint returned in 1) 3) The use to_date(string timestamp) to c

Re: Hive Thrift Client

2012 at 2:15 PM, Aniket Mokashi wrote: > 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

Hive Thrift Client

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: TSocket tran