How to import selected columns in Sqoop

Question

Hi. Please help me out, I want to import a table into sqoop but instead of importing the whole table, I just want to import certain columns (Name and Salary) into Sqoop. How can I add a filter to import just the selected columns?

Answer 1

If you want to import selected columns, then while using sqoop import command, you have to specify which columns you want to import the columns. Refer to the code below:

$ sqoop import <all parameters> --columns <colname1, colname2, ... colname3>