Cloudera Community

Archives of Support Questions (Read Only)

This is an archived board for historical reference. Information and links may no longer be available or relevant
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
This board is archived and read-only for historical reference. To ask a new question, please post a new topic on the appropriate active board.
Solved Go to solution

sqoop import

Labels:
avatar
author-rank nilesh_shrimant
New Member

Created ‎12-17-2016 01:01 PM

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

1,712 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

1,500 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

1,501 Views
Announcements
What's New @ Cloudera
Cloudera Real time Monitoring for 7.1.9+ and 7.2.18+ with Cl...
What's New @ Cloudera
Announcing Cloudera Streaming Analytics 1.17: Python UDFs, S...
Community Announcements
Content Update: Evolving Our Community Content for Better, A...
Community Announcements
Product Name Updates — Community Label Changes & Notificatio...
What's New @ Cloudera
Announcing Cloudera Data Lineage for Trino
View More Announcements