Database Reference
In-Depth Information
1.
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;