Can we use Apache Sqoop and Hive both together What is the difference between the two

Question

I know that sqoop is used to import/export data from RDBMS to HDFS and Hive is a SQL layer abstraction on top of Hadoop. Can I can use Sqoop for importing data into HDFS and then use Hive for querying?

Answer 1

Yes, you can. In fact many people use sqoop and hive for exactly what you have told.

In my project what I m doing is loading the historical data from my RDBMS which was SQL, move it to HDFS. I had hive external tables defined for this path. This allowed me to run hive queries to do transformations. Also, we used to write mapreduce programs on top of these data to come up with various analysis.