思维导图备注

YugabyteDB 2.1 Document
首页 白天 夜间 BookChat 小程序 小程序 阅读
  • 书签 我的书签
  • 添加书签 添加书签 移除书签 移除书签

3. Explore YSQL

 来源:YugabyteDB 浏览 442 扫码 分享 2020-03-03 08:10:11
    当前内容版权归 YugabyteDB 或其关联方所有，如需对内容或内容相关联开源项目进行关注与资助，请访问 YugabyteDB .
    上一篇:
    下一篇:
    • 书签
    • 添加书签 移除书签
    • GET STARTED
      • Quick start
        • 1. Install YugabyteDB
        • 2. Create a local cluster
        • 3. Explore YSQL
        • 4. Build an application
          • Java
          • NodeJS
          • Go
          • Python
          • Ruby
          • C#
          • PHP
          • C++
          • C
      • Explore core features
        • Linear scalability
        • Fault tolerance
        • Global distribution
        • Auto sharding
        • Follower reads
        • Observability
        • Colocated tables
        • Change data capture (CDC)
        • Two data center (2DC)
    • USER GUIDES
      • Develop
        • Learn app development
          • 1. SQL vs NoSQL
          • 2. Data modeling
          • 3. Data types
          • 4. ACID transactions
          • 5. Aggregations
          • 6. Batch operations
          • 7. Date and time
          • 8. Strings and text
          • 9. TTL for data expiration
        • Ecosystem integrations
          • Apache Kafka
          • Apache Spark
          • JanusGraph
          • KairosDB
          • Presto
          • Metabase
        • Build GraphQL apps
          • Hasura
          • Prisma
        • Real-world examples
          • E-Commerce App
          • IoT Fleet Management
          • Retail Analytics
        • Explore sample apps
      • Deploy
        • Deployment checklist
        • Manual deployment
          • 1. System configuration
          • 2. Install software
          • 3. Start YB-Masters
          • 4. Start YB-TServers
          • 5. Verify deployment
        • Kubernetes
          • Open Source
          • Amazon EKS
          • Google Kubernetes Engine
          • Azure Kubernetes Service
          • Best Practices
        • Docker
        • Public clouds
          • Amazon Web Services
          • Google Cloud Platform
          • Microsoft Azure
        • Multi-DC deployments
          • Three+ data center (3DC)
          • Two data center (2DC)
        • Change data capture (CDC)
          • YugabyteDB CDC connector
          • CDC to Kafka
        • Pivotal Cloud Foundry
        • Yugabyte Platform
          • 1. Prepare cloud environment
          • 2. Install Admin Console
          • 3. Configure Admin Console
          • 4. Configure cloud providers
        • Yugabyte Cloud
          • Free Tier
          • Create clusters
          • Monitor clusters
          • Create databases
          • Manage database access
          • Connect to clusters
      • Benchmark
        • TPC-C
        • YCSB
        • Key-value workload
        • Large datasets
        • Scalability
          • Scaling queries
        • Resilience
          • Jepsen testing
      • Secure
        • Security checklist
        • Authentication
          • Authentication
          • Fine-grained authentication
        • Encryption in transit
          • Create client certificates
          • Create server certificates
          • Enable server-to-server encryption
          • Enable client-to-server encryption
          • Connect to clusters
        • Encryption at rest
        • Authorization
          • RBAC model
          • Create roles
          • Grant privileges
      • Manage
        • Back up and restore
          • Back up data
          • Restore data
          • Snapshot and restore data
        • Data migration
          • Bulk import
          • Bulk export
        • Change cluster configuration
        • Diagnostics reporting
        • Upgrade deployment
        • Yugabyte Platform
          • Create universe - Multi-zone
          • Create universe - Multi-region
          • Edit universe
          • Edit configuration options
          • Health checking and alerts
          • Create and edit instance tags
          • Node status and actions
          • Read replicas
          • Backup and restore
          • Upgrade universe
          • Delete universe
      • Troubleshoot
        • Troubleshooting
        • Cluster level issues
          • YCQL connection issues
          • YEDIS connection Issues
          • Recover tserver/master
        • Node level issues
          • Check processes
          • Inspect logs
          • System statistics
          • Disk failure
        • Yugabyte Platform
          • Troubleshoot universes
    • REFERENCE
      • APIs
        • YSQL
          • Statements
            • ABORT
            • ALTER DATABASE
            • ALTER DEFAULT PRIVILEGES
            • ALTER DOMAIN
            • ALTER GROUP
            • ALTER POLICY
            • ALTER ROLE
            • ALTER SEQUENCE
            • ALTER TABLE
            • ALTER USER
            • BEGIN
            • COMMIT
            • COPY
            • CREATE AGGREGATE
            • CREATE CAST
            • CREATE DATABASE
            • CREATE DOMAIN
            • CREATE FUNCTION
            • CREATE GROUP
            • CREATE INDEX
            • CREATE OPERATOR
            • CREATE OPERATOR CLASS
            • CREATE POLICY
            • CREATE PROCEDURE
            • CREATE ROLE
            • CREATE RULE
            • CREATE SCHEMA
            • CREATE SEQUENCE
            • CREATE TABLE
            • CREATE TABLE AS
            • CREATE TRIGGER
            • CREATE TYPE
            • CREATE USER
            • CREATE VIEW
            • DEALLOCATE
            • DELETE
            • DO
            • DROP AGGREGATE
            • DROP CAST
            • DROP DATABASE
            • DROP DOMAIN
            • DROP FUNCTION
            • DROP GROUP
            • DROP OPERATOR
            • DROP OPERATOR CLASS
            • DROP OWNED
            • DROP POLICY
            • DROP PROCEDURE
            • DROP ROLE
            • DROP RULE
            • DROP SEQUENCE
            • DROP TABLE
            • DROP TRIGGER
            • DROP TYPE
            • DROP USER
            • END
            • EXECUTE
            • EXPLAIN
            • GRANT
            • INSERT
            • LOCK
            • PREPARE
            • REASSIGN OWNED
            • RESET
            • REVOKE
            • ROLLBACK
            • SELECT
            • SET
            • SET CONSTRAINTS
            • SET ROLE
            • SET SESSION AUTHORIZATION
            • SET TRANSACTION
            • SHOW
            • SHOW TRANSACTION
            • TRUNCATE
            • UPDATE
          • Data types
            • Binary
            • Boolean
            • Character
            • Date-time
            • Json
            • Money
            • Numeric
            • Serial
            • UUID
          • Expressions
            • currval()
            • lastval()
            • nextval()
          • Extensions
          • Keywords
          • Reserved names
        • YCQL
          • Quick start YCQL
          • ALTER KEYSPACE
          • ALTER ROLE
          • ALTER TABLE
          • CREATE INDEX
          • CREATE KEYSPACE
          • CREATE ROLE
          • CREATE TABLE
          • CREATE TYPE
          • DROP INDEX
          • DROP KEYSPACE
          • DROP ROLE
          • DROP TABLE
          • DROP TYPE
          • GRANT PERMISSION
          • GRANT ROLE
          • REVOKE PERMISSION
          • REVOKE ROLE
          • USE
          • INSERT
          • SELECT
          • UPDATE
          • DELETE
          • TRANSACTION
          • TRUNCATE
          • Simple expressions
          • Subscript
          • Function Call
          • Operator call
          • BLOB
          • BOOLEAN
          • MAP, SET, LIST
          • FROZEN
          • INET
          • Integer and counter types
          • Non-integer
          • TEXT
          • Date & Time Types
          • UUID and TIMEUUID
          • JSONB
          • Date and time functions
      • CLIs
        • yb-ctl
        • yb-docker-ctl
        • ysqlsh
        • cqlsh
        • yb-admin
        • yb-ts-cli
        • ysql_dump
        • ysql_dumpall
      • Configuration
        • yb-tserver
        • yb-master
        • yugabyted
        • Default ports
      • Drivers
        • PostgreSQL JDBC Driver
        • YugabyteDB JDBC Driver
        • Spring Data YugabyteDB
      • Connectors
        • Kafka Connect YugabyteDB
      • Third party tools
        • DBeaver
        • DbSchema
        • pgAdmin
        • SQL Workbench/J
        • TablePlus
        • Visual Studio Code
      • Sample datasets
        • Chinook
        • Northwind
        • PgExercises
        • SportsDB
    • RELEASES
      • Release history
        • v2.1.0
        • v2.0.11
        • v2.0.10
        • v2.0.9
        • v2.0.8
        • v2.0.7
        • v2.0.6
        • v2.0.5
        • v2.0.3
        • v2.0.1
        • v2.0.0
        • v1.3.1
        • v1.3.0
        • v1.2.12
        • v1.2.11
        • v1.2.10
        • v1.2.9
        • v1.2.8
        • v1.2.6
        • v1.2.5
        • v1.2.4
    • CONCEPTS
      • Architecture
        • Design goals
        • Key concepts
          • Universe
          • YB-TServer
          • YB-Master
          • Acknowledgements
        • Core functions
          • Universe creation
          • Table creation
          • Write IO path
          • Read IO path
          • High availability
        • Layered architecture
        • Query layer
          • Overview
        • DocDB store
          • Sharding
          • Replication
          • Persistence
          • Performance
          • Colocated tables
        • DocDB transactions
          • Isolation Levels
          • Single row transactions
          • Distributed transactions
          • Transactional IO path
        • Change data capture (CDC)
        • Two data center (2DC) deployments
    • FAQ
      • Comparisons
        • Amazon Aurora
        • Google Cloud Spanner
        • CockroachDB
        • TiDB
        • Vitess
        • MongoDB
        • FoundationDB
        • Amazon DynamoDB
        • Azure Cosmos DB
        • Apache Cassandra
        • PostgreSQL
        • Redis in-memory store
        • Apache HBase
      • FAQs
        • General FAQ
        • Operations FAQ
        • API compatibility FAQ
        • Yugabyte Platform FAQ
    • CONTRIBUTOR GUIDES
      • Get involved
        • Core database
          • Contribution checklist
          • Build the source
          • Configure a CLion project
          • Run the tests
    • Misc
      • YEDIS
        • Quick start
        • Develop
          • Client drivers
            • C
            • C++
            • C#
            • Go
            • Java
            • NodeJS
            • Python
        • API reference
          • APPEND
          • AUTH
          • CONFIG
          • CREATEDB
          • DELETEDB
          • LISTDB
          • SELECT
          • DEL
          • ECHO
          • EXISTS
          • EXPIRE
          • EXPIREAT
          • FLUSHALL
          • FLUSHDB
          • GET
          • GETRANGE
          • GETSET
          • HDEL
          • HEXISTS
          • HGET
          • HGETALL
          • HINCRBY
          • HKEYS
          • HLEN
          • HMGET
          • HMSET
          • HSET
          • HSTRLEN
          • HVALS
          • INCR
          • INCRBY
          • KEYS
          • MONITOR
          • PEXPIRE
          • PEXPIREAT
          • PTTL
          • ROLE
          • SADD
          • SCARD
          • RENAME
          • SET
          • SETEX
          • PSETEX
          • SETRANGE
          • SISMEMBER
          • SMEMBERS
          • SREM
          • STRLEN
          • ZRANGE
          • TSADD
          • TSCARD
          • TSGET
          • TSLASTN
          • TSRANGEBYTIME
          • TSREM
          • TSREVRANGEBYTIME
          • TTL
          • ZADD
          • ZCARD
          • ZRANGEBYSCORE
          • ZREM
          • ZREVRANGE
          • ZSCORE
          • PUBSUB
          • PUBLISH
          • SUBSCRIBE
          • UNSUBSCRIBE
          • PSUBSCRIBE
          • PUNSUBSCRIBE
    暂无相关搜索结果！

      本文档使用 BookStack 构建

      展开/收起文章目录

      分享，让知识传承更久远

      文章二维码

      手机扫一扫，轻松掌上读

      文档下载

      • 普通下载
      • 下载码下载(免登录无限下载)
      你与大神的距离，只差一个APP
      APP下载
      请下载您需要的格式的文档，随时随地，享受汲取知识的乐趣！
      PDF文档 EPUB文档 MOBI文档
      温馨提示 每天每在网站阅读学习一分钟时长可下载一本电子书，每天连续签到可增加阅读时长
      下载码方式下载：免费、免登录、无限制。 免费获取下载码

      微信小程序阅读

      BookChat 微信小程序阅读
      您与他人的薪资差距，只差一个随时随地学习的小程序

      书签列表

        阅读记录

        阅读进度: 0.00% ( 0/0 ) 重置阅读进度