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 Plain View
Sqoop >> mail # user >> Does sqoop2 support Teradata?


+
John Ho 2014-03-14, 03:57
+
Jarek Jarcec Cecho 2014-03-14, 17:18
+
John Ho 2014-03-18, 05:27
Copy link to this message
-
Re: Does sqoop2 support Teradata?
You seems to be using VARCHAR column for creating splits, which is generally very bad idea. I would strongly advise you to use a number column instead.

There is many things that can go wrong with using VARCHAR as a partition column. Looking at the exception my wild guess would be charset - are you explicitly stating that the connection should be in UTF? If not than Teradata default charset is ASCII that clearly won't work.

http://developer.teradata.com/doc/connectivity/jdbc/reference/current/jdbcug_chapter_2.html#URL_CHARSET

Jarcec

On Tue, Mar 18, 2014 at 01:26:39PM +0800, John Ho wrote:

 -----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)

iQIcBAEBAgAGBQJTKGpEAAoJEEk45sAabwqGd6wP+wVYpg4OFLVKNfwF80MGFNns
WpGensOZL2UuobIZMaviodTqSjQfrJQuDsj0er37NVBtomOhIqlXRz9XrXG3TAYc
JW/mKCtlH74Nye+alh2n2ClPAnXfcsHpb4Gbs3EeGl1mh0y0rUzWYl64n18hhFPf
FFEG+k2lgFIU4TIAKle6HCtewiQHJPr4A3y5kPHzTiGCojBvn9QqG5KdbESQsC3J
icpRaK6Nv9UqikIp5hOGu8avmn+UlbH/PVB2tRiHbEuxqnfCJcDzEmCn486hJTQE
zb24vehEfrssyN6qcQSIkiUSHopQYCpu8QCcza4Tcs7xcNFvePg0uJcwo/U7hgOb
D8s2Xke2k8pGQAjnqNRt4lP+Pyx8/vNF8qal9KUCjpLoMh93OjsY00+1F+4zG9gI
+j+tNzRJ3rcawCZuwgOSpeXMty/ZR7yxJt2D9MVexFHNJ2LoBJFlybHcms7oQiZj
djfjtvIZw+fZQiazjqxa16rFrc9tjoNLCd/18vf4adTxJv8EWMvac6bXrJSCUsPv
zdsGG5n1wS8Gyw5/w8imHY7vA0cWaiOUn9OcJvodpJ6CwrCbzepz6domDsAxL6hy
dCBMXZhZAUVjGeIMDYJqbecQ/wBHXvte7tSTq2ulac8Un2eIZXPUOIHbohpck8Rp
4OYW3n4u1VPlFiKBHr+N
=o7zm

 
+
John Ho 2014-03-19, 03:49
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