Enable quoted identifiers property

To configure the connector to enclose in quotation marks the object names in the generated SQL statements, set the Enable quoted identifiers property to Yes.

Usage

When the connector is configured to automatically generate SQL statements, it can be configured to enclose the column, schema, and table object names in the statements with the quotation marks that are supported by the driver. Enclosing the object names in quotation marks in the statements might be required to preserve the case or to allow the use of spaces or special characters in names.

The connector queries the driver to determine the quotation mark that is used by the Hive data source. If the connector fails to obtain this information, it uses a backtick ( ` ) character as the quotation mark by default.

Although Hive supports different special characters when the quoted identifiers are used, the connector cannot support all of them because of the column names, because of the limitation associated with naming of the column names, or because of the supported characters used in column names. The connector is restricted by the column naming convention in the InfoSphere Information Server.

Also, object names in the Hive are case insensitive irrespective of whether the quoted identifier support is enabled or not.

For more information on the support for quoted identifiers in Hive and also to understand how to enable the quoted identifiers in Hive, see the Hive documentation.

Example

Assume that Hive is using a back-tick character (`) as the quotation mark. Hive by default converts all the column names and table names to lower case. Special characters in column names are not accepted without quoted identifiers. The following table shows examples of the SELECT statement that is generated for combinations of column names, and table names and Enable quoted identifiers property values
Table 1. Values of the SELECT statement generated for the combinations of the column names, table names, and enable quoted identifiers property values
Input link columns Table name Value that is set for the Enable quoted identifiers property Generated statement
c1,c2 t1 No select c1,c2 from t1
C1µ,c2 t1 Yes select C1µ from t1
c1,c2 s1.t1 No select c1,c2 from s1.t1
c1£t ,c2 s1.t1 Yes select `c1£t`, `c2` from `s1`.`t1`
.