What is Hadoop Sqoop? What is FLUME – Hadoop Tutorial




What is Hadoop Sqoop? What is FLUME – Hadoop Tutorial In this Article we are going to learn hadoop sqoop and hadoop flume. Before we learn more about Flume and Sqoop , lets study Issues with Data Load into Hadoop Analytical processing using Hadoop requires loading of huge amounts of data from diverse sources into Hadoop clusters. This process of […]

Read more

Sqoop Interview Questions And Answers




Sqoop Interview Questions And Answers What is Sqoop? Sqoop is an open source project that enables data transfer from non-hadoop source to hadoop source. It can be remembered as SQL to Hadoop -> SQOOP. It allows user to specify the source and target location inside the Hadoop.  

Read more

Sqoop Interview Questions and Answers for Experienced




Sqoop Interview Questions and Answers for Experienced In this post we will provide some practical Sqoop Interview Questions and Answers for experienced hadoop developers. Sqoop Interview Questions and Answers for Experienced 1. What is Sqoop? Sqoop is an open source tool that enables users to transfer bulk data between Hadoop eco system and relational databases. 2. What are the relational databases […]

Read more

SQOOP Installation on Ubuntu




SQOOP Installation on Ubuntu In this post we will discuss about the basic introduction to Sqoop and Sqoop Installation on Ubuntu machine and we will discuss about example run of Sqoop from MySQL database in the next post. SQOOP Introduction: What is Sqoop? Sqoop is open source tool that enables users to transfer bulk data between Hadoop eco system and relational […]

Read more

Sqoop Importing MySQL Data into HDFS




Sqoop Importing MySQL Data into HDFS In this post, we will create a new database in MySQL server and create table and insert data into it and we will do importing MySQL data into HDFS via Sqoop tool. We assume that MySQL is installed and Sqoop & Hadoop are installed on local machine to test this example. We need to make sure […]

Read more

Sqoop Import Command Arguments




Sqoop Import Command Arguments In this post we will discuss about one of the important commands in Apache Sqoop, Sqoop Import Command Arguments with examples. This documentation is applicable for sqoop versions 1.4.5 or later because earlier versions doesn’t support some of the below mentioned arguments to import command As of Sqoop 1.4.5 version, Sqoop import command supports various number […]

Read more

Sqoop Export Commands




Sqoop Export Commands Below are some Sqoop Export Commands and Other Miscellaneous commands Sqoop-export It is nothing but exporting data from HDFS to database. To use ‘export‘ command, a table in database should already exist. then only export functionality in sqoop will works. export command will works in two ways 1. insert 2. update 1. insert: insert mode will insert […]

Read more

Sqoop Hive Use Case Example




Sqoop Hive Use Case Example This is another Use case on Sqoop, Hive concepts. Hive Use Case Example. Hive Use Case Example Problem Statement There are about 35,000 crime incidents that happened in the city of San Francisco in the last 3 months. Our task is to store this relational data in an RDBMS. Use Sqoop to import it into Hadoop. Can we […]

Read more