Database Reference
In-Depth Information
load data local inpath '/home/vivek/Documents/
apress_book/Apress/datafiles/person_store'
overwrite into table employee ;
4.
Finally, we can explore the inserted data (see
Figure 6-15
):
select * from employee;
Figure 6-15
.
Fetched rows from the employee table
Let's talk about what a Hive, Hadoop, and Cassandra-based architecture would
look like. The image in
Figure 6-16
depicts how a Hive-powered MapReduce job
would run over Cassandra data nodes. Here each Hive query will get converted into a
MapReduce job and submitted with Hadoop which in turn would rely on the name
node and metadata to identify Cassandra data nodes to run corresponding maps and re-
duce tasks locally on those data nodes.
