You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@calcite.apache.org by "Rui Wang (Jira)" <ji...@apache.org> on 2019/09/11 19:27:00 UTC

[jira] [Created] (CALCITE-3339) DESCRIPTOR as a SQL operator in SqlStdOperatorTable

Rui Wang created CALCITE-3339:
---------------------------------

             Summary: DESCRIPTOR as a SQL operator in SqlStdOperatorTable
                 Key: CALCITE-3339
                 URL: https://issues.apache.org/jira/browse/CALCITE-3339
             Project: Calcite
          Issue Type: Sub-task
            Reporter: Rui Wang
            Assignee: Rui Wang


For query:

SELECT * 
FROM TABLE(TUMBLE_TVF(
        TABLE ORDERS,   // or could be TABLE(ORDERS)
    DESCRIPTOR(ROWTIME), 
        INTERVAL '10' MINUTE))

TABLE ORDERS is converted to SqlPrefixOperator, but DESCRIPTOR(ROWTIME) has no mapping in SqlStdOperatorTable. 

There are two options:
1. There is a SqlColumnListConstructor which serves the same(similar) purpose to specific a list of column. 
2. We create a new operator for DESCRIPTOR.

Reuse existing code is always good so we can start from option one and see if it works.





--
This message was sent by Atlassian Jira
(v8.3.2#803003)