You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@carbondata.apache.org by "Manish Gupta (JIRA)" <ji...@apache.org> on 2018/02/01 07:14:02 UTC
[jira] [Resolved] (CARBONDATA-2111) TPCH query which has multiple
joins inside does not return any rows.
[ https://issues.apache.org/jira/browse/CARBONDATA-2111?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Manish Gupta resolved CARBONDATA-2111.
--------------------------------------
Resolution: Fixed
Assignee: Ravindra Pesala
Fix Version/s: 1.3.0
> TPCH query which has multiple joins inside does not return any rows.
> --------------------------------------------------------------------
>
> Key: CARBONDATA-2111
> URL: https://issues.apache.org/jira/browse/CARBONDATA-2111
> Project: CarbonData
> Issue Type: Improvement
> Reporter: Ravindra Pesala
> Assignee: Ravindra Pesala
> Priority: Major
> Fix For: 1.3.0
>
> Time Spent: 20m
> Remaining Estimate: 0h
>
> The below TPCH query which has multiple joins does not return any roes.
> {code}
> sql(
> *"select s_acctbal, s_name, n_name, p_partkey, p_mfgr, s_address, s_phone, s_comment from "* +
> *"part, supplier, partsupp, nation, region where p_partkey = ps_partkey and s_suppkey = "* +
> *"ps_suppkey and p_size = 15 and p_type like '%BRASS' and s_nationkey = n_nationkey and "* +
> *"n_regionkey = r_regionkey and r_name = 'EUROPE' and ps_supplycost = ( select min"* +
> *"(ps_supplycost) from partsupp, supplier,nation, region where p_partkey = ps_partkey and "* +
> *"s_suppkey = ps_suppkey and s_nationkey = n_nationkey and n_regionkey = r_regionkey and "* +
> *"r_name = 'EUROPE' ) order by s_acctbal desc, n_name, s_name, p_partkey limit 100"*)
> {code}
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)