Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / Ram Jee Prasad
Yes, you can perform an INSERT SELECT operation on a partitioned table in Impala. Here's an example:
CREATE EXTERNAL TABLE src_table (...)
PARTITIONED BY (partition_column1 STRING, partition_column2 INT)
LOCATION 'hdfs://namenode/path/to/data';
INSERT INTO TABLE dest_table
PARTITION (partition_column1='part1', partition_column2=1)
SELECT * FROM src_table WHERE condition;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category
