Does function NTILE exist in JDV

Question

I am trying to work with percentiles in Teiid, but I get the following error

Query execution failed Reason: SQL Error [30068] [50000]: TEIID30068 Remote org.teiid.api.exception.query.QueryResolverException: TEIID30068 The function 'ntile(ALL 100)' is an unknown form. Check that the function name and number of arguments is correct.

The query I am using is:

   SELECT  id, zip5, 
     ntile(100) OVER(ORDER BY geopgraphy) as percentile
   FROM svi2105_us_zip5.svi2015_us_zip5;

Any ideas how to use this or any other similar functions?

score 0 · Answer 1 · answered Aug 10 '18 at 21:03

0

Not currently as of Teiid 11.0, but can log JIRA [1] for NTILE support.

[1] https://issues.jboss.org/projects/TEIID/issues

answered Aug 10 '18 at 21:03

Ramesh Reddy

554
1
3
8

is that the same for PERCENTILE_CONT ? – Norbert Funke Aug 13 '18 at 16:13
You can check for all the function support for Teiid here http://teiid.github.io/teiid-documents/master/content/reference/Scalar_Functions.html – Ramesh Reddy Aug 15 '18 at 13:58

Does function NTILE exist in JDV

1 Answers1