SQOOP_CLIENT Properties in Cloudera Runtime 7.3.1

Role groups:

Gateway

Advanced

SQOOP_CLIENT Service Advanced Configuration Snippet (Safety Valve) for atlas-application.properties

Description
For advanced use only, a string to be inserted into atlas-application.properties. Applies to configurations of all roles in this service except client configuration.
Related Name
Default Value
API Name
application_properties_safety_valve
Required
false

Deploy Directory

Description
The directory where the client configs will be deployed
Related Name
Default Value
/etc/sqoop
API Name
client_config_root_dir
Required
true

Gateway Advanced Configuration Snippet (Safety Valve) for cm_manager_overrides

Description
For advanced use only. A string to be inserted into cm_manager_overrides for this role only.
Related Name
Default Value
API Name
sqoop-conf/managers.d/cm_manager_overrides_client_config_safety_valve
Required
false

Gateway Advanced Configuration Snippet (Safety Valve) for sqoop-env.sh

Description
For advanced use only. A string to be inserted into sqoop-env.sh for this role only.
Related Name
Default Value
API Name
sqoop-conf/sqoop-env.sh_client_config_safety_valve
Required
false

Gateway Advanced Configuration Snippet (Safety Valve) for sqoop-site.xml

Description
For advanced use only. A string to be inserted into sqoop-site.xml for this role only.
Related Name
Default Value
API Name
sqoop-conf/sqoop-site.xml_client_config_safety_valve
Required
false

Monitoring

Enable Configuration Change Alerts

Description
When set, Cloudera Manager will send alerts when this entity's configuration changes.
Related Name
Default Value
false
API Name
enable_config_alerts
Required
false

Other

Alternatives Priority

Description
The priority level that the client configuration will have in the Alternatives system on the hosts. Higher priority levels will cause Alternatives to prefer this configuration over any others.
Related Name
Default Value
90
API Name
client_config_priority
Required
true

Custom Beeline arguments

Description
Custom Beeline arguments provided to Sqoop's Hive import process
Related Name
sqoop.beeline-args
Default Value
API Name
sqoop_beeline_args
Required
false

Sqoop Connection Factories

Description
A list of ManagerFactory implementations which are consulted, in order to instantiate ConnManager instances used to drive connections to databases.
Related Name
sqoop.connection.factories
Default Value
API Name
sqoop_connection_factories
Required
false

Custom Hive create table statement

Description
Custom Hive create table statement provided to Sqoop's Hive import process
Related Name
sqoop.hive-create-table-statement
Default Value
API Name
sqoop_hive_create_table_statement
Required
false

Custom Hive JDBC arguments

Description
Custom Hive JDBC arguments provided to Sqoop's Hive import process
Related Name
sqoop.hive-jdbc-params
Default Value
API Name
sqoop_hive_jdbc_params
Required
false

Custom Hive table properties

Description
Custom Hive table properties provided to Sqoop's Hive import process
Related Name
sqoop.hive-table-properties
Default Value
API Name
sqoop_hive_table_properties
Required
false

Sqoop Tool Plugins

Description
A list of ToolPlugin implementations which are consulted, in order to register SqoopTool instances which allow third-party tools to be used.
Related Name
sqoop.tool.plugins
Default Value
API Name
sqoop_tool_plugins
Required
false

Suppressions

Suppress Parameter Validation: SQOOP_CLIENT Service Advanced Configuration Snippet (Safety Valve) for atlas-application.properties

Description
Whether to suppress configuration warnings produced by the built-in parameter validation for the SQOOP_CLIENT Service Advanced Configuration Snippet (Safety Valve) for atlas-application.properties parameter.
Related Name
Default Value
false
API Name
role_config_suppression_application_properties_safety_valve
Required
true

Suppress Configuration Validator: CDH Version Validator

Description
Whether to suppress configuration warnings produced by the CDH Version Validator configuration validator.
Related Name
Default Value
false
API Name
role_config_suppression_cdh_version_validator
Required
true

Suppress Parameter Validation: Deploy Directory

Description
Whether to suppress configuration warnings produced by the built-in parameter validation for the Deploy Directory parameter.
Related Name
Default Value
false
API Name
role_config_suppression_client_config_root_dir
Required
true

Suppress Parameter Validation: Gateway Advanced Configuration Snippet (Safety Valve) for cm_manager_overrides

Description
Whether to suppress configuration warnings produced by the built-in parameter validation for the Gateway Advanced Configuration Snippet (Safety Valve) for cm_manager_overrides parameter.
Related Name
Default Value
false
API Name
role_config_suppression_sqoop-conf/managers.d/cm_manager_overrides_client_config_safety_valve
Required
true

Suppress Parameter Validation: Gateway Advanced Configuration Snippet (Safety Valve) for sqoop-env.sh

Description
Whether to suppress configuration warnings produced by the built-in parameter validation for the Gateway Advanced Configuration Snippet (Safety Valve) for sqoop-env.sh parameter.
Related Name
Default Value
false
API Name
role_config_suppression_sqoop-conf/sqoop-env.sh_client_config_safety_valve
Required
true

Suppress Parameter Validation: Gateway Advanced Configuration Snippet (Safety Valve) for sqoop-site.xml

Description
Whether to suppress configuration warnings produced by the built-in parameter validation for the Gateway Advanced Configuration Snippet (Safety Valve) for sqoop-site.xml parameter.
Related Name
Default Value
false
API Name
role_config_suppression_sqoop-conf/sqoop-site.xml_client_config_safety_valve
Required
true

Suppress Parameter Validation: Custom Beeline arguments

Description
Whether to suppress configuration warnings produced by the built-in parameter validation for the Custom Beeline arguments parameter.
Related Name
Default Value
false
API Name
role_config_suppression_sqoop_beeline_args
Required
true

Suppress Parameter Validation: Sqoop Connection Factories

Description
Whether to suppress configuration warnings produced by the built-in parameter validation for the Sqoop Connection Factories parameter.
Related Name
Default Value
false
API Name
role_config_suppression_sqoop_connection_factories
Required
true

Suppress Parameter Validation: Custom Hive create table statement

Description
Whether to suppress configuration warnings produced by the built-in parameter validation for the Custom Hive create table statement parameter.
Related Name
Default Value
false
API Name
role_config_suppression_sqoop_hive_create_table_statement
Required
true

Suppress Parameter Validation: Custom Hive JDBC arguments

Description
Whether to suppress configuration warnings produced by the built-in parameter validation for the Custom Hive JDBC arguments parameter.
Related Name
Default Value
false
API Name
role_config_suppression_sqoop_hive_jdbc_params
Required
true

Suppress Parameter Validation: Custom Hive table properties

Description
Whether to suppress configuration warnings produced by the built-in parameter validation for the Custom Hive table properties parameter.
Related Name
Default Value
false
API Name
role_config_suppression_sqoop_hive_table_properties
Required
true

Suppress Parameter Validation: Sqoop Tool Plugins

Description
Whether to suppress configuration warnings produced by the built-in parameter validation for the Sqoop Tool Plugins parameter.
Related Name
Default Value
false
API Name
role_config_suppression_sqoop_tool_plugins
Required
true

Service-Wide

Advanced

SQOOP_CLIENT Service Environment Advanced Configuration Snippet (Safety Valve)

Description
For advanced use only, key-value pairs (one on each line) to be inserted into a role's environment. Applies to configurations of all roles in this service except client configuration.
Related Name
Default Value
API Name
SQOOP_CLIENT_service_env_safety_valve
Required
false

Monitoring

Enable Configuration Change Alerts

Description
When set, Cloudera Manager will send alerts when this entity's configuration changes.
Related Name
Default Value
false
API Name
enable_config_alerts
Required
false

Other

Atlas Service

Description
Name of the Atlas service that this Sqoop service instance depends on
Related Name
Default Value
API Name
atlas_service
Required
false

Parquet Writer Implementation

Description
Configure the library used during parquet jobs for writing and reading data. Possible values: hadoop, kite (legacy).
Related Name
parquetjob.configurator.implementation
Default Value
hadoop
API Name
parquetjob.configurator.implementation
Required
false

Sqoop Decimal Padding

Description
Enables padding for fixed point number types (decimal, number, numeric) in case of Avro and Parquet imports.
Related Name
sqoop.avro.decimal_padding.enable
Default Value
true
API Name
sqoop.avro.decimal_padding.enable
Required
false

Default Precision for Logical Types

Description
Specifies the default precision for fixed point number types. This value is only used if the precision was not specified in the source table.
Related Name
sqoop.avro.logical_types.decimal.default.precision
Default Value
38
API Name
sqoop.avro.logical_types.decimal.default.precision
Required
false

Default Scale for Logical Types

Description
Default scale for fixed point number types. This value is only used if the scale was not specified in the source table.
Related Name
sqoop.avro.logical_types.decimal.default.scale
Default Value
10
API Name
sqoop.avro.logical_types.decimal.default.scale
Required
false

Enable Avro Logical Types

Description
Enables the use of logical types in avro files, so that fixed point number types are converted to decimal during an import. Fixed point number types are converted to String if this property is set to false.
Related Name
sqoop.avro.logical_types.decimal.enable
Default Value
true
API Name
sqoop.avro.logical_types.decimal.enable
Required
false

Enable Parquet Logical Types

Description
Enables the use of logical types in parquet files, so that fixed point number types are converted to decimal during an import. Fixed point number types are converted to String if this property is set to false.
Related Name
sqoop.parquet.logical_types.decimal.enable
Default Value
true
API Name
sqoop.parquet.logical_types.decimal.enable
Required
false

Suppressions

Suppress Configuration Validator: SQOOP_CLIENT Service Advanced Configuration Snippet (Safety Valve) for atlas-application.properties

Description
Whether to suppress configuration warnings produced by the SQOOP_CLIENT Service Advanced Configuration Snippet (Safety Valve) for atlas-application.properties configuration validator.
Related Name
Default Value
false
API Name
role_config_suppression_application_properties_safety_valve
Required
true

Suppress Configuration Validator: CDH Version Validator

Description
Whether to suppress configuration warnings produced by the CDH Version Validator configuration validator.
Related Name
Default Value
false
API Name
role_config_suppression_cdh_version_validator
Required
true

Suppress Configuration Validator: Deploy Directory

Description
Whether to suppress configuration warnings produced by the Deploy Directory configuration validator.
Related Name
Default Value
false
API Name
role_config_suppression_client_config_root_dir
Required
true

Suppress Configuration Validator: Gateway Advanced Configuration Snippet (Safety Valve) for cm_manager_overrides

Description
Whether to suppress configuration warnings produced by the Gateway Advanced Configuration Snippet (Safety Valve) for cm_manager_overrides configuration validator.
Related Name
Default Value
false
API Name
role_config_suppression_sqoop-conf/managers.d/cm_manager_overrides_client_config_safety_valve
Required
true

Suppress Configuration Validator: Gateway Advanced Configuration Snippet (Safety Valve) for sqoop-env.sh

Description
Whether to suppress configuration warnings produced by the Gateway Advanced Configuration Snippet (Safety Valve) for sqoop-env.sh configuration validator.
Related Name
Default Value
false
API Name
role_config_suppression_sqoop-conf/sqoop-env.sh_client_config_safety_valve
Required
true

Suppress Configuration Validator: Gateway Advanced Configuration Snippet (Safety Valve) for sqoop-site.xml

Description
Whether to suppress configuration warnings produced by the Gateway Advanced Configuration Snippet (Safety Valve) for sqoop-site.xml configuration validator.
Related Name
Default Value
false
API Name
role_config_suppression_sqoop-conf/sqoop-site.xml_client_config_safety_valve
Required
true

Suppress Configuration Validator: Custom Beeline arguments

Description
Whether to suppress configuration warnings produced by the Custom Beeline arguments configuration validator.
Related Name
Default Value
false
API Name
role_config_suppression_sqoop_beeline_args
Required
true

Suppress Configuration Validator: Sqoop Connection Factories

Description
Whether to suppress configuration warnings produced by the Sqoop Connection Factories configuration validator.
Related Name
Default Value
false
API Name
role_config_suppression_sqoop_connection_factories
Required
true

Suppress Configuration Validator: Custom Hive create table statement

Description
Whether to suppress configuration warnings produced by the Custom Hive create table statement configuration validator.
Related Name
Default Value
false
API Name
role_config_suppression_sqoop_hive_create_table_statement
Required
true

Suppress Configuration Validator: Custom Hive JDBC arguments

Description
Whether to suppress configuration warnings produced by the Custom Hive JDBC arguments configuration validator.
Related Name
Default Value
false
API Name
role_config_suppression_sqoop_hive_jdbc_params
Required
true

Suppress Configuration Validator: Custom Hive table properties

Description
Whether to suppress configuration warnings produced by the Custom Hive table properties configuration validator.
Related Name
Default Value
false
API Name
role_config_suppression_sqoop_hive_table_properties
Required
true

Suppress Configuration Validator: Sqoop Tool Plugins

Description
Whether to suppress configuration warnings produced by the Sqoop Tool Plugins configuration validator.
Related Name
Default Value
false
API Name
role_config_suppression_sqoop_tool_plugins
Required
true

Suppress Configuration Validator: Gateway Count Validator

Description
Whether to suppress configuration warnings produced by the Gateway Count Validator configuration validator.
Related Name
Default Value
false
API Name
service_config_suppression_gateway_count_validator
Required
true

Suppress Parameter Validation: Parquet Writer Implementation

Description
Whether to suppress configuration warnings produced by the built-in parameter validation for the Parquet Writer Implementation parameter.
Related Name
Default Value
false
API Name
service_config_suppression_parquetjob.configurator.implementation
Required
true

Suppress Parameter Validation: SQOOP_CLIENT Service Environment Advanced Configuration Snippet (Safety Valve)

Description
Whether to suppress configuration warnings produced by the built-in parameter validation for the SQOOP_CLIENT Service Environment Advanced Configuration Snippet (Safety Valve) parameter.
Related Name
Default Value
false
API Name
service_config_suppression_sqoop_client_service_env_safety_valve
Required
true