[
https://issues.apache.org/jira/browse/TAJO-1674?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14730265#comment-14730265
]
Hyunsik Choi commented on TAJO-1674:
------------------------------------
This is a kind of query validation error. I added the validation rule.
> Validation of CTAS schema mismatch
> ----------------------------------
>
> Key: TAJO-1674
> URL: https://issues.apache.org/jira/browse/TAJO-1674
> Project: Tajo
> Issue Type: Bug
> Components: Query Validation
> Reporter: Jihoon Son
> Assignee: Hyunsik Choi
> Priority: Blocker
> Fix For: 0.11.0
>
>
> 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)
