ADO.NET Provider for Apache Hive

Build 21.0.7930

HiveQL Statements

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 provider 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 provider 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 provider 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 provider 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.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930