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
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` |