Data Manipulation: ROW_NUMBER() OVER(PARTITION BY XYZ)


#1

Hello MapD folks, Love the effort!

There was useful calculation when joining tables in SQL Server with windowing. The goal is to do:

select *
,ROW_NUMBER() OVER(PARTITION BY t2.channel,t2.entry_id ORDER BY ABS(TIMESTAMPDIFF(SECOND,t2.created_dt,t1.DATE))) AS variable1
from …


#2

It looks like the window functions are not supported yet…
Are there any plans to implements those, MapD team?


#3

Hi

Thanks for trying MapD.

There is no PARTITION support in the product currently. It is on the roadmap.

regards