skip to main content
DataDirect Connect XE Drivers : The Driver for Apache Hive : Connection Properties : RemoveColumnQualifiers
  
RemoveColumnQualifiers
Purpose
Specifies whether the driver removes 3-part column qualifiers and replaces them with alias.column qualifiers. Microsoft Access executes a Select statement using this syntax when an index is specified on a linked table.
Valid Values
true | false
Behavior
If set to true (enabled), the driver removes 3-part column qualifiers and replaces them with alias.column qualifiers. Column qualifiers are Microsoft Access compatible in this setting.
If set to false, the driver does not modify the request.
Notes
*When using the driver with Microsoft Access in creating a linked table, it is highly recommended that you do not specify an index. Specifying an index causes Access to execute a Select statement for each row, which results in very slow performance.
Default
false (Disabled)
Data Type
boolean
See also
Performance Considerations