[
https://issues.apache.org/jira/browse/PHOENIX-2901?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15290978#comment-15290978
]
Ankit Singhal commented on PHOENIX-2901:
----------------------------------------
[~jamestaylor],
bq. If namespaces are enabled, we should check for the existence of the
sequence schema before creating the sequence.
Do you mean , before creating a sequence, we should resolve sequence schema
name and throw exception if not exists. Or you mean create a sequence schema
automatically if not present?
bq. 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.
currently , sequence schema is generated like this , _SEQ_<physicalTableName>,
so are you saying that we should change schema name to
SYSTEM_SEQ_physicalTableName?
I'm not sure ,I have followed correctly as have little context of usage of
schema name in sequences.
> 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)
