[
https://issues.apache.org/jira/browse/PHOENIX-1311?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15187401#comment-15187401
]
Ankit Singhal commented on PHOENIX-1311:
----------------------------------------
Thanks [~giacomotaylor] for the input.
PFA, patch for review
Brief summary of the current changes:-
* CREATE SCHEMA \[IF NOT EXISTS\] construct to store schema in SYSTEM.CATALOG
table with (no tenant and blank table).( let me know if you think we should
change table for storing schema to SYSTEM.SCHEMA or something).
* USE <schema> construct and jdbc url property to set schema in connection.
* CREATE TABLE will create table in namespace if global config
(phoenix.query.isNamespaceMappingEnabled) is enabled .And, In case of
index/view , it will inherit the namespace from parent table.
* SchemaResolver to resolve schema during creation of table(not index/view) and
USE <schema> construct. We will not resolve schema for query, as we will throw
tableNotFoundException.
there are some pending tasks which I am currently working on:-
* DROP SCHEMA construct
* how to migrate system tables to a SYSTEM namespace.
* Moving local index and view index prefix to tables.
* Adding test cases to handle corner cases.
* SQL exception CODES(currently they are dummy)
* UpgradeUtil for migration of tables to respective namespace.
> HBase namespaces surfaced in phoenix
> ------------------------------------
>
> Key: PHOENIX-1311
> URL: https://issues.apache.org/jira/browse/PHOENIX-1311
> Project: Phoenix
> Issue Type: New Feature
> Reporter: nicolas maillard
> Assignee: Ankit Singhal
> Priority: Minor
> Fix For: 4.8.0
>
> Attachments: PHOENIX-1311.docx, PHOENIX-1311_wip.patch,
> PHOENIX-1311_wip_2.patch
>
>
> Hbase (HBASE-8015) has the concept of namespaces in the form of
> myNamespace:MyTable it would be great if Phoenix leveraged this feature to
> give a database like feature on top of the table.
> Maybe to stay close to Hbase it could also be a create DB:Table...
> or DB.Table which is a more standard annotation?
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
