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?
According to this thread: InlineQuerier FME 2018 is on SQLLite 3.8.2.
Hope this information is useful.
+1
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
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.