Table of Contents

Search

  1. Preface
  2. Introduction to Informatica Big Data Management
  3. Mappings
  4. Sources
  5. Targets
  6. Transformations
  7. Data Preview
  8. Cluster Workflows
  9. Profiles
  10. Monitoring
  11. Hierarchical Data Processing
  12. Hierarchical Data Processing Configuration
  13. Hierarchical Data Processing with Schema Changes
  14. Intelligent Structure Models
  15. Stateful Computing
  16. Appendix A: Connections
  17. Appendix B: Data Type Reference
  18. Appendix C: Function Reference

Reading Data from Vertica Sources through Sqoop

Reading Data from Vertica Sources through Sqoop

To read Vertica data through Sqoop connectivity, Sqoop requires a custom query.
Create the custom query with the
$CONDITIONS
parameter in the WHERE clause. Then, define a mapping parameter with the name as
CONDITIONS
and set its value to
$CONDITIONS
. At run time, Sqoop replaces
$CONDITIONS
with a unique condition expression.
  1. Open the Sqoop data object and click the
    Query
    tab in the
    Properties
    view.
  2. Define a custom query and include
    $CONDITIONS
    in the WHERE clause of the custom query as shown in the following image: The image shows a dummy custom query that contains $CONDITIONS in the WHERE clause.
  3. Open the Sqoop mapping and click the
    Parameters
    tab in the
    Properties
    view.
  4. Define a mapping parameter with the name as
    CONDITIONS
    and set its value to
    $CONDITIONS
    as shown in the following image: The image shows a mapping parameter with the name set to CONDITIONS and value set to $CONDITIONS.


Updated July 10, 2020