Hi I'm wanting to use window functions in the Inline querier. For example, ROW_NUMBER() OVER (PARTITION BY .. ORDER BY). I see that SQLite version 3.25 onwards supports window functions. However, when I tried to write a query in the inline querier it was unable to execute the query. I'm using FME 2018.1.1.2. Does anyone know what version of SQLite the inline querier uses for FME 2018.1.1.2?
Page 1 / 1
According to this thread:
InlineQuerier
FME 2018 is on SQLLite 3.8.2.
Hope this information is useful.
Hi @erik_jan, thanks for the link. It's unfortunate that it's on this old version of SQLite as window functions are very powerful new feature.
Add your vote to this idea, it might help getting this implemented:
https://knowledge.safe.com/content/idea/31257/keep-up-with-sqlite-updates.html
Scanning file for viruses.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
This file cannot be downloaded
Sorry, our virus scanner detected that this file isn't safe to download.
