Skip to content

SnappyData™ 1.3.1

System Tables

Initializing search

SnappyData™ 1.3.1

Overview
Release Notes
Provisioning SnappyData
Provisioning SnappyData
Getting Started
Getting Started
Configure/Launch SnappyData Cluster
Concepts
Concepts
- Core Components
- SnappyData Cluster Architecture
- Hybrid Cluster Manager
- Distributed Transactions
  Distributed Transactions
  - How Transactions Work for Row Tables
  - Lock-free Queries using MVCC and Snapshot Isolation for Column Tables
- Affinity Modes
  Affinity Modes
How Tos
How Tos
Programming Guide
Programming Guide
Best Practices
Best Practices
Approximate Query Processing
Approximate Query Processing
Working with Data Sources
Working with Data Sources
Managing and Monitoring
Managing and Monitoring
Managing Security
Managing Security
Evaluating Statistics for the System and Applications
Evaluating Statistics for the System and Applications
- Collecting System Statistics
- Using VSD to Analyze Statistics
  Using VSD to Analyze Statistics
Reference Guides
Reference Guides
- Configuration Reference
- List of Properties
- SQL Reference Guide
  SQL Reference Guide
  - ALTER TABLE
  - CREATE Statements
    CREATE Statements
    
    CREATE DISKSTORE
    
    CREATE EXTERNAL TABLE
    
    CREATE FUNCTION
    
    CREATE INDEX
    
    CREATE SCHEMA
    
    CREATE STREAM TABLE
    
    CREATE SAMPLE TABLE
    
    CREATE TABLE
    
    CREATE TEMPORARY TABLE
    
    CREATE VIEW
  - DELETE
  - DROP Statements
    DROP Statements
    
    DROP DISKSTORE
    
    DROP FUNCTION
    
    DROP INDEX
    
    DROP TABLE/EXTERNAL TABLE/SAMPLE TABLE
    
    DROP SCHEMA
  - DEPLOY Statements
    DEPLOY Statements
    
    DEPLOY PACKAGE
    
    DEPLOY JAR
    
    UNDEPLOY
  - exec scala
  - EXPLAIN
  - GRANT
  - GRANT ALL
  - INSERT
  - LATERAL VIEW
  - LIST
  - PIVOT
  - PUT INTO
  - REVOKE
  - REVOKE ALL
  - SELECT
  - SET ISOLATION
  - SET SCHEMA
  - TRUNCATE TABLE
  - UPDATE
- SQL Functions
  SQL Functions
- SQL General Limitations
- Built-in System Procedures and Built-in Functions
  Built-in System Procedures and Built-in Functions
- System Tables
  System Tables
- Command Line Utilities
  Command Line Utilities
- Snappy-SQL Shell Interactive Commands
  Snappy-SQL Shell Interactive Commands
  - autocommit
  - commit
  - connect client
  - connect
  - describe
  - disconnect
  - elapsedtime
  - exit
  - MaximumDisplayWidth
  - rollback
  - run
  - set connection
  - show
- Configuration Parameters
  Configuration Parameters
- Full API Reference Guides
- ODBC Supported API
- Supported Data Types
- Configuring SSH Login without Password
- Setting Up SnappyData ODBC Driver
- Setting Up SnappyData JDBC Client and QlikView
Experimental Features
Troubleshooting Common Problems
Troubleshooting Common Problems
Unsupported Third-Party Modules
Community Edition Features
Doc Archives
Contact and Support
License
Important Information

System Tables¶

Tables that SnappyData uses to manage the distributed system and its data. All system tables are part of the SYS schema.

The following system tables are available:

MEMBERS
SYSDISKSTORES
SYSDISKSTOREIDS
SYSTABLES

Previous CURRENT_USER_LDAP_GROUPS

Copyright © 2017-2022 TIBCO Software Inc. All rights reserved.

Made with Material for MkDocs