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

Teradata® Package for R User Guide

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Teradata Package for R
Release Number
17.20
Published
March 2024
Language
English (United States)
Last Update
2024-04-09
dita:mapPath
efv1707506846369.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
nqx1518630623256
Product Category
Teradata Vantage
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)