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

The Sqoop statement is written below

Output is shown below

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