· 8 years ago · Mar 07, 2018, 10:20 AM
1CREATE EXTERNAL TABLE IF NOT EXISTS stud_like_ext
2LIKE stud_int
3LOCATION '/data/stud_list';
4
5Query: select * from stud_like_ext
6+---------+---------+-------+
7| stud_id | dept_id | name |
8+---------+---------+-------+
9| 101 | 201 | 'AAA' |
10| 102 | 202 | 'BBB' |
11| 103 | 203 | 'CCC' |
12| 104 | 204 | 'DDD' |
13| 105 | 201 | 'EEE' |
14+---------+---------+-------+
15Fetched 6 row(s) in 5.50s