How to Validate the record count on SQOOP import from SQL


#1

I am importing the data from SQL to HDFS and I use --Query command to get the flagged data to bring every day delta from the SQL table, So I tried to use --Query command along with the --Validate command in combo but looks I cant use both of them on Sqoop Import, Has to be used separately.

Is there any way that I can use both of them together or alternatives can be done ?
or
After I loaded the data into hive table I could get the count of records but how to compare with the source SQL table, Any solution ?