Question

Sqoop can also import the data into Hive by generating and executing a ____________ statement to define the data’s layout in Hive.

(a) SET TABLE

(b) CREATE TABLE

(c) INSERT TABLE

(d) All of the mentioned

This question was posed to me by my school teacher while I was bunking the class.

I need to ask this question from Sqoop with Hadoop in portion ZooKeeper, Sqoop and Cassandra of Hadoop

Answer 1

The correct choice is (b) CREATE TABLE

Easiest explanation: Importing data into Hive is as simple as adding the –hive-import option to your Sqoop command line.