[ https://issues.apache.org/jira/browse/PHOENIX-4138?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16181896#comment-16181896 ]
Hudson commented on PHOENIX-4138: --------------------------------- FAILURE: Integrated in Jenkins build Phoenix-master #1812 (See [https://builds.apache.org/job/Phoenix-master/1812/]) PHOENIX-4138 Create a hard limit on number of indexes per table (Churro (jamestaylor: rev 4969794bf0c91305d01c8f016abe95039642d46e) * (edit) phoenix-core/src/main/java/org/apache/phoenix/query/QueryServicesOptions.java * (edit) phoenix-core/src/it/java/org/apache/phoenix/end2end/CreateTableIT.java * (edit) phoenix-core/src/main/java/org/apache/phoenix/coprocessor/MetaDataEndpointImpl.java * (edit) phoenix-core/src/main/java/org/apache/phoenix/query/QueryServices.java * (add) phoenix-core/src/it/java/org/apache/phoenix/coprocessor/MetaDataEndpointImplTest.java > Create a hard limit on number of indexes per table > -------------------------------------------------- > > Key: PHOENIX-4138 > URL: https://issues.apache.org/jira/browse/PHOENIX-4138 > Project: Phoenix > Issue Type: Bug > Reporter: Rahul Shrivastava > Assignee: churro morales > Fix For: 4.12.0 > > Attachments: PHOENIX-4138.patch, PHOENIX-4138.v1.patch, > PHOENIX-4138.v2.patch, PHOENIX-4138_v3.patch > > Original Estimate: 48h > Remaining Estimate: 48h > > There should be a config parameter to impose a hard limit on number of > indexes per table. There is a SQL Exception > https://github.com/apache/phoenix/blob/master/phoenix-core/src/main/java/org/apache/phoenix/exception/SQLExceptionCode.java#L260 > , but it gets triggered on the server side > (https://github.com/apache/phoenix/blob/master/phoenix-core/src/main/java/org/apache/phoenix/coprocessor/MetaDataEndpointImpl.java#L1589) > . > We need a client side limit that can be configured via Phoenix config > parameter. Something like if user create more than lets say 30 indexes per > table, it would not allow more index creation for the that specific table. -- This message was sent by Atlassian JIRA (v6.4.14#64029)