right() is documented on the wiki ( https://cwiki.apache.org/confluence/display/DRILL/SQL+Functions, last edited 6 weeks ago), but doesn't seem to be a valid function:
use sys;
0: jdbc:drill:zk=local> select right("blahblah",2) from version;
Query failed: Query failed: Failure parsing SQL. Encountered "right" at
line 1, column 8.
It doesn't show up in the list of expected functions:
"POWER" ...
"RANK" ...
"ROW_NUMBER" ...
"SQRT" ...
"STDDEV_POP" ...
What am I missing?
