Back to Starrocks

get_query_dump

docs/en/sql-reference/sql-functions/meta-functions/get_query_dump.md

4.1.0550 B
Original Source

get_query_dump

get_query_dump(query) get_query_dump(query, enable_mock)

These functions return a dump of the query for debugging purposes.

Arguments

query: The SQL query string (VARCHAR). enable_mock: (Optional) A boolean value indicating whether to enable mock data for the dump. Defaults to FALSE.

Return Value

Returns a VARCHAR string containing the query dump.

Examples

Example 1: Get a simple query's dump without mocking data

mysql> select get_query_dump('select * from ss limit 1');
1 row in set (0.04 sec)