Re: Load gzip files into hive

You have the file type as sequence file, but you are trying to load a GZip file. Won’t that only work if the table is defined as a text file? Hive isn’t doing anything on your behalf when you do LOAD DATA. It’s syntactic sugar for copying a file into a HDFS location. From there, if you want a R

Load gzip files into hive

hi, I've tried to load gzip files into hive to save disk space, but failed. hive> load data local inpath 'tmp_b.20110426.gz' into table raw_logs partition ( dt=20110426 ); Copying data from file:/home/wd/t/tmp_b.20110426.gz Copying file: file:/home/wd/t/tmp_b.20110426.gz Loading data to table def

Re: Errors in hive queries

This got resolved. Some of the clients were not upgraded to CHD3 and were running old version. On Wed, Apr 27, 2011 at 2:27 PM, vipul sharma wrote: > We have a hadoop/hive cluster which is using cloudera's distribution. > Metastore is stored in mysql and all the relevant drivers are in classpath

Errors in hive queries

We have a hadoop/hive cluster which is using cloudera's distribution. Metastore is stored in mysql and all the relevant drivers are in classpath and in conf files. While running queries on hive I am getting these errors $ hive -hiveconf hive.root.logger=INFO,console Hive history file=/tmp/vipul/hi

Re: error starting Hive Server

Yes I changed that, but now I'm getting this error from php Client Uncaught exception 'TException' with message 'TSocket: timed out reading 4 bytes from localhost:1' 2011/4/27 Edward Capriolo > On Wed, Apr 27, 2011 at 1:36 PM, Alexandre "TAZ" dos Santos Andrade > wrote: > > I'm doing a proj

Re: error starting Hive Server

On Wed, Apr 27, 2011 at 1:36 PM, Alexandre "TAZ" dos Santos Andrade wrote: > I'm doing a project using hive to provide data to a PHP interface. > > I followed the Hive's Wiki how to  when I try to Start the Hiveserver using > the terminal as above > $ HIVE_PORT=1000 ./hive --service hiveserver & >

error starting Hive Server

I'm doing a project using hive to provide data to a PHP interface. I followed the Hive's Wiki how to when I try to Start the Hiveserver using the terminal as above $ HIVE_PORT=1000 ./hive --service hiveserver & [1] 20381 [hdfs@hadoop1 bin]$ Starting Hive Thrift Server org.apache.thrift.transport.

Re: Author for a Hive Cheatsheet

On 04/27/2011 09:29 AM, Mitch Pronschinske wrote: Hello, I'm the chief editor at DZone.com , a social linking and blogging community for developers. We've got this weekly 6pg cheat sheet (sorta like spark charts) that we produce every week on a developer topic. Look here

Author for a Hive Cheatsheet

Hello, I'm the chief editor at DZone.com, a social linking and blogging community for developers. We've got this weekly 6pg cheat sheet (sorta like spark charts) that we produce every week on a developer topic. Look here for some examples: refcardz.dzone.com Does anyone here think they'd be