General syntax summarization


  • INT_VALUE : matching integer type constants, such as One hundred and twenty-three
  • DECIMAL_VALUE Matches fixed-point type constants, such as One hundred and twenty-three point four five six
  • STR_VALUE : matching string constants, such as ABC
  • NULL Match NULL constants.
  • STORAGE_SIZE : matching storage length constants, integer form default unit byte, string form can specify units M or G, such as One thousand and twenty-four or '500M'

character set

Sort rule

data type

SQL attribute

  • Object name

  • Expression

  • Notes

Distributed attribute

  • PRIMARY_ZONE : Specifies the main replica distribution policy for data.

  • ZONE_LIST : Specifies the resource allocation strategy for tenants.

  • REPLICA_NUM : specify the number of copies of the data.

  • TABLEGROUP : Specifies the main replica distribution strategy for multiple data.

Storage attribute

  • BLOCK_SIZE Specifies the length of the object to store.

  • COMPRESSION : Specifies the compression algorithm for object storage.

  • PCTFREE Specifies the reserved percentage of macroblock reserved for object storage.

  • TABLET_SIZE Specifies the minimum fragmentation of a single task in parallel merging.

Fabulous ( Eight hundred )

This article is composed of Ji Chang Xin Creation, article address: Https://
Use Knowledge sharing signature 4 The international license agreement is licensed. In addition to the reprint / provenance, all originals or translations of this site must be signed before retransmission. The final editing time is April, 7, 2019 at 07:55 afternoon.

Key word:

Hot articles


The commentary has been closed.

    •  Ji Chang Xin
      Ji Chang Xin Published in:

      Own notes, big guy early

The comments are closed!