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

ASF GitHub Bot commented on TAJO-1345:
--------------------------------------

Github user jihoonson commented on the pull request:

    https://github.com/apache/tajo/pull/618#issuecomment-118757240
  
    @blrunner thanks for your nice work. I totally agree on that we follow 
Hive's partition policy.
    However, I found the invalid partition key generation error as follows.
    
    ```
    default> create table partitioned_nation (n_name text, n_comment text) 
partition by column (n_nationkey int8, n_regionkey int8) as select * from 
nation;
    
    default> \d partitioned_nation
    
    table name: default.partitioned_nation
    table uri: hdfs://localhost:7020/tajo/warehouse/default/partitioned_nation
    store type: CSV
    number of rows: 25
    volume: 267 B
    Options: 
        'text.delimiter'='|'
    
    schema: 
    n_name      TEXT
    n_comment   TEXT
    
    Partitions: 
    type:COLUMN
    columns::n_nationkey (INT8), n_regionkey (INT8)
    
    default> \dfs -ls 
hdfs://localhost:7020/tajo/warehouse/default/partitioned_nation/n_nationkey=0
    Found 5 items
    drwxr-xr-x   - jihoonson supergroup          0 2015-07-06 16:29 
hdfs://localhost:7020/tajo/warehouse/default/partitioned_nation/n_nationkey=0/n_regionkey=
 haggle. carefully final deposits detect slyly agai
    drwxr-xr-x   - jihoonson supergroup          0 2015-07-06 16:29 
hdfs://localhost:7020/tajo/warehouse/default/partitioned_nation/n_nationkey=0/n_regionkey=
 pending excuses haggle furiously deposits. pending, express pinto beans wake 
fluffily past t
    drwxr-xr-x   - jihoonson supergroup          0 2015-07-06 16:29 
hdfs://localhost:7020/tajo/warehouse/default/partitioned_nation/n_nationkey=0/n_regionkey=rns.
 blithely bold courts among the closely regular packages use furiously bold 
platelets%3F
    drwxr-xr-x   - jihoonson supergroup          0 2015-07-06 16:29 
hdfs://localhost:7020/tajo/warehouse/default/partitioned_nation/n_nationkey=0/n_regionkey=s.
 ironic, unusual asymptotes wake blithely r
    drwxr-xr-x   - jihoonson supergroup          0 2015-07-06 16:29 
hdfs://localhost:7020/tajo/warehouse/default/partitioned_nation/n_nationkey=0/n_regionkey=ven
 packages wake quickly. regu
    ```
    
    As you can see, the actual values of the partition key ```n_regionkey``` 
are those of ```n_comment``` column.


> Implement logical plan part and DDL executor for alter partition.
> -----------------------------------------------------------------
>
>                 Key: TAJO-1345
>                 URL: https://issues.apache.org/jira/browse/TAJO-1345
>             Project: Tajo
>          Issue Type: Sub-task
>          Components: planner/optimizer
>            Reporter: Jaehwa Jung
>            Assignee: Jaehwa Jung
>             Fix For: 0.11.0
>
>         Attachments: TAJO-1345.patch
>
>
> See the title. The main objective of this issue is to implement the logical 
> planning part and the DDL executor part for alter table partition support.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to