Strange display when upload RCFile from local with different column.

hello, I tried to import data from SQL to Hive RCFile. I use RCFile.Writer to generate rcfile and upload to HIVE table directory. the rcfiles has different columns: c0_1.rc has 2 columns c1_1.rc has 3 columns c2_1.rc has 4 columns the outputs was strange: # All rc files are loaded: hive> select

Re: Orc file format examples

Any suggestions on where can i find ORCFileFormat APIs ? I included 0.11.0 v of Hive libraries, but am not finding it there. On Mon, May 20, 2013 at 6:37 AM, Deepak Jain wrote: > Could anyone please point me to examples, on how to store data in Orc file > format and then read it back row wise a

Re: Orc file format examples

I found the package, Looking for examples may be unit test cases. On Mon, May 20, 2013 at 4:32 PM, ÐΞ€ρ@Ҝ (๏̯͡๏) wrote: > Any suggestions on where can i find ORCFileFormat APIs ? I included 0.11.0 > v of Hive libraries, but am not finding it there. > > > On Mon, May 20, 2013 at 6:37 AM, Deepak

Re: Orc file format examples

Found TestORCFile , will try that out. On Mon, May 20, 2013 at 4:36 PM, ÐΞ€ρ@Ҝ (๏̯͡๏) wrote: > I found the package, Looking for examples may be unit test cases. > > > On Mon, May 20, 2013 at 4:32 PM, ÐΞ€ρ@Ҝ (๏̯͡๏) wrote: > >> Any suggestions on where can i find ORCFileFormat APIs ? I included >

Re: Strange display when upload RCFile from local with different column.

Timestamp handling, specifically TimestampWritable, has several bugs. The latest versions of Hive (11.0) has some fixes needed to make it work correctly. On Mon, May 20, 2013 at 2:18 AM, Zhenhua Chai wrote: > hello, > I tried to import data from SQL to Hive RCFile. I use RCFile.Writer to > ge

Re: Hive Error

Hi Varun Can u attach the error logs…I don't seem to have the attachment Thaks sanjay From: Kasa V Varun mailto:kasa.va...@mu-sigma.com>> Reply-To: "user@hive.apache.org" mailto:user@hive.apache.org>> Date: Sunday, May 19, 2013 11:16 PM To: "user@hive.apache.org

Unable to stop Thrift Server

Hi, I was not able to stopThrift Server after performing the following steps. $ bin/hive --service hiveserver & Starting Hive Thrift Server $ netstat -nl | grep 1 tcp 0 0 :::1 :::* LISTEN I gave the following to stop. but not working. hive --service hiveserver --action stop 1 H

Re: Unable to stop Thrift Server

Raj Which version r u using ? I think from 0.9+ onwards its best to use service to stop and start and NOT hive sudo service hive-metastore stop sudo service hive-server stop sudo service hive-metastore start sudo service hive-server start Couple of general things that might help 1. Use linux s

Re: Unable to stop Thrift Server

Hi Sanjay, I am using 0.9 version. I do not have a sudo access. is there any other command to stop the service. thanks, raj From: Sanjay Subramanian To: "user@hive.apache.org" ; Raj Hadoop ; User Sent: Monday, May 20, 2013 5:11 PM Subject: Re: Unable to s

Re: Unable to stop Thrift Server

Not that I know of…..sorry sanjay From: Raj Hadoop mailto:hadoop...@yahoo.com>> Reply-To: Raj Hadoop mailto:hadoop...@yahoo.com>> Date: Monday, May 20, 2013 2:17 PM To: Sanjay Subramanian mailto:sanjay.subraman...@wizecommerce.com>>, "user@hive.apache.org" mailto:us

Re: 答复: Unable to stop Thrift Server

Hi, I had to do a kill -9. I am very surprised even 'Programming Hive' book has not given details on how to stop the thrift service. It just metioned on how to start. Thanks, Raj From: Jie Zhou (周杰) To: "u...@hadoop.apache.org" ; Raj Hadoop ; Sanjay Sub

LZO compression implementation in Hive

Hi Programming Hive Book authors Maybe a lot of u have already successfully implemented this but only these last two weeks , we implemented our aggregations using LZO compression in Hive - MR jobs creating LZO files as Input for Hive ---> Therafter Hive aggregations creating more LZO files as o