Vertica and upgrading Grafana v7 to v9
I've got a new Grafana server running v9, and now installed the grafana plugin. Previously, I was using SQL Server linked servers to hop to Vertica.
Trying to go to Vertica directly is problematic.
1) I have an sql with "time BETWEEN $__timeFrom() and $__timeTo()", but it just doesn't work. I get an error "macro __timeFrom should have no arguments". I've tried all combinations. The only thing that works is to replace with "$__timeFilter(time)", which works in this case, but not others.
2) I also use the following : -
WHEN '$granularity' = 'min' THEN $__timeGroup(time, '1m', NULL)
WHEN '$granularity' = 'hour' THEN $__timeGroup(time, '1h', NULL)
END AS time,
but this also fails with "ERROR 4856:  Syntax error at or near "as""
Any help would be appreciated.