[
https://issues.apache.org/jira/browse/PHOENIX-2901?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15291375#comment-15291375
]
James Taylor commented on PHOENIX-2901:
---------------------------------------
bq. Do you mean , before creating a sequence, we should resolve sequence schema
name and throw exception if not exists?
Yes. The schema for a sequence should work the exact same way it works for a
table.
bq. so are you saying that we should change schema name to
SYSTEM_SEQ_physicalTableName?
No, the schema name of the sequence would be {{SYSTEM}} and the sequence name
would be {{SEQ_physicalTableName}} (or something along those lines).
> 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)
