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/

Reply via email to