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

Youtube For Videos Join Our Youtube Channel: Join Now


Help Others, Please Share

facebook twitter pinterest

Learn Latest Tutorials


Trending Technologies

B.Tech / MCA