"null" error returned when run sql with cte join cte

[yiwang <75...@qq.com>]

Hello Kylin Team,

Error:
null while executing SQL: "with aa as ( select lstg_format_name, count(
distinct buyer_id ) as temp from ( select * from kylin_sales ) _view_ where
ops_region = 'Shanghai' group by lstg_format_name ), bb as ( select
lstg_format_name from ( select * from kylin_sales ) _view_ group by
lstg_format_name ), subRowDim as ( select bb.lstg_format_name, coalesce(
aa.temp, 0 ), row_number() over(order by coalesce( aa.temp, 0 ) asc,
bb.lstg_format_name ) as rn from bb left join aa on bb.lstg_format_name =
aa.lstg_format_name order by 2 asc limit 10 offset 0 ), subColumnDim0 as (
select distinct ops_region from ( select * from kylin_sales ) _view_ ) ,
subDim as ( select * from subColumnDim0 ), subSql as ( select
_view_.ops_region , _view_.lstg_format_name , b.rn, count( distinct buyer_id
) as "# of deaths-32696fdf-c0e1-4e72-a5b9-98aa13b99faa" from (select * from
kylin_sales ) _view_ inner join subRowDim b on _view_.lstg_format_name =
b.lstg_format_name group by _view_.ops_region , _view_.lstg_format_name,
b.rn) , subSql2 as ( select distinct b.ops_region , a.lstg_format_name ,
a.rn from subDim b join subSql a on 1 = 1) select c.ops_region ,
c.lstg_format_name , d."# of deaths-32696fdf-c0e1-4e72-a5b9-98aa13b99faa"
from subSql2 c left join subSql d on c.ops_region = d.ops_region and
c.lstg_format_name = d.lstg_format_name order by ops_region , c.rn LIMIT
50000"

SQL on sample:
with aa as (select	lstg_format_name, count( distinct buyer_id ) as temp from
( select * from kylin_sales ) _view_ where ops_region = 'Shanghai' group by
lstg_format_name ),
bb as (
select lstg_format_name from ( select * from kylin_sales ) _view_
group by lstg_format_name ),
subRowDim as (
select bb.lstg_format_name, coalesce( aa.temp,	0 ), row_number() over(order
by	coalesce( aa.temp,	0 ) asc, bb.lstg_format_name ) as rn
from bb left join aa on	bb.lstg_format_name = aa.lstg_format_name
order by 2 asc
limit 10 offset 0 ),
subColumnDim0 as (
select distinct ops_region from ( select	* from kylin_sales ) _view_ ) ,
subDim as (
select	* from	subColumnDim0 ),
subSql as (
select
	_view_.ops_region ,
	_view_.lstg_format_name ,
	b.rn,
	count( distinct buyer_id ) as "# of
deaths-32696fdf-c0e1-4e72-a5b9-98aa13b99faa"
from (select * from kylin_sales ) _view_
inner join subRowDim b on _view_.lstg_format_name = b.lstg_format_name
group by
	_view_.ops_region ,
	_view_.lstg_format_name,
	b.rn) ,
subSql2 as (
select
	distinct b.ops_region ,
	a.lstg_format_name ,
	a.rn
from subDim b join subSql a on	1 = 1) 
select
	c.ops_region ,
	c.lstg_format_name ,
	d."# of deaths-32696fdf-c0e1-4e72-a5b9-98aa13b99faa"
from subSql2 c
left join subSql d on
c.ops_region = d.ops_region
and c.lstg_format_name = d.lstg_format_name
order by
	ops_region ,
	c.rn;

what's the "null" error mean?

Thanks
Yi

--
Sent from: http://apache-kylin.74782.x6.nabble.com/