create external table if not exists sensor.building1 (BuildingID int,BuildingMgr string , BuildingAge string, HVACproduct string , Country string) row format delimited fields terminated by ',';

load data  inpath '/user/cloudera/sensor/SensorFiles/building.csv' into table sensor.building1;

select a.BuildingID from sensor.building1 as a limit 10;

create external table test1(country string, name string) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' LINES TERMINATED BY 'n';