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 # user >> Error in importing Postgresql Data type inet in Sqoop


Copy link to this message
-
Re: Error in importing Postgresql Data type inet in Sqoop
Hi Savitha,
I would strongly recommend to drop the parameter --driver. In almost all cases it's usage is incorrect - check out blog post at [1] for more details.

I believe that Sqoop do not supports inet type and hence you have to help Sqoop overcome this. One option is to use --map-column-java and try to cast it to String or something. Another option would be use --query argument and convert the type inside the query. Sadly neither of those options will work with import-all-tables option. You can however import all tables except of those with this type using import-all-tables (hint you can exclude those tables with --exclude-tables) and import the rest one by one.

Jarcec

Links:
1: https://blogs.apache.org/sqoop/entry/connectors_and_drivers_in_the

On Thu, Apr 17, 2014 at 12:40:37PM +0000, Savitha Devi Inbasekaran wrote:

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

iQIcBAEBAgAGBQJTaPTrAAoJEEk45sAabwqGVQYQANSuYkYi9v43ojatX1EWM4Ag
tCpXZkYYyJrHNIONxrJGT0XGQDnGSaDXpRlhKthTgkqczY3A/rVCe7bDZeHTvx//
1M2zOgFm8Kw9sTk2goaWhKC63wE9PUnjV+G0yN3eb0NWb6tP2tDFUQPluxGQrtJY
SS7r3Q8wpSZuC1puYGc9oWjo+rZ3cplRCfhZbndz3ESSoYImAdWwM2NkeDWZh5T4
514gutOWOZy83oEtjScOKbzk8wVrdTfMgLhdT++MrC5HkGGawBRuBN2/9+0PcGfQ
JlTqXOdn3mUTrmF8JJTBEWG2QhKM53YPO4xJq/Y1pT2DN/SAXqLRZ6VbiSbNq9zK
1lRh9R2lx+jBE6jqIKh4DyLZhuEUCzLpOxPxvfEqGh/z6mgyTewqIrW9kxjWsEHP
M7CuS/MeYR6XtTZDtBxzo00T415ruPCUqOAjhUB2WN7m9Fa2Bb3Pm37wVGDmcfTH
dvN3blfZzpQrBwDA38j8emNTufmRRwa8fva6wlcLHG5NKOmdziHvYHRgO6OUdS/m
vA1DcqGlUtmGo9/iH7JJDgI+1LjkxNnr1x6w2fPZ3LkRQirYTNKq7YNc8jrdJD4C
Px2wloFvUBezJbQfsp1VkYwan639VUcUO3ppufNKrpgBhdtK4BExq7qXnlr27A5y
SMR8JqnSXsoH2tPE1bxs
=gcPZ

 
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