td.column.casesensitive.handler | Configuration Options | Teradata R Package - 16.20 - tdplyr Configuration Options - Teradata R Package

Teradata® R Package User Guide

Product
Teradata R Package
Release Number
16.20
Published
February 2020
Language
English (United States)
Last Update
2022-05-02
dita:mapPath
qbt1519078127352.ditamap
dita:ditavalPath
Generic_no_ie_no_tempfilter.ditaval

td.column.casesensitive.handler

The td.column.casesensitive.handler is a boolean configuration property that controls whether to treat the column names passed to analytical function arguments as 'Case Sensitive' or 'Case Insensitive'.
  • When the property is set to FALSE (default), column names passed to analytical function wrappers are treated as 'Case Insensitive'.
  • When the property is set to TRUE, column names are treated as 'Case Sensitive'.

When using tdplyr with Vantage 1.1 or later, if the QueryGrid ML Engine connector Column Name Handling property is set to CASE-SENSITIVE, you must set the td.column.casesensitive.handler property to TRUE.

Make sure the value of the td.column.casesensitive.handler configuration property match the value of the Column Name Handling property of the QueryGrid ML Engine connector. So that column case sensitivity errors are not observed while running analytical functions.

For detailed information about QueryGrid ML Engine connector property, see the section "ML Engine Connector Properties" in Teradata Vantage™ User Guide, B700-4002.

When using tdplyr with Vantage 1.0 Maintenance Update 2 or previous versions, you should set the td.column.casesensitive.handler property to TRUE, using the following command from R console, R Studio or Jupyter notebook.
options('td.column.casesensitive.handler'= TRUE)