loading data to hive dynamic partitioned tables -

i have created hive table dynamic partitioning on column. there way directly load data files using "load data" statement? or have depend on creating non-partitioned intermediate table , load file data , inserting data intermediate table partitioned table mentioned in hive loading in partitioned table?

no, load data command copies files destination directory. doesn't read records of input file, cannot partitioning based on record values.

if input data split multiple files based on partitions, directly copy files table location in hdfs under partition directory manually created (or point current location in case of external table) , use following alter command add partition. way skip load data statement altogether.

alter table <table-name> add partition (<...>)