suppose I have the date field and I gave invalid date like 2020-20-90, instead of rejecting record, pipeline loading with 0001-01-01, please let me know how can the record be rejected with out loading with pipeline approach.
Set the data_conversion_compatibility_level global variable to 6.5 or 7.0 (if your running 7.0). That will cause MemSQL to generate errors on conversions instead of trying to coerce types in most cases.
i.e., Connect to your master agg and run:
set global data_conversion_compatibility_level = '7.0'