All Product Document

Data Warehouse

• Function Release Record
• Product Description
  • Product Introduction
  • System Architecture
• Product Pricing
  • Billing Instructions
  • Prepaid
  • Postpaid
• Getting Started
  • Get Started in 5 Minutes
  • Create Clusters
• Start to Use
  • Basic Operations Guide
  • Advanced Operations Guide
  • Relation Model and Data Division
  • Data Model
  • Index
• Operating Manual
  • Data Load
    • Load Overview
    • Load Local Data
    • Load Data in BOS
    • Subscribe Kafka Log
    • Use JDBC to Synchronize Data
    • Synchronize Data Through External Table
    • Load JSON Data
    • Load Transaction and Atomicity
    • Column mapping, converting and filtering
    • Strict Mode
  • Data Update and Delete
    • Data Update
    • Data Delete
    • Mark Deletion
    • Sequence-Column
  • Data Export
    • Export Overview
    • Full Data Export
    • Export Data to External Table
    • Export Query Results Set
  • BI Tool Access
    • Sugar
    • Navicat
    • Tableau
    • DBeaver
    • YONGHONGBI
    • FineBI
  • Backup and Recovery
  • Materialized View
  • Privilege Management
  • Resource Management
  • Variable
  • Time Zone
  • Experimental Functions
• Operation Guide
  • Cluster Scaling
• SQL Manual
  • Built-in Functions
    • String Function
    • Conditional Function
    • HLL Function
    • Generic Function
    • BITMAP Function
    • Format Conversion Function
    • Time and Date Function
    • Type Conversion Function
    • Aggregate Function
    • Bit Operation Function
    • JSON Parsing Function
    • Mathematical Function
  • Syntactical Help
    • DDL
      • CREATE-FILE
      • CREATE-TABLE
      • CREATE-REPOSITORY
      • CREATE-ODBC-TABLE
      • CREATE-MATERIALIZED-VIEW
      • CREATE-RESOURCE
      • DROP-RESOURCE
      • DROP-REPOSITORY
    • DML
      • BROKER-LOAD
      • BACKUP
      • EXPORT
      • STREAM-LOAD
      • RESTORE
      • ROUTINE-LOAD
      • SELECT-INTO-OUTFILE
      • INSERT
    • Information View Statement
      • SHOW-FILE
      • SHOW-ROLES
      • SHOW-GRANTS
      • SHOW-EXPORT
      • SHOW-ROUTINE-LOAD-TASK
      • SHOW-REPOSITORIES
      • SHOW-RESOURCES
      • SHOW-LOAD
      • SHOW-RESTORE
      • SHOW-PROPERTY
      • SHOW-BACKUP
      • SHOW-ALTER-TABLE-MATERIALIZED-VIEW
      • SHOW-SNAPSHOT
      • SHOW-ROUTINE-LOAD
    • Account Management
      • SET-PROPERTY
      • SET-PASSWORD
      • DROP-USER
      • CREATE-USER
      • DROP-ROLE
      • CREATE-ROLE
      • GRANT
      • REVOKE
    • Auxiliary Commands
      • RESUME-ROUTINE-LOAD
      • CANCEL-LOAD
      • ALTER-ROUTINE-LOAD
      • STOP-ROUTINE-LOAD
      • PAUSE-ROUTINE-LOAD
  • Alias
  • Comments
  • Data Type
  • Literal Constant
  • SQL Operators
  • SQL-Manual
• Service Level AgreementSLA
  • Palo Service Level Agreement SLA（V1.0）
• Open Source Zone
  • Open Source Version