Jihoon Son created TAJO-1674:
--------------------------------

             Summary: In CTAS and insert into statements, wrong partition keys 
are selected
                 Key: TAJO-1674
                 URL: https://issues.apache.org/jira/browse/TAJO-1674
             Project: Tajo
          Issue Type: Bug
    Affects Versions: 0.11.0
            Reporter: Jihoon Son


See the title.
You can reproduce this error as follows.
{noformat}
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
{noformat}



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

Reply via email to