I have uploaded a csv to a new install of apache superset, and I am querying it. So far it has been fine, but I am trying to use window functions, such as:

SELECT *, ROW_NUMBER() OVER( ORDER BY some_timestamp_utc) AS RowNumberRank
FROM StudentScore

and

select *, RANK() OVER(ORDER BY some_timestamp_utc) AS NoId
from StudentScore

These are not running (throwing an error saying near "(": syntax error. What is happening here and how can I use these window functions within superset on my uploaded csv table? Thanks.

0 Answers