Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Sqoop, mail # dev - bug doing --incremental append with text columns


Copy link to this message
-
bug doing --incremental append with text columns
Benbenek, Waldyn J 2013-03-29, 18:45
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
+
Jarek Jarcec Cecho 2013-03-29, 20:52
+
Benbenek, Waldyn J 2013-04-01, 18:25