Skip to main contentSkip to search
Powered by Zoomin Software. For more details please contactZoomin
Progress DocumentationProgress Documentation
Progress Documentation
  • Home
  • Home
  • EnglishČeštinaDeutsch (Germany)Español (Spain)Français (France)Italiano (Italy)Português (Brasil)日本語Русский (Russia)中文 (简体) (China)中文 (繁體, 台灣) (Taiwan)ar-AR
  • Login

Progress DataDirect for ODBC for Apache Hive Wire Protocol Driver User's Guide Release 8.0.1

SQL functionality

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
Table of Contents
  • Welcome to the Progress DataDirect for ODBC for Apache Hive Wire Protocol Driver
    • What's new in this release?
    • Driver requirements
    • ODBC compliance
    • Version string information
      • getFileVersionString function
    • Data types
      • Retrieving data type information
    • SQL support
    • Additional information
    • Troubleshooting
    • Contacting Technical Support
  • Getting started
    • Configuring and connecting on Windows
      • Configuring a data source
      • Testing the connection
    • Configuring and connecting on UNIX and Linux
      • Environment configuration
      • Test loading the driver
      • Configuring a data source in the system information file
      • Testing the connection
  • Tutorials
    • The Example application
    • Accessing data in Power BI (Windows only)
    • Accessing data in Tableau (Windows only)
    • Accessing data in Microsoft Excel (Windows only)
    • Accessing data in Microsoft Excel from the Query Wizard (Windows only)
  • Using the driver
    • Configuring and connecting to data sources
      • Configuring the product on UNIX/Linux
        • Environment variables
          • Library search path
          • ODBCINI
          • ODBCINST
          • DD_INSTALLDIR
        • The test loading tool
        • Data source configuration on UNIX/Linux
          • Configuration through the system information (odbc.ini) file
            • Sample default odbc.ini file
        • DSN-less connections
          • Sample odbcinst.ini file
        • File data sources
        • UTF-16 applications on UNIX and Linux
      • Data source configuration through a GUI
        • Advanced tab
        • Security tab
      • Using a connection string
      • Password Encryption Tool (UNIX/Linux only)
      • Using a logon dialog box
      • HTTP mode
    • Performance considerations
    • Using security
      • Authentication
        • Kerberos authentication
          • Apache Sentry
        • Summary of authentication-related options
          • Connection string examples for configuring authentication
          • odbc.ini file examples for configuring authentication
      • Data encryption across the network
      • TLS/SSL encryption
        • Certificates
        • TLS/SSL server authentication
          • Using SQL_COPT_INMEMORY_TRUSTSTORECERT
          • Importing root certificates into the Windows certificate store
            • Importing root certificates using Certificate Import Wizard
            • Importing root certificates using a PowerShell script
        • TLS/SSL client authentication
        • Generating TLS/SSL certificates using OpenSSL 3.5-compliant algorithms
        • Designating an OpenSSL library
    • Apache Knox
    • Apache ZooKeeper
      • Configuring Apache ZooKeeper for Kerberos authentication
    • Isolation and lock levels supported
    • Unicode support
    • Binding parameter markers
    • Using arrays of parameters
    • Limitations on Apache Hive functionality
    • Materialized views
    • Stored procedures
    • Packet logging
  • Connection option descriptions
    • Array Size
    • Array Fetch Size
    • Array Insert Size
    • Authentication Method
    • Batch Mechanism
    • Catalog Mode
    • Cookie Name
    • Crypto Protocol Version
    • CryptoLibName
    • Data Source Name
    • Database Name
    • Default Buffer Size for Long/LOB Columns (in Kb)
    • Description
    • Enable Cookie Authentication
    • Enable FIPS
    • Enable SQLDescribeParam
    • Encryption Method
    • GSS Client Library
    • Host Name
    • Host Name In Certificate
    • HTTP Path
    • IANAAppCodePage
    • Key Password
    • Keystore
    • Keystore Password
    • Login Timeout
    • Max String Size
    • Min Long Varchar Size
    • OpenSSLConfigFile
    • OpenSSLProviderPath
    • Password
    • Port Number
    • Proxy User
    • Remove Column Qualifiers
    • Service Principal Name
    • SSLLibName
    • String Describe Type
    • TCP Keep Alive
    • Transaction Mode
    • Transport Mode
    • Truststore
    • Truststore Password
    • Use Current Schema for Catalog Functions
    • Use Native Catalog Functions
    • Use Unicode Char Types
    • User Name
    • Validate Server Certificate
    • Varchar Threshold
    • Zookeeper Namespace
    • Zookeeper Discovery
  • SQL functionality
    • Data Definition Language (DDL)
    • Selecting Data With the Driver
      • Select List
        • Column Name Qualification
    • From Clause
    • Group By Clause
    • Having Clause
    • Order By Clause
    • For Update Clause
    • Set Operators
    • Subqueries
    • SQL Expressions
      • Constants
      • Numeric Operators
      • Character Operator
      • Relational operators
      • Logical Operators
      • Functions
    • Restrictions
      • Merge Restrictions
      • Stored Procedures
      • Views
      • Other Restrictions
  • Copyright
Table of Contents

SQL functionality

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
  • Last Updated: October 23, 2020
  • 1 minute read
    • DataDirect Connectors
    • ODBC
    • Apache Hive 8.0
    • Documentation

The driver supports an extended set of SQL 92 in addition to the syntax for Apache HiveQL, which is a subset of SQL 92.

Refer to the Hive Language Manual for information about using HiveQL.

Contents
  • Data Definition Language (DDL)
  • Selecting Data With the Driver
  • From Clause
  • Group By Clause
  • Having Clause
  • Order By Clause
  • For Update Clause
  • Set Operators
  • Subqueries
  • SQL Expressions
  • Restrictions
TitleResults for “How to create a CRG?”Also Available inAlert