The LOAD DATA command only copy the files to the destination directory. It
doesn't read the records of the input file, so it cannot do partitioning based
on record values.
On Apr 14, 2011, at 10:52 PM, Erix Yao wrote:
hi,all
The dynamic partition function is amazing ,but only works in insert clause.
Can I use it while loading data into table?
For example: load data LOAD DATA LOCAL INPATH `/tmp/pv_2008-06-08_us.txt`
INTO TABLE page_view PARTITION(date='2008-06-08', country='US', type);
type is the dynamic partition key in the raw data?
This will be very cool! If is supported, I will not have to category the raw
data according to the type column.
--
haitao.yao@Beijing
