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

Anoop Sam John commented on PHOENIX-1002:
-----------------------------------------

Thanks.  Going to commit now..

> Add support for % operator
> --------------------------
>
>                 Key: PHOENIX-1002
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-1002
>             Project: Phoenix
>          Issue Type: New Feature
>            Reporter: Thomas D'Silva
>            Assignee: Kyle Buzsaki
>             Fix For: 5.0.0, 3.1, 4.1
>
>         Attachments: PHOENIX-1002.patch, PHOENIX-1002_2.patch, 
> PHOENIX-1002_3.patch, PHOENIX-1002_4.patch, PHOENIX-1002_5.patch, 
> PHOENIX-1002_5_3-0.patch
>
>
> Supporting the % operator would allow using sequences to generate IDs that 
> are less than a maximum number. 
> CREATE SEQUENCE foo.bar
> SELECT ((NEXT VALUE FOR foo.bar)%1000)



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Reply via email to