Table of Contents

Search

  1. Preface
  2. Introduction to Informatica Data Engineering Integration
  3. Mappings
  4. Mapping Optimization
  5. Sources
  6. Targets
  7. Transformations
  8. Python Transformation
  9. Data Preview
  10. Cluster Workflows
  11. Profiles
  12. Monitoring
  13. Hierarchical Data Processing
  14. Hierarchical Data Processing Configuration
  15. Hierarchical Data Processing with Schema Changes
  16. Intelligent Structure Models
  17. Blockchain
  18. Stateful Computing
  19. Appendix A: Connections Reference
  20. Appendix B: Data Type Reference
  21. 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 September 28, 2020