[TAJO-1791] Cannot recognize column name from FROM subquery

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Duplicate
• Labels: sql
• Assignee: Unassigned
• Reporter: Dongkyu Hwangbo
• Created: 20/Aug/15 04:59
• Updated: 17/Nov/15 06:23
• Resolved: 17/Nov/15 06:23

Description

This is TPC-H q13 in TPC-H Reference document.

select
	c_count, count(*) as custdist
from (
	select
		c_custkey, count(o_orderkey)
	from
		customer
	left outer join orders 
	on c_custkey = o_custkey
	and o_comment not like '%special%requests%'
	group by c_custkey
)as c_orders(c_custkey, c_count)
group by c_count
order by custdist desc, c_count desc;

TAJO cannot run this query because of this line.

as c_orders(c_custkey, c_count)

To run this query, modify a little bit like below.

select
	c_count, count(*) as custdist
from (
	select
		c_custkey, count(o_orderkey) c_count
	from
		customer
	left outer join orders 
	on c_custkey = o_custkey
	and o_comment not like '%special%requests%'
	group by c_custkey
)as c_orders
group by c_count
order by custdist desc, c_count desc;

Issue Links

• is duplicated by: TAJO-363 Columns in subquery schema cannot be resolved