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 issues 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 issues 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 performs INSERT queries using the INSERT INTO SELECT syntax:
  

  INSERT INTO TABLE [table] SELECT T.* FROM (....) AS T.

  When set to false (default), the add-in uses the INSERT INTO VALUES syntax:
  

  INSERT INTO TABLE [table] VALUES (....).

  The add-in automatically determines which syntax your Hive server supports, but setting this option to true forces the INSERT INTO SELECT syntax.

Checking Table Partitioning

EXPLAIN EXTENDED SELECT * FROM tableName;

If the table is partitioned, the output contains entries similar to:

partition_columns        columnName
partition_columns.types  columnType

If no partition columns are listed, the table is not partitioned.

Note: You can execute this query directly on the Apache Hive side using HiveQL or Beeline, or through the add-in by enabling QueryPassthrough.