Regards
Bejoy K S
*From: * hadoopman
*Date: *Sun, 14 Aug 2011 08:57:12 -0600
*To: *
*ReplyTo: * user@hive.apache.org
*Subject: *Re: how to load data to partitioned table
Something else I've noticed is when loading LOTS of historical data,
if you can try to say
Bejoy K S
-Original Message-
From: hadoopman
Date: Sun, 14 Aug 2011 08:57:12
To:
Reply-To: user@hive.apache.org
Subject: Re: how to load data to partitioned table
Something else I've noticed is when loading LOTS of historical data, if
you can try to say load a month of data at a
--
*From: * Vikas Srivastava
*Date: *Fri, 12 Aug 2011 17:31:28 +0530
*To: *
*ReplyTo: * user@hive.apache.org
*Subject: *Re: how to load data to partitioned table
Hey ,
Simpley you have run query like this
FROM sales_temp INSERT OVERWRITE TABLE sales partition(period_key)
SELECT *
Rega
[mailto:hadoop...@163.com]
Sent: Thursday, August 11, 2011 11:30 PM
To: hive
Subject: how to load data to partitioned table
suppose the table is partitioned by period_key, and the csv file also has a
column named as period_key. The csv file contains multiple days of data, how
can we load it in the the
speed-up-your-hive-queries-in.html
Hope it helps
Regards
Bejoy K S
-Original Message-
From: Vikas Srivastava
Date: Fri, 12 Aug 2011 17:31:28
To:
Reply-To: user@hive.apache.org
Subject: Re: how to load data to partitioned table
Hey ,
Simpley you have run query like this
FROM sales
Hey ,
Simpley you have run query like this
FROM sales_temp INSERT OVERWRITE TABLE sales partition(period_key) SELECT *
Regards
Vikas Srivastava
2011/8/12 Daniel,Wu
> suppose the table is partitioned by period_key, and the csv file also has
> a column named as period_key. The csv file cont
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DML
2011/8/12 Daniel,Wu
> suppose the table is partitioned by period_key, and the csv file also has
> a column named as period_key. The csv file contains multiple days of data,
> how can we load it in the the table?
>
> I think of
suppose the table is partitioned by period_key, and the csv file also has a
column named as period_key. The csv file contains multiple days of data, how
can we load it in the the table?
I think of an workaround by first load the data into a non-partition table, and
then insert the data from n
