mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2026-10-17 17:32:30 +00:00
50 lines
912 B
Plaintext
50 lines
912 B
Plaintext
SELECT COUNT(*) AS n FROM t_trace_v2;
|
|
|
|
+---+
|
|
| n |
|
|
+---+
|
|
| 2 |
|
|
+---+
|
|
|
|
SELECT COUNT(*) AS n FROM t_trace_v2
|
|
WHERE span_attributes."http.status_code"::BIGINT = 200
|
|
AND span_attributes.nested."a.b"[0]::BOOLEAN = true;
|
|
|
|
+---+
|
|
| n |
|
|
+---+
|
|
| 1 |
|
|
+---+
|
|
|
|
SELECT COUNT(*) AS n FROM t_trace_v2
|
|
WHERE span_attributes."http.status_code"::STRING = 'ok'
|
|
AND span_attributes.bytes[1]::BIGINT = 2
|
|
AND scope_attributes.enabled::BOOLEAN = true
|
|
AND resource_attributes."deployment.environment"::STRING = 'prod';
|
|
|
|
+---+
|
|
| n |
|
|
+---+
|
|
| 1 |
|
|
+---+
|
|
|
|
SELECT COUNT(*) AS n FROM information_schema.columns
|
|
WHERE table_name = 't_trace_v2';
|
|
|
|
+----+
|
|
| n |
|
|
+----+
|
|
| 17 |
|
|
+----+
|
|
|
|
SELECT COUNT(*) AS n FROM information_schema.tables
|
|
WHERE table_name = 't_trace_v2'
|
|
AND create_options LIKE '%table_data_model=greptime_trace_v2%'
|
|
AND create_options LIKE '%greptime.semantic.pipeline=greptime_trace_v2%';
|
|
|
|
+---+
|
|
| n |
|
|
+---+
|
|
| 1 |
|
|
+---+
|