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


#4

Hello,
Did the partition windowed function get carried out now that there was version 3.6 released?


#5

Window functions are not currently part of version 3.6. We are working internally to create a publicly shareable roadmap, but in the meantime, we definitely realize how valuable this functionality would be to add to MapD!


#6

are windowed functions working in 4.0?