Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Sqoop >> mail # dev >> bug doing --incremental append with text columns


Copy link to this message
-
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

NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB