To be pedantic. Note that “strings” in SQL are called character literals and are enclosed in single-quotes.
My example also used named parameters. These used quoted identifiers. SQL identifiers are enclosed in double-quotes. Julian > On Sep 5, 2019, at 22:25, Rui Wang <[email protected]> wrote: > > I see. I think you are directing to using STRING for the table and > descriptor parameters. > > If so I think it's a good idea to do prototyping. I am digging into > implementation to prototype a version of "TABLE(TUMBLE("table_name", > "column_name", INTERVAL))" now. > > > -Rui > >> On Wed, Sep 4, 2019 at 8:03 PM Julian Hyde <[email protected]> wrote: >> >> Maybe they’re keywords? If so does it help to include them in >> double-quotes? e.g. >> >> myFun(“TABLE” => ’myTable’, >> “DESCRIPTOR” => ‘myDescriptor’) >> >> Julian >> >>> On Aug 29, 2019, at 7:46 PM, Rui Wang <[email protected]> wrote: >>> >>> And I think both TABLE and DESCRIPTOR are not supported as >> (table)function >>> parameters? >>> >>> TABLE parameter: TABLE(table_name) or TABLE table_name to specify an >>> input table. >>> DESCRIPTOR parameter: DESCRIPTOR(column_name, ...) to specify columns >> from >>> the input table. >>> >>> >>> -Rui >>> >>> >>>> On Thu, Aug 29, 2019 at 3:24 PM Rui Wang <[email protected]> wrote: >>>> >>>> Thanks Julian for your explanation and the pointer. >>>> >>>> I will go to the direction of TABLE(Function) syntax then. >>>> >>>> >>>> -Rui >>>> >>>>> On Thu, Aug 29, 2019 at 3:03 PM Julian Hyde <[email protected]> wrote: >>>>> >>>>> Standard SQL doesn’t allow functions in the FROM clause. I think it’s >>>>> because tables and functions are in different namespaces (and therefore >>>>> there could be a table and a function with the same name). So you need >> to >>>>> use the TABLE keyword to indicate that you are using a function as a >> table. >>>>> >>>>> This has been discussed before; see >>>>> >> https://issues.apache.org/jira/browse/CALCITE-1472?focusedCommentId=15662182&page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#comment-15662182 >>>>> < >>>>> >> https://issues.apache.org/jira/browse/CALCITE-1472?focusedCommentId=15662182&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-15662182 >>>>>> . >>>>> >>>>>> On Aug 29, 2019, at 2:37 PM, Rui Wang <[email protected]> >>>>> wrote: >>>>>> >>>>>> Hi Community, >>>>>> >>>>>> I have been searching and trying Calcite's query syntax to match >>>>>> CALCITE-3272 <https://jira.apache.org/jira/browse/CALCITE-3272> >> (TUBME >>>>> as a >>>>>> table function call). >>>>>> >>>>>> Currently, the closest syntax in Calcite I found is: >>>>>> >>>>>> FROM TABLE(TUMBLE(params...)) >>>>>> >>>>>> The better syntax should be: >>>>>> >>>>>> FROM TUMBLE(params..), which basically is the form of FROM >>>>>> table_function_name(params...). >>>>>> >>>>>> >>>>>> >>>>>> Is the second option already supported by Calcite? if not, would it be >>>>>> better to go to support it? >>>>>> >>>>>> >>>>>> -Rui >>>>> >>>>> >> >>
