Skip to main content
Question

Inline querier window functions


Forum|alt.badge.img+1

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?

erik_jan
Contributor
Forum|alt.badge.img+17
  • Contributor
  • February 1, 2019

According to this thread: InlineQuerier FME 2018 is on SQLLite 3.8.2.

Hope this information is useful.


Forum|alt.badge.img+1
  • February 1, 2019

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.


erik_jan
Contributor
Forum|alt.badge.img+17
  • Contributor
  • February 1, 2019

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings