Create EXTERNAL table obd_data_2(
imeistring,
tstimestamp,
fuel_instantfloat,
gps_speedfloat,
gps_statusstring,
gps_longitudefloat,
gps_latitudefloat,
direct_anglefloat,
mileage_afterint,
mileage_beforeint,
obdspeedint,
torqueint,
front_xegon_sentorint,
after_xegon_sentorint,
air_conditionint
)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
LOCATION '/user/chen/TexiData/R20140101/'
--制定数据所在的目录,将此目录下的所有文件都可以转入数据库