uWZncVLM

1create EXTERNAL TABLE IF NOT EXISTS stud_ext 
2(STUD_ID int, 
3DEPT_ID int, 
4NAME string 
5) 
6ROW FORMAT DELIMITED 
7FIELDS TERMINATED BY ',' 
8STORED AS TEXTFILE 
9LOCATION '/data/stud_list';
10
11Query: select * from stud_ext 
12+---------+---------+-------+ 
13| stud_id | dept_id | name | 
14+---------+---------+-------+ 
15| 101 | 201 | 'AAA' | 
16| 102 | 202 | 'BBB' | 
17| 103 | 203 | 'CCC' | 
18| 104 | 204 | 'DDD' | 
19| 105 | 201 | 'EEE' | 
20+---------+---------+-------+ 
21Fetched 6 row(s) in 5.56s