v2020.3
Contents:
Getting Started
Preparing Your Machine to Install SQream
Installing SQream
Executing Statements in SQream
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
Installation Guides
Installing and Launching SQream
Recommended Pre-Installation Configuration
Installing SQream Using Binary Packages
Installing and Running SQream in a Docker Container
Installing SQream with Kubernetes
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
Inserting Data Overview
Inserting Data from a CSV File
Inserting Data from a Parquet File
Inserting Data from an ORC File
Migrating Data from Oracle
Connecting to SQream
Client Platforms
Connect to SQream Using Informatica Cloud Services
Connect to SQream Using MicroStrategy
Connecting to SQream Using Pentaho Data Integration
Connect to SQream Using PHP
Connect to SQream Using Power BI Desktop
Connect to SQream Using R
Connecting to SQream Using SAP BusinessObjects
Connect to SQream Using SAS Viya
Connect to SQream Using SQL Workbench
Connecting to SQream Using Tableau
Connecting to SQream Using Talend
Connecting to SQream Using TIBCO Spotfire
Client Drivers for Version 2020.3
JDBC
Python (pysqream)
Node.JS
ODBC
Install and Configure ODBC on Windows
Install and configure ODBC on Linux
C++ Driver
External Storage Platforms
Inserting Data Using Amazon S3
Using SQream in an HDFS Environment
Loading and Unloading Data
Feature Guides
Compression
Python UDF (User-Defined Functions)
Workload Manager
Transactions
Concurrency and Locks
Concurrency and Scaling in SQream DB
Operational Guides
Creating or Cloning Storage Clusters
Foreign Tables
Deleting Data
Exporting Data
Logging
Monitoring Query Performance
Security
Saved Queries
Seeing System Objects as DDL
Optimization and Best Practices
SQream Acceleration Studio 5.4.3
Getting Started with SQream Acceleration Studio 5.4.3
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
System Architecture
Internals and Architecture
Filesystem and usage
Configuration Guides
Configuring the Spooling Feature
Configuring SQream
Configuration Levels
Flag Types
Configuration Roles
Modification Methods
Configuring Your Parameter Values
Command Examples
Showing All Flags in the Catalog Table
All Configurations
Configuration Flags
Administration Flags
Regular Administration Flags
Cluster Administration Flags
Worker Administration Flags
Generic Flags
Regular Generic Flags
Worker Generic Flags
Configuring SQream Using the Previous Configuration Method
Reference Guides
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
sqream-console
sqream-installer
server_picker
SqreamStorage
sqream sql
upgrade_storage
SQL Feature Checklist
Python API Reference Guide
Data Type Guides
Converting and Casting Types
Supported Data Types
Supported Casts
Numeric
Boolean
Integer
Floating Point
String
Date
Release Notes
Release Notes 2020.3
Release Notes 2020.3
Release Notes 2020.2
Release Notes 2020.1
Troubleshooting
Remedying Slow Queries
Resolving Common Issues
Examining Logs
Identifying Configuration Issues
Lock Related Issues
SAS Viya Related Issues
Tableau Related Issues
Solving “Code 126” ODBC Errors
Log Related Issues
Node.js Related Issues
Core Dumping Related Issues
SQream SQL Installation Related Issues
Gathering Information for SQream Support
Glossary
SQream DB
»
Reference Guides
»
Catalog Reference Guide
Catalog Reference Guide
¶
The
Catalog Reference Guide
describes the following:
Overview
What Information Does the Schema Contain?
Catalog Tables
Additional Tables
Examples
SQream DB
v: v2020.3
Versions
latest
v2022.1
v2021.2.1.24
v2021.2.1
v2021.2
v2021.1.2
v2021.1.1
v2021.1
v2020.3.2.1
v2020.3.2
v2020.3.1
v2020.3
v2020-2
v2020-1
internal_documentation
Downloads
pdf
html