User Guide

10.2.2
- 10.5.7
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0
- 10.2.2 HotFix 1
- 10.2.2 Service Pack 1
- 10.2.1

Back Next

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.

Open the Sqoop data object and click the

Query

tab in the

Properties

view.

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.

Open the Sqoop mapping and click the

Parameters

tab in the

Properties

view.

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.

Rename Saved Search

Table of Contents

User Guide

User Guide

Reading Data from Vertica Sources through Sqoop

Reading Data from Vertica Sources through Sqoop