Re: Hive table export?

2010-10-01 Thread Tianqiang Li
, Tianqiang Li peter...@gmail.com wrote: Hi, Carl, I tried to compile the package you mentioned, but it said Hbase and zookeeper are required dependencies, our environment doesn't have these two, and our hadoop version is from CDH2, which we probably are not convenient to upgrade to CDH3

Re: InputFormat version problem

2010-09-22 Thread Tianqiang Li
Hi, Edward, Thanks for your hints, let me start with the old api first. Just curious, does hive have the plan to support 20 api? -Peter On Tue, Sep 21, 2010 at 9:17 PM, Edward Capriolo edlinuxg...@gmail.comwrote: On Wed, Sep 22, 2010 at 12:08 AM, Tianqiang Li peter...@gmail.com wrote: Hi

InputFormat version problem.

2010-09-21 Thread Tianqiang Li
Hi, I have customized InputFormat class to read our log format in our hadoop job and Pig, which is built on top of Hadoop 0.20 api, now I'd like to re-use this inputformat to load data into Hive table by specifying InputFormat, and a Serde when I create a table like below: CREATE TABLE

InputFormat version problem

2010-09-21 Thread Tianqiang Li
Hi, I have customized InputFormat class to read our log format in our hadoop job and Pig, which is built on top of Hadoop 0.20 api, now I'd like to re-use this inputformat to load data into Hive table by specifying InputFormat, and a Serde when I create a table like below: CREATE TABLE

Hive table export?

2010-09-20 Thread Tianqiang Li
Hi, I have quick questioin, are there any existing tools that are able to export hive table rows into table database like mysql ? I checked sqoop, but it seems it's for importing data to hadoop/hive, but not the other way(export). Any of light you'd like to shed are welcomed, thanks! Regards,

Re: Hive table export?

2010-09-20 Thread Tianqiang Li
version of Sqoop for more information: http://github.com/downloads/cloudera/sqoop/sqoop-1.1.0.tar.gz Thanks. Carl On Mon, Sep 20, 2010 at 1:15 PM, Tianqiang Li peter...@gmail.com wrote: Hi, I have quick questioin, are there any existing tools that are able to export hive table rows

Re: Hive table export?

2010-09-20 Thread Tianqiang Li
run with CDH2 without hbase and zookeeper installed ? -Peter On Mon, Sep 20, 2010 at 2:38 PM, Tianqiang Li peter...@gmail.com wrote: Thanks Carl for you hints, let me play with this version of sqoop. -Peter On Mon, Sep 20, 2010 at 2:03 PM, Carl Steinbach c...@cloudera.com wrote: Hi Peter

Re: Hive can't run query with a TextInputFormat exception

2010-09-18 Thread Tianqiang Li
script so that it runs in Bash's debug mode, (e.g. change the first line #!/usr/bin/env bash to #!/usr/bin/env bash -x) and inspect the debug output to see if the classpath is getting built correctly. Thanks. Carl On Tue, Sep 14, 2010 at 1:42 PM, Tianqiang Li peter...@gmail.com wrote: Hi

Hive can't run query with a TextInputFormat exception

2010-09-14 Thread Tianqiang Li
Hi, hive-users, I am a new Hive users, install hive recently, when I type any query-related command in Hive cli, it throws the exception, but create table are ok: $ hive Hive history file=/tmp/pli/hive_job_log_pli_201009141519_1503313446.txt hive create table test5(a int); OK Time taken: 2.551

Re: Hive can't run query with a TextInputFormat exception

2010-09-14 Thread Tianqiang Li
to cluster and processed. Regards, Peter Li On Tue, Sep 14, 2010 at 1:42 PM, Tianqiang Li peter...@gmail.com wrote: Hi, hive-users, I am a new Hive users, install hive recently, when I type any query-related command in Hive cli, it throws the exception, but create table are ok: $ hive Hive