You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@tajo.apache.org by "Jihoon Son (JIRA)" <ji...@apache.org> on 2015/07/06 09:56:04 UTC
[jira] [Created] (TAJO-1674) In CTAS and insert into statements,
wrong partition keys are selected
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)