Impala create external table ex.sql

create EXTERNAL TABLE IF NOT EXISTS stud_ext 
(STUD_ID int, 
DEPT_ID int, 
NAME string 
) 
ROW FORMAT DELIMITED 
FIELDS TERMINATED BY ',' 
STORED AS TEXTFILE 
LOCATION '/data/stud_list';

Query: select * from stud_ext 
+---------+---------+-------+ 
| stud_id | dept_id | name | 
+---------+---------+-------+ 
| 101 | 201 | 'AAA' | 
| 102 | 202 | 'BBB' | 
| 103 | 203 | 'CCC' | 
| 104 | 204 | 'DDD' | 
| 105 | 201 | 'EEE' | 
+---------+---------+-------+ 
Fetched 6 row(s) in 5.56s