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)