Member since
07-18-2017
4
Posts
0
Kudos Received
0
Solutions
02-14-2020
02:14 AM
@Asoka wrote: I've 'solved' my problem by using -P. I'll need to manually type my password for each table as I export them, but this is a mostly one-time operation, so the pain is minor. Use — P Option with Sqoop Command Sqoop supports reading passwords via standard input (STDIN). You can use this option by with help of — P options with sqoop command. Sqoop will prompt you for the password. Below is the example of using — P option: $sqoop import --connect jdbc:netezza://localhost/MYDB \
--username testuser -- P --table ORDERS
... View more
07-18-2017
05:25 PM
May or may not be helpful - I'm exporting tables from the cluster that start in avro format. I couldn't use the --export-dir parameter for their metadata; but using --hcatalog-table is working to get export connected up with table metadata so it knows the structure of the data being exported. For me, this is exporting to Postgres - I'd expect the same behavior for any other relational database, as this lookds to me like a question of metadata on the cluster end of the export, rather than the insert/update statements on the relational database.
... View more