LEFT() and RIGHT() functions do not work in DruidSQL

[vogievetsky]

Affected Version

0.15.0, 0.16.0-snapshot

Description

LEFT and RIGHT are documented:

https://druid.apache.org/docs/latest/querying/sql

but they do not seem to be supported in Calcite:

[jon-wei]

Related: https://issues.apache.org/jira/browse/CALCITE-3005

Upgrading to Calcite 1.20.0+ seems to work, investigating/testing more

[jon-wei]

Also related: #8406