Logo
2022.1.6

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 Avro
    • Inserting Data from a CSV File
    • Inserting Data from a Parquet File
    • Inserting Data from an ORC File
  • Connecting to SQream
    • Client Platforms
      • Connect to SQream Using Informatica Cloud Services
      • 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
      • 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
      • JDBC
      • Connecting to SQream Using Python (pysqream)
      • Node.JS
      • ODBC
        • Install and Configure ODBC on Windows
        • Install and configure ODBC on Linux
      • .NET
  • External Storage Platforms
    • Inserting Data Using Amazon S3
    • Using SQream in an HDFS Environment
  • Loading and Unloading Data
  • Feature Guides
    • Automatic Foreign Table DDL Resolution
    • Query Healer
    • Data Encryption
      • Overview
      • Encryption Methods
      • Data Types
      • Syntax
      • Permissions
    • Compression
    • Python UDF (User-Defined Functions)
    • Workload Manager
    • Concurrency and Locks
    • Concurrency and Scaling in SQream DB
  • Operational Guides
    • Access Control
      • Password Policy
      • Overview
      • Managing Roles
      • Permissions
      • Departmental Example
    • Creating or Cloning Storage Clusters
    • Working with External Data
      • Inserting Data Using Amazon S3
      • Using SQream in an HDFS Environment
    • 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.7
    • Getting Started with SQream Acceleration Studio 5.4.7
    • 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
  • Data Type Guides
    • Converting and Casting Types
    • Supported Data Types
    • Supported Casts
      • Numeric
      • Boolean
      • Integer
      • Floating Point
      • String
      • Date
  • Release Notes
    • Release Notes 2022.1
      • 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
    • Release Notes 2021.2
      • Release Notes 2021.2.1.24
      • Release Notes 2021.2.1
      • Release Notes 2021.2
    • Release Notes 2021.1
      • Release Notes 2021.1.2
      • Release Notes 2021.1
    • Release Notes 2020.3
      • Release Notes 2020.3.2.1
      • What’s new in 2020.3.2
      • Release Notes 2020.3.1
      • 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
    • Log Related Issues
    • Core Dumping Related Issues
    • Gathering Information for SQream Support
  • Glossary
SQream DB
  • Configuration Guides
  • Configuration Flags
  • Administration Flags
  • Regular Administration Flags

Regular Administration Flags

The Regular Administration Flags page describes Regular modification type flags, which can be modified by administrators on a session and cluster basis using the ALTER SYSTEM SET command:

  • Setting Bin Size

  • Setting CUDA Memory

  • Limiting Runtime to Utility Functions

  • Enabling High Bin Control Granularity

  • Reducing CPU Hashtable Sizes

  • Setting Chunk Size for Copying from CPU to GPU

  • Indicating GPU Synchronicity

  • Setting the Graceful Server Shutdown

  • Enabling Modification of R&D Flags

  • Checking for Post-Production CUDA Errors

  • Enabling Modification of clientLogger_debug File

  • Activating the NVidia Profiler Markers

  • Appending String at End of Log Lines

  • Monitoring and Printing Pinned Allocation Reports

  • Increasing Chunk Size to Reduce Query Speed

  • Adding Rechunker before Expensing Chunk Producer

  • Setting the Buffer Size

  • Setting Memory Used to Abort Server

  • Splitting Large Reads for Concurrent Execution

  • Setting Worker Amount to Handle Concurrent Reads

  • Setting Implicit Casts in ORC Files

  • Setting Timeout Limit for Locking Objects before Executing Statements

  • Interpreting Decimal Literals as Double Instead of Numeric

  • Using Legacy String Literals

  • Blocking New VARCHAR Objects

  • Enabling Python UDFs

Previous Next

© Copyright 2022 SQream. Revision a91fce75.