Logo
4.4

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 Prometheus Exporter
      • Installing Prometheus Using Binary Packages
      • Installing the Dashboard Data Collector
      • Installing Studio on a Stand-Alone Server
      • Installing an NGINX Proxy Over a Secure Connection
  • Data Ingestion Sources
    • Overview
    • Avro
    • CSV
    • Parquet
    • ORC
    • JSON
    • External Databases
  • Connecting to SQreamDB
    • Client Platforms
      • Denodo Platform
      • Informatica Cloud Services
      • MicroStrategy
      • Pentaho Data Integration
      • BI Desktop
      • R
      • SAP BusinessObjects
      • SAS Viya
      • SQL Workbench
      • Tableau
      • Talend
      • TIBCO Spotfire
    • Client Drivers
      • JDBC
      • Python (pysqream)
      • Node.JS
      • ODBC
        • Install and Configure ODBC on Windows
        • Install and configure ODBC on Linux
      • .NET
  • External Storage Platforms
    • Azure
    • Google Cloud Platform
    • HDFS Environment
    • Amazon Web Services
  • Feature Guides
    • Automatic Foreign Table DDL Resolution
    • Query Healer
    • Compression
    • Python User-Defined Functions
    • Workload Manager
    • Concurrency and Locks
  • Operational Guides
    • Access Control
      • Overview
      • Password Policy
      • Managing Roles
      • Permissions
      • Departmental Example
    • Creating or Cloning Storage Clusters
    • Working with External Data
    • Foreign Tables
    • Deleting Data
    • Logging
    • Monitoring Query Performance
    • Security
    • Saved Queries
    • Optimization and Best Practices
  • SQream Acceleration Studio 5.7.0
    • Getting Started with SQream Acceleration Studio 5.7.0
    • Monitoring Workers and Services from the Dashboard
    • Executing Statements and Running Queries from the Editor
    • Viewing Logs
    • Creating, Assigning, and Managing Roles and Permissions
    • Configuring Your Instance of SQreams
  • Architecture
    • Internals and Architecture
    • Filesystem and Usage
    • Sizing
  • Configuration Guides
    • Configuring SQream
      • Cluster and Session
      • Workers
      • Modification Methods
      • Parameter Values
      • Showing All Flags in the Catalog Table
    • Configuring LDAP authentication
  • 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 Guide
      • Overview
      • What Information Does the Schema Contain?
      • Catalog Tables
      • Additional Tables
      • Examples
    • Command line programs
      • metadata_server
      • sqreamd
      • 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
  • Release Notes
    • 4.0 Release Notes
      • Release Notes 4.0
      • Release Notes 4.1
      • Release Notes 4.2
      • Release Notes 4.3
      • Release Notes 4.4
    • Release Notes 2022.1
      • Release Notes 2022.1.7
      • Release Notes 2022.1.6
      • Release Notes 2022.1.5
      • Release Notes 2022.1.4
      • Release Notes 2022.1.3
      • Release Notes 2022.1.2
      • Release Notes 2022.1.1
      • Release Notes 2022.1
  • 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
SQream DB
  • Release Notes

Release Notes

Version 4.4 - September 28, 2023

  • Enhancing storage efficiency and performance with the newly supported ARRAY data type

  • New integration with Denodo Platform

Version 4.3 - June 11, 2023

  • Access Control Permission Expansion

  • New AWS S3 Access Configurations

Version 4.2 - April 23, 2023

  • New Apache Spark Connector

  • Physical Deletion Performance Enhancement

Version 4.1 - March 01, 2023

  • LDAP Management Enhancements

  • New Trino Connector

  • Brute-Force Attack Protection

Version 4.0 - January 25, 2023

  • SQreamDB License Storage Capacity

  • LDAP Authentication

  • Physical Deletion Performance Enhancement

Previous Next

© Copyright 2023 SQream. Revision 5eb34053.