Details
-
Sub-task
-
Status: Closed
-
Critical
-
Resolution: Fixed
-
1.9.0, 1.10.0
-
The Blink planner does not support the `substr` command yet. Instead, use the `substring` command.
Description
Currently many string builtin functions in blink planner follow hive/spark semantics, which should keep compatible with old planner. And some non-standard functions(Blink planner intros) should be removed.
- concat/concat_ws function (null treatment)
- substring function (follow calcite/flink)
- from_base64 should return string not binary
- intro truncate function to blink planner
- uuid should be no-argument (remove the one-argument version)
- length/jsonvalue/keyvalue/substr (non-standard function should be removed)
- md5/sha1/sha2/sha224/sha256/sha384/sha512(remove the two-arguments version)
- ascii (operand type should beSqlTypeFamily.CHARACTER)
Attachments
Issue Links
- causes
-
FLINK-13704 TPC-H end-to-end test (Blink planner) fails on Travis
- Resolved
- links to