Sqoop import validation

Question

Hi. I am using Sqoop to send data from database to hdfs using sqoop import command. I want to know if there's a way that Sqoop will validate if the data transferred is valid or not. Please help

Answer 1

Hi. Sqoop allows you to validate the data using the --validate option. But this option will only check the number of rows in source and destination table. You can use it as follows:

$ sqoop import <all the parameters> --validate