Feature Guides

In this section:

• Access Control
  • Overview
  • Terminology
    • Roles
    • Authentication
    • Authorization
  • Roles
    • Creating new roles (users)
    • Dropping a user
    • Altering a user
    • Public Role
    • Role membership (groups)
  • Permissions
    • GRANT
    • REVOKE
    • Default permissions
  • Departmental Example
• Concurrency and Locks
  • Locking modes
  • When are locks obtained?
    • Global locks
  • Monitoring locks
  • Troubleshooting locks
    • Example
• Concurrency and Scaling in SQream DB
  • Scaling when data sizes grow
  • Scaling when queries are queueing
  • What to do when queries are slow
• Metadata System
  • How is metadata collected?
  • How is metadata used?
  • Why is metadata always on?
• Chunks and Extents
  • What are chunks? What are extents?
    • Chunks
    • Extents
  • Why was SQream DB built with chunks and extents?
    • Benefits of chunking
    • Storage reorganization
    • Metadata
• Compression
  • Encoding
  • Compression
    • Automatic compression
    • Compression strategies
    • Specifying compression strategies
      • Explicitly specifying automatic compression
      • Forcing no compression (flat)
      • Forcing compressions
    • Examining compression effectiveness
      • Notes on reading this table:
  • Compression best practices
    • Let SQream DB decide on the compression strategy
    • Maximize the advantage of each compression schemes
    • Choose data types that fit the data
• Data Clustering
  • Clustered tables
  • When does clustering help?
  • Controlling data clustering
  • Examples
    • Creating a clustered table
• Deleting Data
  • How does deleting in SQream DB work?
    • Phase 1: Delete
    • Phase 2: Clean-up
  • Notes on data deletion
    • Deleting data does not free up space
    • SELECT performance on deleted rows
    • Use TRUNCATE instead of DELETE
    • Cleanup is I/O intensive
  • Example
    • Deleting values from a table
    • Deleting values based on more complex predicates
    • Identifying and cleaning up tables
      • List tables that haven’t been cleaned up
      • Identify predicates for clean-up
      • Triggering a cleanup
  • Best practices for data deletion
• Time-Based Data Management
  • Timestamped data
  • Chunking
  • Use cases
  • Best practices for time-based data
    • Use date and datetime types for columns
    • Ordering
    • Limit workload by timestamp
• Foreign Tables
  • What kind of data is supported?
  • What kind of data staging is supported?
  • Using foreign tables - a practical example
    • Planning for data staging
    • Creating the foreign table
      • From S3
      • From HDFS
    • Querying foreign tables
    • Modifying data from staging
    • Converting a foreign table to a standard database table
  • Error handling and limitations
• Working with External Data
  • Amazon S3
    • S3 Configuration
    • S3 URI Format
    • Authentication
    • Examples
      • Planning for Data Staging
      • Creating a Foreign Table
      • Querying Foreign Tables
      • Bulk Loading a File from a Public S3 Bucket
      • Loading Files from an Authenticated S3 Bucket
  • Using SQream in an HDFS Environment
    • Configuring an HDFS Environment for the User sqream
    • Authenticating Hadoop Servers that Require Kerberos
• Transactions
• Workload Manager
  • Overview
  • Setting Up Service Queues
  • Example - Allocating ETL Resources
    • Creating the Configuration
    • Verifying the Configuration
  • Configuring a Client Connection to a Specific Service
    • Using SQream Studio
    • Using the SQream SQL CLI Reference
    • Using a JDBC Client Driver
    • Using an ODBC Client Driver
    • Using a Python Client Driver
    • Using a Node.js Client Driver
• Python UDF (User-Defined Functions)
  • A simple example
  • Why use UDFs?
  • SQream DB’s UDF support
    • Scalar functions
    • Python
    • Using modules
  • Finding existing UDFs in the catalog
  • Getting the DDL for a function
  • Error handling
  • Permissions and sharing
  • Best practices
• Saved Queries
  • How saved queries work
  • Parameters support
  • Creating a saved query
    • Saving a simple query
    • Saving a parametrized query
  • Listing and executing saved queries
  • Dropping a saved query
• Seeing System Objects as DDL
  • Dump specific objects
    • Tables
      • Getting the DDL for a table
      • Exporting table DDL to a file
    • Views
      • Listing all views
      • Getting the DDL for a view
      • Exporting view DDL to a file
    • User defined functions
      • Listing all UDFs
      • Getting the DDL for a function
    • Exporting function DDL to a file
    • Saved queries
  • Dump entire database DDLs
    • Exporting database DDL to a client
    • Exporting database DDL to a file