Interested to Buy Any Domain ? << Click Here >> for more details...
How do I load a big csv file into a partitioned table?
- 1 Answers
- 45 Views
- I also Faced
- E-Mail Answers
Answer Posted / Mahendra Kumar Meena
To load a big CSV file into a partitioned table in Impala, you can use the LOAD DATA INPATH command. Here's an example:
CREATE EXTERNAL TABLE mytable (...)
PARTITIONED BY (partition_column1 STRING, partition_column2 INT)
LOCATION 'hdfs://namenode/path/to/data';
LOAD DATA INPATH 'hdfs://namenode/path/to/bigcsvfile.csv'
INTO TABLE mytable
PARTITION (partition_column1='part1', partition_column2=1);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category
