[
https://issues.apache.org/jira/browse/TAJO-1430?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dongjoon Hyun updated TAJO-1430:
--------------------------------
Description:
There are wide tables with many many columns. Moveover, BI tools generate very
complex queries whose size is several MB. Although Tajo executes those queries
very fast in a few seconds, the total time of UX is slow.
To become a fastest Hadoop DW, we need this following feature.
{code:sql}
time tsql -f middle.sql > /dev/null
real 0m19.058s
user 0m2.148s
sys 0m0.268s
time tsql -f ~/tajo/middle.sql > /dev/null
real 0m18.496s
user 0m2.119s
sys 0m0.240s
$ time ./tsql -f ~/tajo/long.sql > /dev/null
real 0m36.974s
user 0m2.305s
sys 0m0.272s
$ time ./tsql -f ~/tajo/long.sql > /dev/null
real 0m4.103s
user 0m2.237s
sys 0m0.249s
{code}
was:
There are wide tables with many many columns. Moveover, BI tools generate very
complex queries whose size is several MB. Although Tajo executes those queries
very fast in a few seconds, the total time of UX is slow.
To become a fastest Hadoop DW, we need this following feature.
{code:sql}
tsql -c "create table t3(a int)"
OK
tsql -c "insert overwrite into t select 1"
(1 rows, 0.14 sec, 2 B inserted)
time tsql -f middle.sql > /dev/null
real 0m19.058s
user 0m2.148s
sys 0m0.268s
time tsql -f ~/tajo/middle.sql > /dev/null
real 0m18.496s
user 0m2.119s
sys 0m0.240s
$ time ./tsql -f ~/tajo/long.sql > /dev/null
real 0m36.974s
user 0m2.305s
sys 0m0.272s
$ time ./tsql -f ~/tajo/long.sql > /dev/null
real 0m4.103s
user 0m2.237s
sys 0m0.249s
{code}
> Implement Query Parsing Result Caching
> --------------------------------------
>
> Key: TAJO-1430
> URL: https://issues.apache.org/jira/browse/TAJO-1430
> Project: Tajo
> Issue Type: New Feature
> Components: parser
> Affects Versions: 0.10.0
> Reporter: Dongjoon Hyun
> Assignee: Dongjoon Hyun
> Fix For: 0.10.1
>
>
> There are wide tables with many many columns. Moveover, BI tools generate
> very complex queries whose size is several MB. Although Tajo executes those
> queries very fast in a few seconds, the total time of UX is slow.
> To become a fastest Hadoop DW, we need this following feature.
> {code:sql}
> time tsql -f middle.sql > /dev/null
> real 0m19.058s
> user 0m2.148s
> sys 0m0.268s
> time tsql -f ~/tajo/middle.sql > /dev/null
> real 0m18.496s
> user 0m2.119s
> sys 0m0.240s
> $ time ./tsql -f ~/tajo/long.sql > /dev/null
> real 0m36.974s
> user 0m2.305s
> sys 0m0.272s
> $ time ./tsql -f ~/tajo/long.sql > /dev/null
> real 0m4.103s
> user 0m2.237s
> sys 0m0.249s
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
