sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Benbenek, Waldyn J" <Waldyn.Benbe...@UNISYS.com>
Subject bug doing --incremental append with text columns
Date Mon, 01 Apr 2013 18:25:21 GMT
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


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message