CData Python Connector for Apache Hive

Build 22.0.8479

HiveQL ステートメント

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 本製品 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 本製品 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 本製品 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 本製品 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) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479