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)
