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;
```
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at [email protected] or file a JIRA ticket
with INFRA.
---
