[ https://issues.apache.org/jira/browse/PHOENIX-2901?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15291444#comment-15291444 ]
Ankit Singhal commented on PHOENIX-2901: ---------------------------------------- can't we use the same schema which is there in physicalTableName and sequence name with _SEQ_tableName(currently the sequence name goes as _ID_)? > If namespaces are enabled, check for existence of schema when sequence created > ------------------------------------------------------------------------------ > > Key: PHOENIX-2901 > URL: https://issues.apache.org/jira/browse/PHOENIX-2901 > Project: Phoenix > Issue Type: Bug > Reporter: James Taylor > Assignee: Ankit Singhal > > If namespaces are enabled, we should check for the existence of the sequence > schema before creating the sequence. There are some sequences that are > generated by Phoenix to manage indexes over views which auto generate a > schema name. Perhaps it'd be better if those used the SYSTEM schema instead > and prepended the sequence name with the previous schema name to ensure > uniqueness. -- This message was sent by Atlassian JIRA (v6.3.4#6332)