sqoop - Sqoop Where Clause - apache sqoop - sqoop tutorial - sqoop hadoop

The WHERE clause is used to filter records.
The WHERE clause is used to extract only those records that fulfill a specified condition.
You can place limitations on data imported by using "where" clause.

Example

Let's import cityByCountry table where state (6th column is restricted to "Alaska").

Learn Sqoop - Sqoop tutorial - Where Sqoop - Sqoop examples - Sqoop programs

sqoop import \ --connect "jdbc:mysql://localhost/training" \ --username training -P \ --table cityByCountry \ --target-dir /user/where_clause \ --where "state = 'Alaska'" \ -m 1

Click "Copy code" button to copy into clipboard - By wikitechy - sqoop tutorial - team

Output

Learn Sqoop - Sqoop tutorial - Where Clause Sqoop - Sqoop examples - Sqoop programs

Note: For more information on list-databases, type "$ sqoop help list-databases"

$ sqoop list-databases --connect "jdbc:mysql://localhost" --username cloudera --password cloudera

Click "Copy code" button to copy into clipboard - By wikitechy - sqoop tutorial - team

Related Searches to Sqoop Where Clause

where clause in mysqlwhere clause mysqlselect query with where clausesqoop where clausemysql select in where clauseselect query in mysql with where clauseteradata date in where clauseselect statement in mysql with where clauseoracle where clause syntaxwhere clause examplesqoop wheresqoop must contain '$conditions' in where clausesqoop query must contain '$conditions' in where clausesqoop free form query import examplesqoop import all tablessqoop import to hivesqoop where 1=0sqoop query with where clausesqoop export commandsqoopapache sqoopsqoop tutorialsqoop hadoopsqoop importsqoop interview questionssqoop exportsqoop commandssqoop user guidesqoop documentationsqoop downloadsqoop import to hivewhat is sqoopsqoop2sqoop jobsqoop exampleapache sqoop tutorialsqoop big datasqoop architecturesqoop import examplesqoop tutorial pdfsqoop import commandsqoop installationsqoop logoapache sqoop cookbooksqoop import to hdfssqoop oraclesqoop 2sqoop import all tableshadoop sqoop tutorialapache sqoop cookbook pdfcloudera sqoopsqoop interview questions and answers for experiencedsqoop vs flumesqoosqoop export examplesqoop sql serversqoop export commandsqoop metastorewhat is sqoop in hadoopinstall sqoop

sqoop - Sqoop Where Clause - apache sqoop - sqoop tutorial - sqoop hadoop

What is Where clause in Sqoop?

Example

Click "Copy code" button to copy into clipboard - By wikitechy - sqoop tutorial - team

Output

Click "Copy code" button to copy into clipboard - By wikitechy - sqoop tutorial - team

Related Searches to Sqoop Where Clause

Wikitechy

Workshop

Join our Community

Other Languages