[ https://issues.apache.org/jira/browse/PHOENIX-1002?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14059248#comment-14059248 ]
James Taylor commented on PHOENIX-1002: --------------------------------------- +1. Nice work, [~kbuzsaki]. Would it be possible for someone to commit this please? [~anoop.hbase], [~stoens], [~ramkrishna]? This needs to go in *after* PHOENIX-1075. > 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 > Attachments: PHOENIX-1002.patch, PHOENIX-1002_2.patch, > PHOENIX-1002_3.patch, PHOENIX-1002_4.patch, PHOENIX-1002_5.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)