1.2.0
Overview
New Features
Provisioning TIBCO ComputeDB
Provisioning TIBCO ComputeDB
System Requirements
Installing TIBCO ComputeDB On-Premise
Setup TIBCO ComputeDB Cluster on AWS
Setup TIBCO ComputeDB Cluster on Kubernetes
Building a Docker Image with TIBCO ComputeDB Binaries
Building TIBCO ComputeDB from Source files
Upgrading TIBCO ComputeDB
Getting Started
Getting Started
Configure/Launch TIBCO ComputeDB Cluster
Using Apache Zeppelin with TIBCO ComputeDB
Quickstart Guide
Getting Started with your Spark Distribution
Using SQL
Using Spark Scala APIs
Benchmark 16-20x Faster Performance than Apache Spark
Structured Streaming
Concepts
Concepts
Core Components
TIBCO ComputeDB 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
Local Mode
Embedded TIBCO ComputeDB Store Mode
TIBCO ComputeDB Smart Connector Mode
How Tos
How Tos
How to Start a TIBCO ComputeDB Cluster
How to Check the Status of a TIBCO ComputeDB Cluster
How to Stop a TIBCO ComputeDB Cluster
How to Run Spark Job inside the Cluster
How to Access TIBCO ComputeDB Store from existing Spark Installation using Smart Connector
How to Use Snappy SQL shell (snappy-sql)
How to Create Row Tables and Run Queries
How to Create Column Tables and Run Queries
How to Load Data into TIBCO ComputeDB Tables
How to Load Data from External Data Stores (e.g. HDFS, Cassandra, Hive, etc)
How to Perform a Colocated Join
How to Connect using JDBC Driver
How to use TIBCO ComputeDB for any Spark Distribution
How to Store and Retrieve Complex Data Types in JDBC Programs
How to Store and Query JSON Objects
How to Store and Query Objects
How to use Stream Processing with TIBCO ComputeDB
How to use Transactions Isolation Levels
How to use Approximate Query Processing (AQP)to Run Approximate Queries
How to use Python to Create Tables and Run Queries
How to Connect using ODBC Driver
How to Connect to the Cluster from External Network
How to Import Data from Hive Table into TIBCO ComputeDB Table
How to Export and Restore Table Data using HDFS
How to Access TIBCO ComputeDB from Various SQL Client Tools
How to connect TIBCO Spotfire® Desktop to TIBCO ComputeDB
How to connect TIBCO® Data Virtualization to TIBCO ComputeDB
How to Connect Tableau to TIBCO ComputeDB
How to Deploy TIBCO ComputeDB from AWS Marketplace
How to Configure Apache Zeppelin to Securely and Concurrently access the TIBCO ComputeDB Cluster
Firewalls and Connections
Programming Guide
Programming Guide
SparkSession, SnappySession, and SnappyStreamingContext
Snappy Jobs
Managing JAR Files
Using Snappy Shell
Using the Spark Shell and spark-submit
Using pyspark Shell
Executing Spark Scala Code using SQL
Working with Hadoop YARN cluster Manager
Using JDBC with TIBCO ComputeDB
Accessing TIBCO ComputeDB Tables from any Spark (2.1+) Cluster
Multiple Language Binding using Thrift Protocol
Building TIBCO ComputeDB Applications using Spark API
Tables in TIBCO ComputeDB
Stream Processing using SQL
User Defined Functions (UDF) and User Defined Aggregate Functions (UDAF)
Best Practices
Best Practices
Tuning for Concurrency and Computation
Designing your Database and Schema
Designing your Database and Schema
Design Principles of Scalable, Partition-Aware Databases
Optimizing Query Latency: Partitioning and Replication Strategies
Memory Management
HA Considerations
Structured Streaming
Important Settings
TIBCO ComputeDB Distributed Transactions
Approximate Query Processing (AQP)
Approximate Query Processing
Key Concepts
Working with Stratified Samples
Running Queries
More Examples
Sample Selection
High-level Accuracy Contracts (HAC)
Sketching
Working with Data Sources
Working with Data Sources
Supported Data Formats
Accessing Cloud Storages
Connecting to External Hive Metastores
Using the TIBCO ComputeDB GemFire Connector
Connecting to TDV as Data Source from TIBCO ComputeDB
Using the TIBCO ComputeDB CDC (Change Data Capture) Connector
Deploying Third Party Connectors
Managing and Monitoring
Managing and Monitoring
TIBCO ComputeDB Monitoring UI
Configuring High Availability for a Partitioned Table
Configuring Logging
Monitoring with Metrics
Getting Information from TIBCO ComputeDB System Tables
Recovering Data During Cluster Failures
Managing Security
Managing Security
Launching the Cluster in Secure Mode
Specifying Encrypted Passwords in Conf Files or in Client Connections
Authentication - Connecting to a Secure Cluster
Authorization
Implementing Row Level Security
Configuring Network Encryption and Authentication using SSL
Enabling SSL Encryption in Different Socket Endpoints of TIBCO ComputeDB
Securing TIBCO ComputeDB UI Connection
User Names for Authentication, Authorization, and Membership
Evaluating Statistics for the System and Applications
Evaluating Statistics for the System and Applications
Collecting System 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
EXPLAIN
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
GRANT
GRANT ALL
INSERT
LATERAL VIEW
LIST
EXPLAIN
PUT INTO
REVOKE
REVOKE ALL
SELECT
SET ISOLATION
SET SCHEMA
TRUNCATE TABLE
UPDATE
SQL General Limitations
SQL Functions Reference
SQL Functions
Built-in System Procedures and Built-in Functions
Built-in System Procedures and Built-in Functions
DUMP_STACKS
REBALANCE_ALL_BUCKETS
SET_CRITICAL_HEAP_PERCENTAGE
SET_TRACE_FLAG
SYS.REMOVE_METASTORE_ENTRY
DSID
SYS.EXPORT_DDLS
SYS.EXPORT_DATA
System Tables
System Tables
MEMBERS
SYSDISKSTORES
SYSDISKSTOREIDS
SYSTABLES
Command Line Utilities
Command Line Utilities
backup and restore
compact-all-disk-stores
compact-disk-store
validate-disk-store
list-missing-disk-stores
revoke-missing-disk-store
unblock-disk-store
run
snappy-scala CLI
version
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
ack-severe-alert-threshold
ack-wait-threshold
allow-explicit-commit
archive-disk-space-limit
archive-file-size-limit
bind-address
enable-network-partition-detection
enable-stats
enable-time-statistics
enable-timestats
enforce-unique-host
init-scripts
load-balance
locators
log-file
log-level
member-timeout
membership-port-range
password
read-timeout
redundancy-zone
secondary-locators
skip-constraint-checks
skip-locks
socket-buffer-size
socket-lease-time
gemfirexd.datadictionary.allow-startup-errors
gemfirexd.default-startup-recovery-delay
snappy.history
gemfirexd.max-lock-wait
gemfirexd.query-cancellation-interval
gemfirexd.query-timeout
ssl-enabled
ssl-protocols
ssl-ciphers
ssl-require-authentication
start-locator
statistic-archive-file
statistic-sample-rate
statistic-sampling-enabled
sync-commits
sys-disk-dir
user
API Reference
ODBC Supported API
TIBCO ComputeDB Spark extension API Reference Guide
Supported Data Types
Configuring SSH Login without Password
Setting Up TIBCO ComputeDB ODBC Driver
Setting Up TIBCO ComputeDB JDBC Client and QlikView
Experimental Features
Troubleshooting Common Problems
Troubleshooting Common Problems
Member Startup Problems
Recovering from a ConflictingPersistentDataException
Preventing Disk Full Errors
Recovering from Disk Full Errors
Resolving Catalog Inconsistency Issues
Troubleshooting Out-of-Memory (OOM) Error
Collecting Logs, Stats and Dumps Using the collect-debug-artifacts Script
Troubleshooting Error Messages
Unsupported Third-Party Modules
TIBCO Documentation and Support Services
Legal Notices
1.2.0
Docs
»
Reference Guides »
SQL Functions Reference
This document is a work in progress and will be progressively updated.
SQL Functions
Details of
SnappyData SQL Functions
can be found
here
.
GitHub
« Previous
Next »