Some of the SQL functions that required by Tableau are not implemented in the Calcite dialect that is in use by Tableau connector

Description

many TDVT tests fail and complaining that some of SQL functions are not implemented - " No match found for function signature".
In order to pass Tableau tests, we need either to switch to a different dialect or create a function translations with the dialect that is currently in use.

Maxs-MBP:logs max$ grep -i "No match" 2020-03-26~10.28-gigaspaces-service-10.0.0.14-22145.log |awk '{print $(NF-1),"\t",$NF}'|sort |uniq

CONCAT(<CHARACTER>, <CHARACTER>)
IFNULL(<CHARACTER>, <CHARACTER>)
IFNULL(<DATE>, <DATE>)
IFNULL(<NUMERIC>, <NUMERIC>)
LEFT(<CHARACTER>, <NUMERIC>)
LOCATE(<CHARACTER>, <CHARACTER>)
RIGHT(<CHARACTER>, <NUMERIC>)
signature DAYNAME(<DATE>)
signature DAYNAME(<TIMESTAMP>)
signature LCASE(<CHARACTER>)
signature LOG(<APPROXIMATE_NUMERIC>)
signature LOG(<NUMERIC>)
signature MONTHNAME(<DATE>)
signature MONTHNAME(<TIMESTAMP>)
signature RTRIM(<CHARACTER>)
signature SPACE(<NUMERIC>)
signature UCASE(<CHARACTER>)
Maxs-MBP:logs max$


Assignee

Unassigned

Reporter

Max Berkman

Labels

Priority

Medium

Fix versions

None

Commitment Version/s

None

Due date

None

Product

None

Edition

Enterprise

Platform

All
Configure