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?
+17- Contributor
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.
+17- Contributor
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
Reply
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.