td.column.casesensitive.handler | Teradata R Package - 17.00 - td.column.casesensitive.handler - Teradata R Package

Teradata® R Package User Guide

prodname
Teradata R Package
vrm_release
17.00
created_date
November 2020
category
User Guide
featnum
B700-4005-090K
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)