XbxH8VC4

1create external table if not exists sensor.building1 (BuildingID int,BuildingMgr string , BuildingAge string, HVACproduct string , Country string) row format delimited fields terminated by ',';
2	
3load data  inpath '/user/cloudera/sensor/SensorFiles/building.csv' into table sensor.building1;
4	
5select a.BuildingID from sensor.building1 as a limit 10;
6	
7create external table test1(country string, name string) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' LINES TERMINATED BY 'n';