Rules and Guidelines for Sqoop Microsoft SQL Server Data Types

Use the Varbinary data type if the target table that you write to has a column of binary data type because Spark DataFrame does not have a corresponding data type to match its native type and the mapping might throw a runtime exception.
Use the Varbinary data type only if you have imported the table while creating the relational target or you selected the
Create or replace table at runtime
property in the Advance properties. Spark DataFrame does not have a corresponding data type to match its native type.
If you export timestamp data, an error occurs as the timestamp data is automatically generated by the database. Use the datetime data type.