Setting advanced connection properties
In the Advanced tab, you can specify source file delimiters and other properties. Note that the source file delimiters only need to be specified if the SerDe property names used to create the source data files are different from the Hadoop defaults.
The default Hadoop property names are as follows:
- field.delim (Field delimiter in the UI)
- serialization.null.format (Null value in the UI)
- escape.delim (Escape character in the UI)
- line.delim (Record delimiter in the UI)
- quote.delim (Quote character in the UI)
In the Advanced tab, you can set the parameters described in the following table.
| Option | Description |
|---|---|
|
Field delimiter |
The delimiter used to separate fields in the source files. |
|
Null value |
The value used to indicate a null value in the source files. Example (where @@ is the null value): mike,male,295678 sara,female,@@ |
|
Escape character |
This can either be the character used to escape the field delimiter character - if the source files were created using a SerDe that does not support quote characters (see Example 1) or the character used to escape the quote character - if the source files were created using a SerDe that supports quote characters (see Example 2). Example 1 (where \ is the escape character and a comma is the field delimiter): sunroof\,power-steering
Example 2 (where \ is the escape character and double quotes is the quote character): "\"sunroof, power-steering\"" |
|
Record delimiter |
The delimiter used to separate records (rows) in the source files. If the LazySimpleSerde SerDe was used, the record delimiter must be \n. |
|
Quote character |
The character used to escape the field delimiter character in the source files. When a field delimiter is escaped, it is interpreted as actual data, and not as a field delimiter. Example (where double-quotes is the quote character): "sunroof,power-steering" |
Internal parameters
Internal parameters are parameters that are not exposed in the UI. You should only use them if instructed by Qlik Support.
To add internal Qlik Replicate parameters:
-
Click the Internal Parameters link.
The Internal Parameters dialog box opens.
- In the edit box, type the name of the parameter you need to add and then click it.
- The parameter is added to the table below the search box with its default value.
- Change the default value as required.
- To reset the parameter value to its default, click the "Restore default value" icon at the end of the row.
More options
These options are not exposed in the UI as they are only relevant to specific versions or environments. Consequently, do not set these options unless explicitly instructed to do so by Qlik Support or product documentation.
To set an option, simply copy the option into the Add feature name field and click Add. Then set the value or enable the option according to the instructions you received.
Settings summary
You can view a summary of your settings by clicking the Setting Summary link. This is useful if you need to send a summary of your settings to Qlik Support.