Sqoop generates a query that is incorrect for text based columns when doing an -incremental append .
The following query is incorrect when CUSTOMERID has type text. CUST1 and CUST8 should have single quotes around them. SELECT MIN(CUSTOMERID), MAX(CUSTOMERID) FROM STORECUSTOMER WHERE ( CUSTOMERID > CUST1 AND CUSTOMERID <= CUST8 AND (CUSTOMERID > '0') ) This will fail against every data base I have tried. The fix is quite simple. Waldyn Benbenek
