My Oracle Support Banner

Sqoop Frequently Asked Questions (FAQ) (Doc ID 1510470.1)

Last updated on OCTOBER 15, 2016

Applies to:

Big Data Appliance Integrated Software
Linux 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 ?
 How to configure encryption for on flight for SQOOP when data importing from Source? Are any ssl parameters need on SQOOP URI or are any configuration changes on BDA and Source related to SQOOP needed or do new drivers (SQL, ORACLE, DB2) need to be used to support SSL (Encryption at flight)?
 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.