Database Reference
In-Depth Information
1.
Let's put the tweets file on HDFS using the put command (see Fig-
ure 6-19 ) :
bin/hadoop fs -put /home/vivek/Documents/
apress_book/Apress/datafiles/person_store
/usr/vivek/employee_store/infile
Figure 6-19 . A Hive directory with employee records
2.
Then, we can create an external table in Hive over the HDFS loca-
tion:
create external table employee_ext(person_id
string, fname string) row format delimited
fields terminated by ',' location
'hdfs://localhost:9000/usr/vivek/
employee_store';
Here hdfs://localhost:9000 is the value of
fs.default.name property.
3.
We can explore the inserted data (see Figure 6-20 ):
select * from employee_ext;
 
 
 
Search WWH ::




Custom Search