Sqoop Frequently Asked Questions (FAQ)
(Doc ID 1510470.1)
Last updated on AUGUST 31, 2023
Applies to:
Big Data Appliance Integrated SoftwareLinux x86-64
Purpose
This document provides answers to frequently asked questions about Sqoop distributed by Cloudera for use on the Oracle Big Data Appliance(BDA).
Questions and Answers
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Purpose |
| Questions and Answers |
| What is Sqoop? |
| Where can I find the Sqoop Documentation? |
| Where are Cloudera Sqoop Blogs? |
| What versions of Sqoop automatically support Oracle Database and MySQL on the Oracle Big Data Appliance(BDA)? |
| Does the Sqoop export command support the --query argument? |
| Does Sqoop support incremental exports? |
| Does Sqoop support various connectors for transferring data? |
| Does Sqoop support entering an encrypted password? |
| Where can I find information on the Sqoop Teradata Connector? |
| Is Cloudera Connector for Teradata Version 1.1.1 compatible with BDA V2.0.1? |
| What is the recommended BDA node to install the Sqoop Teradata Connector? |
| Does Sqoop export support a --where parameter to filter out rows and columns during export? |
| Is there an option to read a Hive table (via Hive SQL ) and export the results? That would be something like --query on Sqoop export? |
| Is it possible to import tables into Hive running Sqoop with the --hive-import argument and either --as-avrodatafile or --as-sequencefile? |
| Can imported hive tables be created at a location other than /user/hive/warehouse directory using the --warehouse-dir or --target-dir option to specify a different warehouse directory? |
| Does 4.1.2 Sqoop support Hive external tables? |
| How to use the ShareLib in Apache Oozie in CDH 5? |
| When does new Oozie shared lib directories get created with timestamp (i.e /user/oozie/share/lib/lib_20140629002327)? And do the old timestamp directories be deleted automatically? |
| Directories under path /user/oozie/share/lib were used by CDH4 but not used in CDH5. Is this correct? If yes then why is this dir not cleaned up during upgrade & can they be cleaned up manually ? |
| In CDH5, the new Oozie shared lib directories are created inside /user/oozie/share/lib/ and not parallel to it. Is that expected ? |
| Can I use Oracle Wallet to store Oracle database password and use it with sqoop on Oracle Big Data Appliance? Do you have any procedure to do this? |
| What is the difference between Sqoop 1 and Sqoop 2? |
| References |