[jira] [Resolved] (CARBONDATA-2111) TPCH query which has multiple joins inside does not return any rows.

[Akash R Nilugal (Jira)]

     [ 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)