Hive supports multiple ways to perform similar operations. The options below allow you to configure which HiveQL statement is issued to perform an operation.

• UseShowDatabasesQuery: When this property is set to true, the adapter will issue a "SHOW DATABASES" query (instead of using the Thrift API) to retrieve the available schemas.
• UseShowTablesQuery: When this property is set to true, the adapter will issue a "SHOW TABLES" query (instead of using the Thrift API) to retrieve the available tables.
• UseInsertSelectSyntax: This option is specified via the Other property.

  When set to true, the adapter will perform INSERT queries using the INSERT INTO SELECT syntax: INSERT INTO TABLE [table] SELECT T.* FROM (....) AS T.

  If set to false (default), the INSERT INTO VALUES syntax will be used: INSERT INTO TABLE [table] VALUES (....).

  The adapter will automatically determine which syntax is supported by your Hive server but setting this option to true will force the INSERT INTO SELECT syntax to be used.