[
https://issues.apache.org/jira/browse/TAJO-1730?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14730575#comment-14730575
]
ASF GitHub Bot commented on TAJO-1730:
--------------------------------------
Github user jihoonson commented on the pull request:
https://github.com/apache/tajo/pull/719#issuecomment-137692131
The result of the following query is different from pgsql.
#### Tajo
```
postgres> select
> n_name,
> sum(l_extendedprice * (1 - l_discount)) as revenue
> from
> customer,
> orders,
> lineitem,
> supplier,
> nation,
> region
> where
> c_custkey = o_custkey
> and l_orderkey = o_orderkey
> and l_suppkey = s_suppkey
> and c_nationkey = s_nationkey
> and s_nationkey = n_nationkey
> and n_regionkey = r_regionkey
> and r_name = 'ASIA'
> and o_orderdate >= '1994-01-01'::date
> and o_orderdate < '1995-01-01'::timestamp
> group by
> n_name
> order by
> revenue desc;
Progress: 100%, response time: 0.559 sec
n_name, revenue
-------------------------------
(0 rows, 0.559 sec, 0 B selected)
```
#### PostgreSQL
```
postgres=# select
postgres-# n_name,
postgres-# sum(l_extendedprice * (1 - l_discount)) as revenue
postgres-# from
postgres-# customer,
postgres-# orders,
postgres-# lineitem,
postgres-# supplier,
postgres-# nation,
postgres-# region
postgres-# where
postgres-# c_custkey = o_custkey
postgres-# and l_orderkey = o_orderkey
postgres-# and l_suppkey = s_suppkey
postgres-# and c_nationkey = s_nationkey
postgres-# and s_nationkey = n_nationkey
postgres-# and n_regionkey = r_regionkey
postgres-# and r_name = 'ASIA'
postgres-# and o_orderdate >= '1994-01-01'::date
postgres-# and o_orderdate < '1995-01-01'::timestamp
postgres-# group by
postgres-# n_name
postgres-# order by
postgres-# revenue desc;
n_name | revenue
-----------+------------------
INDONESIA | 55502041.1697
VIETNAM | 55295086.9967
CHINA | 53724494.2566
INDIA | 52035512.0002
JAPAN | 45410175.6954001
(5 rows)
```
> JDBC Tablespace support
> -----------------------
>
> Key: TAJO-1730
> URL: https://issues.apache.org/jira/browse/TAJO-1730
> Project: Tajo
> Issue Type: Improvement
> Components: Storage
> Reporter: Hyunsik Choi
> Assignee: Hyunsik Choi
> Fix For: 0.11.0
>
> Attachments: TAJO-1730.patch, TAJO-1730_2.patch, TAJO-1730_3.patch
>
>
> The main objective of this issue is to implement JDBC-based storage and its
> Tablespace implementation.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
