Logo

Contents:

  • Getting Started
    • Preparing Your Machine to Install SQreamDB
    • Installing SQreamDB
    • Executing Statements in SQreamDB
    • Performing Basic SQream Operations
      • Running the SQream SQL Client
      • Creating Your First Table
      • Listing Tables
      • Inserting Rows
      • Running Queries
      • Deleting Rows
      • Saving Query Results to a CSV or PSV File
    • Hardware Guide
    • Staging and Development Hardware Guide
  • Installation Guides
    • Installing and Launching SQreamDB
      • Pre-Installation Configuration
      • Installing SQream Using Binary Packages
      • Installing Monit
      • Launching SQream with Monit
    • Installing SQream Studio
      • Installing Studio on a Stand-Alone Server
      • Installing an NGINX Proxy Over a Secure Connection
    • Upgrade Guides
      • Version Upgrade
      • Upgrade-Related Configuration Changes
  • SQreamDB on AWS
  • Operational Guides
    • Access Control
      • Overview
      • Password Policy
      • Managing Roles
      • Permissions
      • Departmental Example
    • Creating or Cloning Storage Clusters
    • Working with External Data
    • Foreign Tables
    • Health Monitoring
    • Deleting Data
    • Logging
    • Query Split
    • Monitoring Query Performance
    • Security
    • Saved Queries
    • Optimization and Best Practices
    • Oracle Migration Guide
  • Configuration Guides
    • Configuring SQream
      • Cluster and Session
      • Workers
      • Modification Methods
      • Parameter Values
      • Showing All Flags in the Catalog Table
    • LDAP
    • Single Sign-On
  • Architecture
    • Internals and Architecture
    • Filesystem and Usage
    • Sizing
  • Acceleration Studio
    • Getting Started with SQream Acceleration Studio
    • Executing Statements and Running Queries from the Editor
    • Viewing Logs
    • Creating, Assigning, and Managing Roles and Permissions
    • Configuring Your Instance of SQreams
  • Connecting to SQreamDB
    • Client Platforms
      • Denodo Platform
      • Informatica Cloud Services
      • MicroStrategy
      • Pentaho Data Integration
      • PHP
      • BI Desktop
      • R
      • SAP BusinessObjects
      • SAS Viya
      • Semarchy
      • SQL Workbench
      • Tableau
      • Talend
      • TIBCO Spotfire
    • Client Drivers
      • SQreamNET
      • Dataiku
      • JDBC
      • Node.JS
      • ODBC
        • Install and Configure ODBC on Windows
        • Install and configure ODBC on Linux
      • Python (pysqream)
      • Spark
      • Trino
  • Data Ingestion Sources
    • Overview
    • Avro
    • CSV
    • Parquet
    • ORC
    • JSON
    • SQLoader As a Service
      • Preparing Oracle for Data Migration
  • External Storage Platforms
    • Azure Blob Storage
    • Google Cloud Platform
    • HDFS Environment
    • Amazon Web Services
  • Feature Guides
    • Query Healer
    • Compression
    • Python User-Defined Functions
    • Workload Manager
    • Concurrency and Locks
    • Data Encryption
      • Overview
      • Encryption Methods
      • Data Types
      • Syntax
      • Examples
      • Limitations
      • Permissions
  • References
    • SQL Statements and Syntax
      • SQL Syntax Features
      • SQL Statements
      • SQL Functions
        • Built-In Scalar Functions
        • User-Defined Functions
        • Aggregate Functions
        • Window Functions
    • Catalog Reference
      • Catalog Tables
      • Additional Tables
      • Examples
    • Command line programs
      • metadata_server
      • sqreamd
      • Multi-Platform Sqream SQL
      • SqreamDB Console
      • Server Picker
      • SqreamStorage
      • sqream sql
      • upgrade_storage
    • SQL Feature Checklist
  • Data Types
    • Supported Data Types
      • Primitive Data Types
      • Array
    • Casts and Conversions
    • Supported Casts
      • Numeric
      • Boolean
      • Integer
      • Floating Point
      • String
      • Date
      • DateTime2
  • Release Notes
    • SQDB release policy
    • 4.x Release Notes
      • Release Notes 4.3
      • Release Notes 4.5
      • Release Notes 4.8
      • Release Notes 4.9
      • Release Notes 4.10
      • Release Notes 4.11
  • Troubleshooting
    • Remedying Slow Queries
    • Resolving Common Issues
    • Identifying Configuration Issues
    • Lock Related Issues
    • Log Related Issues
    • Core Dumping Related Issues
    • Retrieving Execution Plan Output Using SQreamDB Studio
    • Gathering Information for SQream Support
  • Glossary
SQreamDB
  • Installation Guides
  • Upgrade Guides
  • Upgrade-Related Configuration Changes

Upgrade-Related Configuration Changes

SQreamDB Version

Storage Version

Configurations and Changes

4.4

49

New Releases:
  • Pysqream 5.0.0 Connector is released

  • JDBC 5.0.0 Connector is released

4.3

49

Configuration:
  • Two new AWS S3 object access style and endpoint URL with Virtual Private Cloud (VPC) configuration flags: AwsEndpointOverride, AwsObjectAccessStyle

  • REHL 8.x is now officially supported

4.2

46

New Releases:
  • Pysqream 3.2.5 Connector is released

  • ODBC 4.4.4 Connector is released

  • JDBC 4.5.8 Connector is released

  • Apache Spark 5.0.0 Connector is released

  • The INT96 data type is deprecated

Configuration:

  • Access control permissions in SQreamDB have been expanded. Learn how to reconfigure access control permissions when upgrading from version 4.2

4.1

45

New Releases:
  • JDBC 4.5.7 Connector

  • SQream Studio v5.5.4

4.0

45

None

2022.1.7

43

None

2022.1.6

42

None

2022.1.5

42

None

2022.1.4

42

None

2022.1.3

42

The VARCHAR data type has been deprecated and replaced with TEXT.

2022.1.2

41

None

2022.1.1

40

  • In compliance with GDPR standards, version 2022.1.1 requires a strong password policy when accessing the CLI and Studio. For more information, see Password Policy.

  • The login_max_retries configuration flag is required for adjusting the permitted log-in attempts. For more information, see Adjusting the Permitted Log-In Attempts.

2022.1

40

  • In SQream version 2022.1 the VARCHAR data type has been deprecated and replaced with TEXT. SQream will maintain VARCHAR in all previous versions until completing the migration to TEXT, at which point it will be deprecated in all earlier versions. SQream also provides an automated and secure tool to facilitate and simplify migration from VARCHAR to TEXT.

  • If you are using an earlier version of SQreamDB, see the Using Legacy String Literals configuration flag.

Previous Next

© Copyright 2025 SQreamDB.