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

[Akash R Nilugal (Jira)]

Ravindra Pesala created CARBONDATA-2111:
-------------------------------------------

             Summary: 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


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)