[ 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)