Sqoop Where Clause

by Online Tutorials Library July 14, 2014

Sqoop Where

You can place restrictions on data imported by using “where” clause. Let’s import cityByCountry table where state ( 6th column is restricted to “Alaska”).

Sqoop MySQL where clause

The Sqoop statement is written below

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

Output is shown below

Sqoop MySQL where output

Let’s list all databases present on a mysql server using a “list-databases” tool.

Note : for more information on list-databases, type “$ sqoop help list-databases”.

 $ sqoop list-databases –connect “jdbc:mysql://localhost” –username cloudera –password cloudera 

Similarly for listing tables

 $ sqoop list-tables –connect “jdbc:mysql://localhost/training” –username cloudera -P 

Next TopicSqoop Export

Sqoop Where Clause

Sqoop Where

Note : for more information on list-databases, type “$ sqoop help list-databases”.

Applications of Big Data

Green Tea Weight Loss

You may also like