Javatpoint Logo
Javatpoint Logo

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

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".

Similarly for listing tables

Next TopicSqoop Export




Help Others, Please Share

facebook twitter google plus pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA