====
---- 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
====