Skip to main content

Setting advanced connection properties

ON THIS PAGE

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.

Advanced tab options
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:

  1. Click the Internal Parameters link.

    The Internal Parameters dialog box opens.

  2. In the edit box, type the name of the parameter you need to add and then click it.
  3. The parameter is added to the table below the search box with its default value.
  4. Change the default value as required.
  5. To reset the parameter value to its default, click the "Restore default value" icon at the end of the row.

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.