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 Cassandra User's Guide 6.0.0 Release

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 for JDBC for Apache Cassandra Driver
    • What's New in this Release?
    • Requirements
    • Driver and Data Source Classes
    • Version String Information
    • Connection Properties
    • Complex Type Normalization
      • Collection Types
      • Tuple and User-Defined Types
      • Nested Complex Types
    • Data Types
      • getTypeInfo()
    • SQL escape sequences
    • DataDirect tools
    • Troubleshooting
    • Additional information
    • Contacting Technical Support
  • Getting started
    • Driver and Data Source Classes
    • Connecting Using the DriverManager
      • Setting the Classpath
      • Passing the Connection URL
      • Testing the Connection
    • Connecting using data sources
      • How Data Sources Are Implemented
      • Creating data sources
      • Calling a data source in an application
  • Using the Driver
    • Connecting from an application
      • Driver and Data Source Classes
      • Connecting Using the DriverManager
        • Setting the Classpath
        • Passing the Connection URL
        • Testing the Connection
      • Connecting using data sources
        • How Data Sources Are Implemented
        • Creating data sources
        • Calling a data source in an application
      • Interactive SQL for JDBC (JDBCISQL)
    • Using Connection Properties
      • Required Properties
      • Mapping Properties
      • Authentication Properties
      • Data Encryption Properties
      • Statement Pooling Properties
      • Additional Properties
      • Proxy Server Properties
    • Performance Considerations
    • Authentication
      • Configuring User ID/Password Authentication
      • Configuring the Driver for Kerberos Authentication
        • Kerberos Authentication Requirements
        • The JAAS Login Configuration File
        • The krb5.conf File
        • Specifying User Credentials for Kerberos Authentication (Delegation of Credentials)
        • Obtaining a Kerberos Ticket Granting Ticket
    • Proxy server support
    • Data Encryption
      • Configuring SSL Encryption
      • Configuring SSL Server Authentication
      • Configuring SSL Client Authentication
      • FIPS (Federal Information Processing Standard)
    • Identifiers
    • IP Addresses
    • Parameter Metadata Support
      • Insert and Update Statements
      • Select Statements
    • Isolation Levels
    • Unicode support
    • Error Handling
    • Large Object (LOB) Support
    • Rowset Support
    • Executing CQL
  • Connection Property Descriptions
    • AuthenticationMethod
    • ClusterNodes
    • ConfigOptions
      • SchemaFormat (configuration option)
    • CreateMap
    • EncryptionMethod
    • FetchSize
    • HostNameInCertificate
    • ImportStatementPool
    • InitializationString
    • InsensitiveResultSetBufferSize
    • KeyPassword
    • KeyspaceName
    • KeyStore
    • KeyStorePassword
    • LogConfigFile
    • LoginConfigName
    • LoginTimeout
    • MaxPooledStatements
    • NativeFetchSize
    • Password
    • PortNumber
    • ProxyHost
    • ProxyPassword
    • ProxyPort
    • ProxyUser
    • ReadConsistency
    • ReadOnly
    • RegisterStatementPoolMonitorMBean
    • ResultMemorySize
    • SchemaMap
    • SecureConnectBundle
    • ServerName
    • ServicePrincipalName
    • SpyAttributes
    • TransactionMode
    • TrustStore
    • TrustStorePassword
    • User
    • ValidateServerCertificate
    • WriteConsistency
  • Supported SQL Functionality
    • Data Definition Language (DDL)
      • Native and Refresh Escape Sequences
    • Delete
    • Insert
    • Refresh Map (EXT)
    • Select
      • Select Clause
        • Aggregate Functions
        • From Clause
          • Outer Join Escape Sequences
          • Join in a From Clause
          • Subquery in a From Clause
        • Where Clause
        • Group By Clause
        • Having Clause
        • Union Operator
        • Intersect Operator
        • Except and Minus Operators
        • Order By Clause
        • Limit Clause
    • Update
    • SQL Expressions
      • Column Names
      • Literals
        • Character String Literals
        • Numeric Literals
        • Binary Literals
        • Date/Time Literals
        • Integer Literals
      • Operators
        • Unary Operator
        • Binary Operator
        • Arithmetic Operators
        • Concatenation Operator
        • Comparison Operators
        • Logical Operators
        • Operator Precedence
      • Functions
      • Conditions
    • Subqueries
      • IN Predicate
      • EXISTS Predicate
      • UNIQUE Predicate
      • Correlated Subqueries
  • 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: August 10, 2016
  • 1 minute read
    • DataDirect Connectors
    • JDBC
    • Apache Cassandra 6.0
    • Documentation

The driver provides support for SQL statements and extensions described in this section. SQL extensions are denoted by an (EXT) in the topic title.

Contents
  • Data Definition Language (DDL)
  • Delete
  • Insert
  • Refresh Map (EXT)
  • Select
  • Update
  • SQL Expressions
  • Subqueries
TitleResults for “How to create a CRG?”Also Available inAlert