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/'

--制定数据所在的目录,将此目录下的所有文件都可以转入数据库

05-07 09:56