[
https://issues.apache.org/jira/browse/TAJO-1346?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14639126#comment-14639126
]
ASF GitHub Bot commented on TAJO-1346:
--------------------------------------
Github user blrunner commented on the pull request:
https://github.com/apache/tajo/pull/630#issuecomment-124167496
I tested to add partitions on MySQLStore as following:
* Data Set : TPC-H 1G
* Query Running Time
* 10,000 partitions : 6 sec
* 100,000 partitions: 50 sec
* Query
```
create table partitioned_lineitem3 (col1 text, col2 float8)
partition by column(col3 int4, col4 int4) as
select l_returnflag, l_quantity, l_orderkey, l_partkey from lineitem
where l_orderkey < 10000;
create table partitioned_lineitem4 (col1 text, col2 float8)
partition by column(col3 int4, col4 int4) as
select l_returnflag, l_quantity, l_orderkey, l_partkey from lineitem
where l_orderkey < 100000;
```
> Run ADD PARTITION after storing column partitioned table.
> ---------------------------------------------------------
>
> Key: TAJO-1346
> URL: https://issues.apache.org/jira/browse/TAJO-1346
> Project: Tajo
> Issue Type: Sub-task
> Components: Physical Operator
> Reporter: Jaehwa Jung
> Assignee: Jaehwa Jung
>
> Currently, If new partitions are added to HDFS by ColPartitionStoreExec,
> CatalogStore will not be aware of these partitions. So, Tajo need to run
> ALTER TABLE table_name ADD PARTITION on each of the newly added partitions
> automatically.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
