Related note 0
Related note 1
Related note 2
Hive Table
Hive table source
Properties
Properties supported in this source are shown below (
*
indicates required fields )
Property
Description
Name
*
Name of the data source
Description
Description of the data source
Table
*
Database and table name
Example:
${DATABASE}.${TABLENAME}
Schema
Source schema to assist during the design of the pipeline
Normalize Column Names
Normalizes column names by replacing special characters ,;{}()&/\n\t= and space with the given string
Example:
_
Select Fields / Columns
Comma separated list of fields / column names to select from source
Default:
*
Filter Expression
SQL where clause for filtering records
Example:
date = '2022-01-01',year=22 and month = 6 and day = 2
Distinct Values
Select rows with distinct column values
Default:
false