gf0kSbiZ

1sample.csv
2Dan,50
3Dave,20
4Sam,30
5	
6hadoop fs -copyFromLocal ./sample.csv /user/me/sample.csv
7	
8$ hive
9hive> Create EXTERNAL TABLE IF NOT EXISTS sample(NAME STRING, Grade int)
10hive> ROW FORMATED DELIMITED FILED TERMINATED BY ','
11hive> STORED AS TEXTFILE location '/user/me/sample.csv';