Miscellaneous
This section provides a complete list of the Miscellaneous properties you can configure in the connection settings for this provider.
| Property | Description |
| AsyncQueryTimeout | The timeout for asynchronous requests issued by the provider to download large result sets. |
| EnableXSRF | This option specifies whether to add the X-XSRF-Header filter to HiveServer2 HTTP mode. |
| FailoverHosts | This property allows you to specify a list of failover hosts in addition to the one configured in Server and Port . |
| HTTPPath | The path component of the URL endpoint when using HTTP TransportMode. |
| JGSSPrincipalAsDBUser | Whether to use the Kerberos principal as the database username. Only applies when UseJGSS is enabled. |
| MaxRows | Specifies the maximum number of rows returned for queries that do not include either aggregation or GROUP BY. |
| Other | Specifies additional hidden properties for specific use cases., to be used only when our Support team advises it, to address specific issues. See Remarks for details. |
| Pagesize | Specifies the maximum number of records per page the provider returns when requesting data from Apache Hive. |
| PseudoColumns | Specifies the pseudocolumns to expose as table columns, expressed as a string in the format 'TableName=ColumnName;TableName=ColumnName'. |
| QueryPassthrough | This option passes the query to the Apache Hive server as is. |
| Readonly | Toggles read-only access to Apache Hive from the provider. |
| RTK | Specifies the runtime key for licensing the provider. If unset or invalid, the provider defaults to the standard licensing method. This property is only required in environments where the standard licensing method is unsupported or requires a runtime key. |
| ServerConfigurations | A list of server configuration variables to override the server defaults. |
| Timeout | Specifies the maximum time, in seconds, that the provider waits for a server response before throwing a timeout error. |
| UseDescTableQuery | This option specifies whether the columns will be retrieved using a DESC TABLE query or the GetColumns Thrift API. |
| UseJGSS | Specify whether to use native Java Kerberos Authentication (JGSS) for Kerberos Authentication. |
| UserDefinedViews | Specifies a filepath to a JSON configuration file that defines custom views. The provider automatically detects and uses the views specified in this file. |
| UseShowDatabasesQuery | This option specifies whether the schemas will be retrieved using a SHOW DATABASES query or the GetSchemas Thrift API. |
| UseShowTablesQuery | This option specifies whether the tables will be retrieved using a SHOW TABLES query or the GetTables Thrift API. |
| UseSSL | Specifies whether to use SSL Encryption when connecting to Hive. |
| UseZookeeperDiscovery | Specifies whether to use ZooKeeper Service Discovery. |
| ZookeeperNamespace | The namespace configured on ZooKeeper for the Hive Server 2 znodes. |