Benbenek, Waldyn J 2013-03-29, 18:45
Jarek Jarcec Cecho 2013-03-29, 20:52
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.