Use Native Query

Key Name	Default Value	Required
`UseNativeQuery`	Clear (`0`)`0`	No

Description

This option specifies whether the connector uses native HiveQL queries, or converts the queries emitted by an application into an equivalent form in HiveQL. If the application is Spark-aware and already emits HiveQL, then enable this option to avoid the extra overhead of query transformation.

Enabled (1)1: The connector does not transform the queries emitted by an application, and executes HiveQL queries directly.
Disabled (0)0: The connector transforms the queries emitted by an application and converts them into an equivalent form in HiveQL.
Auto (2)2: The connector automatically sets the configuration to either 0 or 1 depending on the server's capability.

Important:

When this option is enabled, the connector cannot execute parameterized queries.

SQL Connector for HiveQL
Advanced Driver Configuration Options on page 1
Configuring Advanced Options
Creating a Data Source Name
Configuring a DSN-less Connection
Using a Connection String