Home | About | Sematext search-lucene.com search-hadoop.com
 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