Cloudera Community

Support Questions

Find answers, ask questions, and share your expertise
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Advanced Search
Announcements
Celebrating as our community reaches 100,000 members! Thank you!
Solved Go to solution

sqoop import

Labels:
avatar
author-rank nilesh_shrimant
Contributor

Created ‎12-17-2016 01:01 PM

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

951 Views
0 Kudos
1 ACCEPTED SOLUTION

avatar
author-rank aervits
Master Mentor

Created ‎12-17-2016 02:23 PM

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

739 Views
1 REPLY 1

avatar
author-rank aervits
Master Mentor

Created ‎12-17-2016 02:23 PM

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

740 Views
webinar banner
Announcements
Community Announcements
April 2024 Community Highlights
Community Announcements
January 2024 Community Highlights
Product Announcements
[ANNOUNCE] Cloudera on Public Cloud Runtime 7.2.18 is GA!
What's New @ Cloudera
Cloudera Operational Database (COD) supports enhancements to...
Community Announcements
March 2024 Community Highlights
View More Announcements
meetups banner