YEZRGufy

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