Interested to Buy Any Domain ? << Click Here >> for more details...
Can I do insert … select * into a partitioned table?
- 1 Answers
- 42 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
Does if offer scaling?
What load do concurrent queries produce on the namenode?
What are the names of daemons in impala?
What are distinct operators in impala?
Can any impala query also be executed in hive?
What is used to store data generally?
What are the best features of impala?
How do I configure hadoop high availability (ha) for impala?
Where can I find impala documentation?
What is impala data types?
What is troubleshooting for impala?
Can I use impala to query data already loaded into hive and hbase?
-
Apache Hadoop (394) - MapReduce (354)
- Apache Hive (345)
- Apache Pig (225)
- Apache Spark (991)
- Apache HBase (164)
- Apache Flume (95)
- Apache Impala (72)
- Apache Cassandra (392)
- Apache Mahout (35)
- Apache Sqoop (82)
- Apache ZooKeeper (65)
- Apache Ambari (93)
- Apache HCatalog (34)
- Apache HDFS Hadoop Distributed File System (214)
- Apache Kafka (189)
- Apache Avro (26)
- Apache Presto (15)
- Apache Tajo (26)
- Hadoop General (407)
