Answer / 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);

How is impala metadata managed?

1 Answers  

---

Describe impala shell (impala-shell command)?

1 Answers  

---

Is there a dual table?

1 Answers  

---

How does impala achieve its performance improvements?

1 Answers  

---

State some advantages of impala?

1 Answers  

---

State some impala hadoop benefits?

1 Answers  

---

What is the maximum number of rows in a table?

1 Answers  

---

Are results returned as they become available, or all at once when a query completes?

1 Answers  

---

Does impala support generic jdbc?

1 Answers  

---

What happens when the data set exceeds available memory?

1 Answers  

---

Can impala be used for complex event processing?

1 Answers  

---

What are the names of daemons in impala?

1 Answers  

---