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
If you want to insert data into a partitioned table without specifying the
partition value, you need to enable dynamic partitioning.
You can use the following switches:
SET hive.exec.dynamic.partition=true;
SET hive.exec.dynamic.partition.mode=nonstrict;
Thanks
Vaibhav
From: Daniel,Wu [mailto:h
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
