data 代表遵循format_template_row格式的数据行,由format_template_rows_between_delimiter设置制定的字符分隔。此占位符必须是格式字符串中的第一个占位符。 totals 代表遵循format_template_row格式的数据行,该行用于代表结果的总计值(当SQL语句包含了WITH TOTALS) min 代表遵循format_template_row格式的数据行,该行用...
ASOF LEFT JOIN quotes q ON t.symbol = q.symbol AND t.time >= q.time FORMAT Vertical; Row 1: ────── symbol: ABC volume: 200 trade_time: 2023-02-22 14:09:05 closest_quote_time: 2023-02-22 14:09:00 quote_price: 32.11 final_price: 6422 Row 2: ────── symbol: AB...
formatReadableTimeDelta(query_duration_ms / 1000) AS query_duration, formatReadableSize(memory_usage) AS memory_usage, formatReadableQuantity(read_rows) AS read_rows, formatReadableSize(read_bytes) AS read_data, formatReadableSize(ProfileEvents['ExternalProcessingUncompressedBytesTotal']) AS data_spille...
FORMAT Vertical; Row 1: ────── query: SELECT * FROM actors AS a JOIN roles AS r ON a.id = r.actor_id FORMAT `Null` SETTINGS join_algorithm = 'grace_hash', grace_hash_join_initial_buckets = 3 query_duration: 13 seconds memory_usage: 3.72 GiB read_rows: 101.00 million read...
FORMAT Vertical 输出: a: [1,2,3] toTypeName(array(1, 2, 3)): Array(UInt8) 如果数组中元素有一个NULL空值,类型会相应地变成可空元素类型。 SQL 实例: SELECT [1, 2, NULL] AS x, toTypeName(x) FORMAT Vertical 输出: x: [1,2,NULL] ...
可以指定输出的结果格式,默认情况下,使用的格式是 PrettyCompact。可以在查询的 FORMAT 子句中更改格式,或者通过\G在查询末尾指定、使用命令行中的–formator–vertical参数或使用客户端配置文件来更改格式。 会显示查询的结果行数,用时,以及查询处理的平均速度 ...
SELECT * FROM otel.otel_logs LIMIT 1 FORMAT Vertical Row 1: ────── Timestamp: 2023-01-04 17:27:29.880230118 TraceId: SpanId: TraceFlags: 0 SeverityText: SeverityNumber: 0 ServiceName: Body: {"level":"debug","ts":1672853249.8801103,"logger":"activity_tracker","caller":"logging/lo...
query_cache FORMAT Vertical Query id: e10857e9-da10-4b53-892a-b9a4707c6216 Row 1:────── query: SELECT RegionID, uniq(UserID) AS u FROM hits_100m_obfuscated GROUP BY RegionID ORDER BY u DESC LIMIT 10 SETTINGS result_size: 512 stale: 1 shared: 1 compressed: 1 expires_at: ...
SELECT url, caption, L2Distance(image_embedding, [<embedding>]) AS score FROM laion_100m WHERE (width >= 300) AND (height >= 500) AND (copyright = '') AND similarity > 0.3 ORDER BY score ASC LIMIT 10 FORMAT Vertical Row 1: ────── url: https://aentcdn.azureedge.net/...
--format 使用指定的默认格式输出结果。--vertical 如果指定，默认情况下使用垂直格式输出结果。在这种格式...