week6

MySQL

accounts device

webpage

HDFS

/loudacre/accounts /loudacre/devices

Sqoop Import

H ad

o o

p C

lu st

er

/localhost/ ….Java Code

MySQL

accounts device

webpage /loudacre/accounts /loudacre/devices

Sqoop Import

H ad

o o

p C

lu st

er

/localhost/ ….Java Code Local Linux OS

HDFS

IMPALA HIVES

Hive and Impala

Impala and Hive are both tools that provide SQL querying of data

stored in HDFS / HBase

Source: Cloudera.com

Hive and Impala

Starting Hive and Impala

Starting Hive

• $sudo service zookeeper-server start

• $ sudo service hive-server2 start

• $Hive

01 Starting Impala

• $impala-shell

• >>Invalidate Metadata

02