Closed morningman closed 5 hours ago
Thank you for your contribution to Apache Doris. Don't know what should be done next? See How to process your PR
Since 2024-03-18, the Document has been moved to doris-website. See Doris Document.
run buildall
run buildall
run buildall
run buildall
run buildall
run buildall
PR approved by anyone and no changes requested.
PR approved by at least one committer and no changes requested.
the output format of some data types are different between Presto/Trino and Doris, especially for complex type such as array, map and struct. When user migrate from Presto to Doris, they expect the same format so that they don't need to modify their business code.
This PR mainly changes:
Add a new session variable
serde_dialect
Default isdoris
, options arepresto
ortrino
. If set to presto or trino, the output format returned to MySQL client of some datatypes will be changed:Array Doris:
["abc", "def", "", null]
Presto:[abc, def, , NULL]
Map Doris:
{"k1":null, "k2":"v3"}
Presto:{k1=NULL, k2=v3}
Struct Doris:
{"s_id":100, "s_name":"abc , "", "s_address":null}
Presto:{s_id=100, s_name=abc , ", s_address=NULL}
Change the output format of struct type
Remove the space after
:
{"s_id": 100, "s_name": "abc , "", "s_address": null}
{"s_id":100, "s_name":"abc , "", "s_address":null}