Support Questions

Find answers, ask questions, and share your expertise

sqoop import

avatar
Contributor

How to use oracle database tns string in Sqoop connect parameter?

1 ACCEPTED SOLUTION

avatar
Master Mentor

One example

sqoop import -D oracle.sessionTimeZone=America/Los_Angeles \
    --connect jdbc:oracle:thin:@//db.example.com/foo --table bar

https://sqoop.apache.org/docs/1.4.6/SqoopUserGuide.html#_oracle

View solution in original post

1 REPLY 1

avatar
Master Mentor

One example

sqoop import -D oracle.sessionTimeZone=America/Los_Angeles \
    --connect jdbc:oracle:thin:@//db.example.com/foo --table bar

https://sqoop.apache.org/docs/1.4.6/SqoopUserGuide.html#_oracle