| ==== |
| ---- QUERY |
| create external table tbl |
| (c0 string, c1 string, c2 string, c3 int, c4 int, c5 int) |
| row format delimited fields terminated by ',' |
| location 'file://$IMPALA_HOME/testdata/data/local_tbl' |
| ---- RESULTS |
| 'Table has been created.' |
| ==== |
| ---- QUERY |
| describe tbl |
| ---- RESULTS |
| 'c0','string','' |
| 'c1','string','' |
| 'c2','string','' |
| 'c3','int','' |
| 'c4','int','' |
| 'c5','int','' |
| ---- TYPES |
| STRING, STRING, STRING |
| ==== |
| ---- QUERY |
| select * from tbl |
| ---- RESULTS |
| 'a','b','c',1,2,3 |
| 'x','y','z',9,8,7 |
| ---- TYPES |
| STRING, STRING, STRING, INT, INT, INT |
| ==== |