Administration and Configuration Guide Data Management Tools (DMT) Module Configurations Sqoop Configuration Steps for Configuring Sqoop Sqoop 1 Client Mode Limitations of Sqoop 1 Limitations of Sqoop 1 Derived Column cannot be used as the split by column, hence should not have field order 1. Date Type Column cannot be used as the split by column. (Sqoop Limitation: Sqoop-1946). Hence it should not have field order 1.