[ https://issues.apache.org/jira/browse/PHOENIX-1002?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14056458#comment-14056458 ]
Kyle Buzsaki commented on PHOENIX-1002: --------------------------------------- It seems that the grammar modification is going to be more complex than previously thought. The way that precedence is handled with mathematical operators may need to be revisited. See my new issue at PHOENIX-1075 for an explanation of why. > 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 > > > 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)