- 필수 기능
- 시작하기
- Glossary
- 표준 속성
- Guides
- Agent
- 통합
- 개방형텔레메트리
- 개발자
- API
- Datadog Mobile App
- CoScreen
- Cloudcraft
- 앱 내
- 서비스 관리
- 인프라스트럭처
- 애플리케이션 성능
- APM
- Continuous Profiler
- 스팬 시각화
- 데이터 스트림 모니터링
- 데이터 작업 모니터링
- 디지털 경험
- 소프트웨어 제공
- 보안
- AI Observability
- 로그 관리
- 관리
DDSQL implements a simplified version of the SQL type system that is mostly descended from PostgreSQL.
SQL name | Aliases | Description |
---|---|---|
integer | int | Storage is always int64. |
text | char, varchar, string | Storage is always an unlimited length UTF-8. |
real | double, decimal | Storage is always IEEE-754 float64. |
timestamp | timestamp without time zone | SQL standard datetime type. |
date | Timestamp with resolution on a day level. | |
interval | Duration of time. | |
group | hstore, tag_column | Sorted set of strings with tag-like “= is contains” semantics. |
boolean | TRUE or FALSE | |
json | JSON data |
Arrays are an ordered collection of a specific base type. Each base type can have a corresponding array type.
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 ') |
timestamp | timestamp <TIMESTAMP_STRING> (where TIMESTAMP_STRING is a string that can be parsed into a timestamp, or a relative string like '1 day ago' , 'now' ) |
interval | interval <INTERVAL> (where INTERVAL is a string that can be parsed into a interval, like 1 day , 30s , 2 min ') |
arrays | array<type>[values...] |