You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@sqoop.apache.org by "Benbenek, Waldyn J" <Wa...@UNISYS.com> on 2013/04/01 20:25:21 UTC

bug doing --incremental append with text columns

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