[ 
https://issues.apache.org/jira/browse/PHOENIX-1311?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15210450#comment-15210450
 ] 

ASF GitHub Bot commented on PHOENIX-1311:
-----------------------------------------

Github user samarthjain commented on a diff in the pull request:

    https://github.com/apache/phoenix/pull/153#discussion_r57340354
  
    --- Diff: 
phoenix-core/src/it/java/org/apache/phoenix/end2end/CreateSchemaIT.java ---
    @@ -0,0 +1,67 @@
    +/*
    + * Licensed to the Apache Software Foundation (ASF) under one
    + * or more contributor license agreements.  See the NOTICE file
    + * distributed with this work for additional information
    + * regarding copyright ownership.  The ASF licenses this file
    + * to you under the Apache License, Version 2.0 (the
    + * "License"); you may not use this file except in compliance
    + * with the License.  You may obtain a copy of the License at
    + *
    + * http://www.apache.org/licenses/LICENSE-2.0
    + *
    + * Unless required by applicable law or agreed to in writing, software
    + * distributed under the License is distributed on an "AS IS" BASIS,
    + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
    + * See the License for the specific language governing permissions and
    + * limitations under the License.
    + */
    +package org.apache.phoenix.end2end;
    +
    +import static org.junit.Assert.assertNotEquals;
    +import static org.junit.Assert.fail;
    +
    +import java.sql.Connection;
    +import java.sql.DriverManager;
    +import java.util.Properties;
    +
    +import org.apache.hadoop.hbase.client.HBaseAdmin;
    +import org.apache.phoenix.schema.NewerSchemaAlreadyExistsException;
    +import org.apache.phoenix.schema.SchemaAlreadyExistsException;
    +import org.apache.phoenix.util.PhoenixRuntime;
    +import org.apache.phoenix.util.TestUtil;
    +import org.junit.Test;
    +
    +public class CreateSchemaIT extends BaseClientManagedTimeIT {
    +
    +    @Test
    +    public void testCreateSchema() throws Exception {
    +        long ts = nextTimestamp();
    +        Properties props = new Properties();
    +        props.setProperty(PhoenixRuntime.CURRENT_SCN_ATTRIB, 
Long.toString(ts));
    +        Connection conn = DriverManager.getConnection(getUrl(), props);
    +        HBaseAdmin admin = driver.getConnectionQueryServices(getUrl(), 
TestUtil.TEST_PROPERTIES).getAdmin();
    --- End diff --
    
    You can also alternatively directly go through PhoenixConnection to get 
hold of the admin. Like this:
    
    conn.unwrap(PhoenixConnection.class).getQueryServices().getAdmin(). 
    
    Minor nit: Even though this is test only, it is always better to close 
connections and HBaseAdmin using a try-with-resources construct.


> 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_v1.patch, 
> PHOENIX-1311_v2.patch, 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)

Reply via email to