Showing posts with the label Sqoop commands

Featured Post

How to Compare Text in Python

Python like other programming languages supports comparison operators. These primarily use to test the condition in the program. Here's a list of operators that you can use in python programs. Comparison operators List of operators < <= > >= == != Is is not How to use comparison operators Here, I have assigned 23 to a and 11 to b. Then, I did apply all the comparison operators. The output is self-explanatory, and If you are in doubt while programming, remember to visit this page. Examples a = 23 b = 11 print("Is a greater than b?", a > b)           #greater than print("Is a less than b?", a < b)              #less than print("Is a greater or equal to b?", a >= b)   #greater or equal print("Is a less or equal to b?", a <= b)      #less or equal print("Is a equal to b (option 1)?", a == b)         #test for equality print("Is a equal to b (option 2)?", a is b)         #test for equality print("I

Sqoop Real Use in Hadoop Framework

Why Sqoop you need while working on Hadoop-The Sqoop and its primary reason is to import data from structural data sources such as Oracle/DB2 into HDFS(also called Hadoop file system). To our readers, I have collected a good video from Edureka which helps you to understand the functionality of Sqoop. The comparison between Sqoop and Flume How name come for Sqoop Sqoop word came from SQL+HADOOP=SQOOP. And Sqoop is a data transfer tool. The main use of Sqoop is to import and export a large amount of data from RDBMS to HDFS and vice versa. List of basic Sqoop commands Codegen- It helps to generate code to interact with database records. Create-hive-table- It helps to Import a table definition into a hive Eval- It helps to evaluate SQL statement and display the results Export-It helps to export an HDFS directory into a database table Help- It helps to list the available commands Import- It helps to import a table from a database to HDFS Import-all-tables- It