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 Connect XE for JDBC for Impala User's Guide Release 5.1.4

Supported 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 Connect XE for JDBC for Impala Driver
    • What's New in this Release?
    • Requirements
    • Data Source and Driver Classes
    • Connection URL
    • Connection Properties
    • Version String Information
    • Data Types
      • getTypeInfo
    • DataDirect tools
    • Troubleshooting
    • Additional information
    • Contacting Technical Support
  • Getting started
    • Data Source and Driver Classes
    • Setting the Classpath
    • Connecting Using the Driver Manager
      • Passing the Connection URL
      • Testing the Connection
    • Connecting Using Data Sources
      • How Data Sources Are Implemented
      • Creating Data Sources
        • Example Data Source
      • Calling a Data Source in an Application
      • Testing a DataSource Connection
  • Using the driver
    • Required permissions for Java SE with the standard Security Manager enabled
      • Permissions for establishing connections
      • Granting access to Java properties
      • Granting access to temporary files
    • Connecting from an Application
      • Connecting Using the JDBC Driver Manager
        • Passing the Connection URL
        • Testing the Connection
      • Connecting Using Data Sources
        • How Data Sources Are Implemented
        • Creating Data Sources
          • Example Data Source
        • Calling a Data Source in an Application
        • Testing a DataSource Connection
    • Using Connection Properties
      • UserID/Password Authentication Properties
      • Kerberos Authentication Properties
      • Data Encryption Properties
      • Data Type Handling Properties
      • Client Information Properties
      • Statement Pooling Properties
      • Additional Properties
    • Performance Considerations
    • Authentication
      • Configuring user ID/password authentication
      • Configuring the driver for Kerberos authentication
        • Kerberos authentication requirements
        • The JAAS login configuration file
        • Kerberos SASL-QOP
    • Data Encryption
      • Configuring SSL Encryption
      • Configuring SSL Server Authentication
      • Configuring SSL Client Authentication
    • Client Information
      • How Databases Store Client Information
        • Storing Client Information
      • Returning Client Information
      • Returning MetaData About Client Information Locations
    • IP Addresses
    • Parameter Metadata Support
      • Insert, Update, and Delete Statements
      • Select Statements
      • SQL Support
    • ResultSet Metadata Support
    • Isolation Levels
    • Unicode support
    • Error Handling
    • Large Object Support
    • Rowset Support
    • Timeouts
    • Using Scrollable Cursors
    • Limitations on Cloudera Impala Functionality
  • Connection Property Descriptions
    • AccountingInfo
    • ApplicationName
    • AuthenticationMethod
    • ClientHostName
    • ClientUser
    • ConnectionRetryCount
    • ConnectionRetryDelay
    • ConvertNull
    • CryptoProtocolVersion
    • DatabaseName
    • DefaultOrderByLimit
    • EncryptionMethod
    • HostNameInCertificate
    • ImportStatementPool
    • InitializationString
    • InsensitiveResultSetBufferSize
    • JavaDoubleToString
    • KeyPassword
    • KeyStore
    • KeyStorePassword
    • LoginConfigName
    • LoginTimeout
    • MaxPooledStatements
    • Password
    • PortNumber
    • ProgramID
    • RegisterStatementPoolMonitorMBean
    • RemoveColumnQualifiers
    • ServerName
    • ServicePrincipalName
    • SpyAttributes
    • StringDescribeType
    • TransactionMode
    • TrustStore
    • TrustStorePassword
    • UseCurrentSchema
    • User
    • ValidateServerCertificate
  • Supported SQL Functionality
    • Data Definition Language
    • 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
  • Copyright
Table of Contents

Supported SQL Functionality

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
  • Last Updated: May 13, 2025
  • 1 minute read
    • DataDirect Connectors
    • JDBC
    • Cloudera Impala 5.1
    • Documentation

The Progress DataDirect Connect XE for JDBC for Impala driver supports an extended set of SQL-92, in addition to the syntax for Impala SQL, which is a subset of SQL-92 and HiveQL.

Refer to the Impala SQL Language Reference documentation for information about using Impala SQL.

Contents
  • Data Definition Language
  • Column Name Qualification
  • 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