You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@calcite.apache.org by "Jiajun Xie (Jira)" <ji...@apache.org> on 2024/09/10 09:25:00 UTC

[jira] [Created] (CALCITE-6569) RelToSqlConverter support IGNORE NULLS for window functions

Jiajun Xie created CALCITE-6569:
-----------------------------------

             Summary: RelToSqlConverter support IGNORE NULLS for window functions
                 Key: CALCITE-6569
                 URL: https://issues.apache.org/jira/browse/CALCITE-6569
             Project: Calcite
          Issue Type: Bug
          Components: core
    Affects Versions: 1.20.0
            Reporter: Jiajun Xie
            Assignee: Jiajun Xie


CALCITE-883(https://issues.apache.org/jira/browse/CALCITE-883) Support  IGNORE NULLS option for LEAD, LAG, FIRST_VALUE, LAST_VALUE and NTH_VALUE window functions.

But RelToSqlConverter not support them, IGNORE NULLS will be lost.

 

For example

 
{code:java}
SELECT LAG("employee_id", 2) IGNORE NULLS OVER (ORDER BY "hire_date") 
FROM "employee"{code}
 

It lost `IGNORE NULLS `
{code:java}
SELECT LAG("employee_id", 2) OVER (ORDER BY "hire_date") 
FROM "employee"{code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)