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 JDBC for Apache Hive User's Guide Release 6.0.1

Supported SQL Functionality and Extensions

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 JDBC for Apache Hive Driver
    • What's new in this release?
    • Requirements
    • Data source and driver classes
    • Connection URL
    • Version string information
    • Connection properties
    • Data types
      • getTypeInfo
    • DataDirect tools
    • Troubleshooting
    • Additional information
    • Contacting Technical Support
  • Getting started
    • Data source and driver classes
    • Setting the classpath
    • Connecting using the DriverManager
      • 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 data source connection
  • Using the driver
    • Connecting from an application
      • Data source and driver classes
      • Setting the classpath
      • Connecting using the DriverManager
        • 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 data source connection
      • HTTP Mode
    • Using connection properties
      • Required properties
      • User ID/password authentication properties
      • Kerberos authentication properties
      • Data encryption properties
      • Data type handling properties
      • Timeout properties
      • Client information properties
      • Statement pooling properties
      • Proxy server 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
      • Hadoop delegation token authentication
    • Proxy server support
    • Data encryption
      • Configuring SSL encryption
      • Configuring SSL server authentication
      • Configuring SSL client authentication
      • FIPS (Federal Information Processing Standard)
    • Apache Knox
    • Apache ZooKeeper
      • Configuring Apache ZooKeeper for Kerberos 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 and update statements
      • Select statements
      • Stored procedures
    • ResultSet metadata support
    • Isolation levels
    • Unicode support
    • Error handling
    • Large object support
    • Batch inserts
    • Rowset support
    • Timeouts
    • Views
    • SQL escape sequences
    • Using scrollable cursors
    • Restrictions for Apache Hive functionality
  • Connection property descriptions
    • AccountingInfo
    • ApplicationName
    • ArrayFetchSize
    • ArrayInsertSize
    • AuthenticationMethod
    • BatchMechanism
    • BinaryDescribeType
    • CatalogMode
    • ClientHostName
    • ClientUser
    • ConnectionRetryCount
    • ConnectionRetryDelay
    • ConvertNull
    • CookieName
    • CryptoProtocolVersion
    • DatabaseName
    • DelegationToken
    • EnableCookieAuthentication
    • EncryptionMethod
    • HostNameInCertificate
    • HTTPPath
    • ImpersonateUser
    • ImportStatementPool
    • InitializationString
    • InsensitiveResultSetBufferSize
    • JavaDoubleToString
    • KeyPassword
    • KeyStore
    • KeyStorePassword
    • LoginConfigName
    • LoginTimeout
    • MaxBinarySize
    • MaxPooledStatements
    • MaxStringSize
    • Password
    • PortNumber
    • ProgramID
    • ProxyHost
    • ProxyPassword
    • ProxyPort
    • ProxyUser
    • SASLQOP
    • RegisterStatementPoolMonitorMBean
    • RemoveColumnQualifiers
    • ServerName
    • ServicePrincipalName
    • SpyAttributes
    • StringDescribeType
    • TransactionMode
    • TransportMode
    • TrustStore
    • TrustStorePassword
    • UseCurrentSchema
    • User
    • ValidateServerCertificate
    • ZooKeeperDiscovery
    • ZooKeeperNamespace
  • Supported SQL Functionality and Extensions
    • Data definition language (DDL)
    • 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 restriction
      • Stored procedures
      • Views
      • Other restrictions
  • Copyright
Table of Contents

Supported SQL Functionality and Extensions

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
  • Last Updated: June 20, 2017
  • 1 minute read
    • DataDirect Connectors
    • JDBC
    • Apache Hive 6.0
    • Documentation

The Progress DataDirect for JDBC for Apache Hive 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)
  • 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