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 <jh...@apache.org> 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 <ruw...@google.com.INVALID> 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 <ruw...@google.com> 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 <jh...@apache.org> 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 <ruw...@google.com.INVALID>
> >>> 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
> >>>
> >>>
>
>
