https://community.cloudera.com/t5/Archives-of-Support-Questions/What-exactly-sqoop-will-validate-with-validate-option/m-p/161225#M49342 <P></P><P>The validate option works only on tables in HDFS, not on those in Hive and HBase. It works both with "import" and "export" Sqoop commands. The default validation class is org.apache.sqoop.validation.RowCountValidator which compares the number of rows in the source and destination tables. You can customize it by providing your own validation class, which must implement the org.apache.sqoop.validation.Validator interface. Check also the <A href="https://community.hortonworks.com/questions/66990/data-validation-after-sqoop-command-execution.html">response</A> to the same question asked before, and <A href="https://sqoop.apache.org/docs/1.4.6/SqoopUserGuide.html">Sqoop documentation</A>, chapter 11.</P> Mon, 19 Dec 2016 21:03:26 GMT pminovic 2016-12-19T21:03:26Z https://community.cloudera.com/t5/Archives-of-Support-Questions/What-exactly-sqoop-will-validate-with-validate-option/m-p/161223#M49340 Mon, 19 Dec 2016 15:13:21 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/What-exactly-sqoop-will-validate-with-validate-option/m-p/161223#M49340 rajj206 2016-12-19T15:13:21Z https://community.cloudera.com/t5/Archives-of-Support-Questions/What-exactly-sqoop-will-validate-with-validate-option/m-p/161224#M49341 <P><A rel="user" href="https://community.cloudera.com/users/14971/rajj206.html" nodeid="14971">@Rajendra Kalepu</A></P><P>Validate option is to validate the data being imported into HDFS/Hive table against the input table using the table row count and number of rows copied. Refer to the <A href="https://sqoop.apache.org/docs/1.4.6/SqoopUserGuide.html#validation">link</A> for details.</P> Mon, 19 Dec 2016 15:16:20 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/What-exactly-sqoop-will-validate-with-validate-option/m-p/161224#M49341 ssubhas 2016-12-19T15:16:20Z https://community.cloudera.com/t5/Archives-of-Support-Questions/What-exactly-sqoop-will-validate-with-validate-option/m-p/161225#M49342 <P></P><P>The validate option works only on tables in HDFS, not on those in Hive and HBase. It works both with "import" and "export" Sqoop commands. The default validation class is org.apache.sqoop.validation.RowCountValidator which compares the number of rows in the source and destination tables. You can customize it by providing your own validation class, which must implement the org.apache.sqoop.validation.Validator interface. Check also the <A href="https://community.hortonworks.com/questions/66990/data-validation-after-sqoop-command-execution.html">response</A> to the same question asked before, and <A href="https://sqoop.apache.org/docs/1.4.6/SqoopUserGuide.html">Sqoop documentation</A>, chapter 11.</P> Mon, 19 Dec 2016 21:03:26 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/What-exactly-sqoop-will-validate-with-validate-option/m-p/161225#M49342 pminovic 2016-12-19T21:03:26Z