-bug doing --incremental append with text columns
Benbenek, Waldyn J 2013-04-01, 18:25
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.