You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "liupengcheng (Jira)" <ji...@apache.org> on 2020/09/22 07:43:00 UTC

[jira] [Comment Edited] (CALCITE-4176) Key descriptor can be optional in SESSION table function

    [ https://issues.apache.org/jira/browse/CALCITE-4176?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17199887#comment-17199887 ] 

liupengcheng edited comment on CALCITE-4176 at 9/22/20, 7:42 AM:
-----------------------------------------------------------------

hi, [~danny0405] [~amaliujia] , -I checked the latest code, it seems we are now only allow optional arguments at the ends of parameters, so here making the keyCol optional has a violation to this constraints.-
 -So do you have any suggestions?-

I think I misunderstand it, please ignore it.


was (Author: liupengcheng):
hi, [~danny0405] [~amaliujia] , I checked the latest code, it seems we are now only allow optional arguments at the ends of parameters, so here making the keyCol optional has a violation to this constraints.
So do you have any suggestions?

> Key descriptor can be optional in SESSION table function
> --------------------------------------------------------
>
>                 Key: CALCITE-4176
>                 URL: https://issues.apache.org/jira/browse/CALCITE-4176
>             Project: Calcite
>          Issue Type: Sub-task
>            Reporter: Rui Wang
>            Priority: Major
>              Labels: pull-request-available
>             Fix For: 1.26.0
>
>          Time Spent: 1h 20m
>  Remaining Estimate: 0h
>
> In [1], people mentioned key descriptor might not be required for use cases in SESSION table function. For example, the SESSION table function can directly be applied on a data from a website. Technically there is still a key, but just all data have the same website key.
> There are three options to make key descriptor "optional"
>  1) make key descriptor optional. 
> 2) accept empty descriptor. 
> 3) descriptor becomes nullable. 
> I am planning to try 1) first. 
> [1]: https://issues.apache.org/jira/browse/CALCITE-3780?focusedCommentId=17166086&page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#comment-17166086



--
This message was sent by Atlassian Jira
(v8.3.4#803005)