Apache 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 add-in 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 add-in 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 add-in 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 add-in 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.