•  Welcome to the Progress DataDirect for ODBC for Apache Hive Wire Protocol Driver
  • What's New in this Release?
  • Conventions Used in This Guide
  • About the Product Documentation
  • 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
  • Accessing Data With Third-Party Applications
•  What Is ODBC?
  • How Does It Work?
  • Why Do Application Developers Need ODBC?
•  About the Apache Hive Driver
  • Driver Requirements
  •  Support for Multiple Environments
    •  Support for Windows Environments
      • 32-Bit Driver Requirements
      • 64-Bit Driver Requirements
      • Setup of the Driver
      • Driver File Names for Windows
    •  Support for UNIX and Linux Environments
      • 32-Bit Driver Requirements
      • 64-Bit Driver Requirements
      • AIX
      • HP-UX 11 aCC
      • Linux
      • Oracle Solaris
      • Setup of the Environment and the Drivers
      • Driver File Names for UNIX/Linux
  • ODBC Compliance
  •  Version String Information
    • getFileVersionString Function
  •  Data Types
    • Retrieving Data Type Information
  • Isolation and Lock Levels Supported
  • Binding Parameter Markers
  • Limitations on Apache Hive Functionality
•  Supported Features
  • Unicode Support
  • Using IP Addresses
  • Materialized Views
  • Stored Procedures
  • SQL Support
  • Number of Connections and Statements Supported
  • Using Arrays of Parameters
•  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
      • The Example Application
      •  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
    • 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
    •  SSL Encryption
      • Certificates
      • SSL Server Authentication
      • SSL Client Authentication
      • Designating an OpenSSL Library
      •  Summary of Data Encryption Related Options
        • Connection String Examples for Configuring Data Encryption
        • odbc.ini File Examples for Configuring Data Encryption
  • Apache Knox
  •  Apache ZooKeeper
    • Configuring Apache ZooKeeper for Kerberos authentication
•  Troubleshooting
  •  Diagnostic Tools
    •  ODBC Trace
      • Creating a Trace Log
      •  Enabling Tracing
        • Windows ODBC Administrator
        • System Information (odbc.ini) File
    • The Test Loading Tool
    • ODBC Test
    • The Example Application
    • Other Tools
  • Error Messages
  •  Troubleshooting
    •  Setup/Connection Issues
      • Troubleshooting the Issue
    •  Interoperability Issues
      • Troubleshooting the Issue
    • Performance Issues
•  Connection Option Descriptions
  • AllowedOpenSSLVersions
  • 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 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
  • Max Varchar Size
  • Min Long Varchar Size
  • 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
  • User Name
  • Validate Server Certificate
  • Varchar Threshold
  • Zookeeper Namespace
  • Zookeeper Discovery
•  SQL Functionality for the Driver for Apache Hive
  • 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
•  Reference
  •  Code Page Values
    • IANAAppCodePage Values
  •  ODBC API and Scalar Functions
    • API Functions
    •  Scalar Functions
      • String Functions
      • Numeric Functions
      • Date and Time Functions
      • System Functions
  •  Internationalization, Localization, and Unicode
    •  Internationalization and Localization
      • Locale
      • Language
      • Country
      • Variant
    •  Unicode Character Encoding
      • Background
      • Unicode Support in Databases
      • Unicode Support in ODBC
    •  Unicode and Non-Unicode ODBC Drivers
      •  Function Calls
        • Unicode Application with a Non-Unicode Driver
        • Unicode Application with a Unicode Driver
      •  Data
        • Unicode Driver
        • ANSI Driver
      •  Default Unicode Mapping
        • Connection Attribute for Unicode
    •  Driver Manager and Unicode Encoding on UNIX/Linux
      • References
    • Character Encoding in the odbc.ini and odbcinst.ini Files
  •  Designing ODBC Applications for Performance Optimization
    •  Using Catalog Functions
      • Caching Information to Minimize the Use of Catalog Functions
      • Avoiding Search Patterns
      • Using a Dummy Query to Determine Table Characteristics
    •  Retrieving Data
      • Retrieving Long Data
      • Reducing the Size of Data Retrieved
      • Using Bound Columns
      • Using SQLExtendedFetch Instead of SQLFetch
      • Choosing the Right Data Type
    •  Selecting ODBC Functions
      • Using SQLPrepare/SQLExecute and SQLExecDirect
      • Using Arrays of Parameters
      • Using the Cursor Library
    •  Managing Connections and Updates
      • Managing Connections
      • Managing Commits in Transactions
      • Choosing the Right Transaction Model
      • Using Positioned Updates and Deletes
      • Using SQLSpecialColumns
  •  Using Indexes
    • Introduction
    • Improving Row Selection Performance
    • Indexing Multiple Fields
    • Deciding Which Indexes to Create
    • Improving Join Performance
  •  Locking and Isolation Levels
    • Locking
    • Isolation Levels
    • Locking Modes and Levels
  • SSL Encryption Cipher Suites
  • WorkAround Options
  • Threading
•  Glossary
  • application
  • authentication
  • bulk load
  • client load balancing
  • conformance
  • connection pooling
  • connection retry
  • connection string
  • data source
  • driver
  • Driver Manager
  • DSN (Data Source Name)
  • DTC (Distributed Transaction Coordinator)
  • failover
  • index
  • isolation level
  • Kerberos
  • load balancing
  • locking level
  • MTS (Microsoft Transaction Server)
  • NTLM
  • ODBC Administrator
  • OS authentication
  • Performance Tuning Wizard
  • reauthentication
  • SQL Grammar
  • Secure Sockets Layer (SSL)
  • SSL client/server authentication
  • Unicode
  • user ID/password authentication
• Copyright