- 필수 기능
- 앱 내
- 서비스 관리
- 인프라스트럭처
- 애플리케이션 성능
- 디지털 경험
- 소프트웨어 제공
- 보안
- 로그 관리
- 관리
- 인프라스트럭처
- ci
- containers
- csm
- ndm
- otel_guides
- overview
- slos
- synthetics
- tests
- 워크플로
DDSQL implements a simplified version of the SQL type system that is mostly descended from SQLite.
SQL name | Aliases | Description |
---|---|---|
integer | int | Storage is always int64. |
decimal | Precision and scale may be ignored. DDSQL implements the decimal type as floating point, rather than fixed point. | |
text | char, varchar, json | Storage is always unlimited-length UTF-8. |
real | double | Storage is always IEEE-754 float64. |
timestamp | timestamp without time zone | SQL standard datetime type. |
group | hstore, tag_column | Sorted set of strings with tag-like “= is contains” semantics. |
boolean | TRUE or FALSE |
The table below contains examples on how to declare literals for each type, for use in expressions like SELECT <LITERAL>
or in comparisons like WHERE timestamp > timestamp '1 hr ago'
.
Name | Example |
---|---|
integer | 1 , 4 , 23901239412 , 0x4B1D |
text | 'Hello, world' |
real | 1.0 , 1e30 , 314e-2 , .25 , 5. |
date | date <DATE_STRING> (where DATE_STRING is a string that can be parsed into a date, or a relative string like 1 day ago ') |