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?
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+22- Contributor
- 2179 replies
According to this thread: InlineQuerier FME 2018 is on SQLLite 3.8.2.
Hope this information is useful.
+1Hi @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.
+22- Contributor
- 2179 replies
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