郭佳铃 created KYLIN-4783:
--------------------------
Summary: jdbc调用sql不添加limit报错
Key: KYLIN-4783
URL: https://issues.apache.org/jira/browse/KYLIN-4783
Project: Kylin
Issue Type: Bug
Environment: Version：Kylin 2.6.5
Reporter: 郭佳铃
Version：Kylin 2.6.5
I found that if I exec SQL like
【select
T59780.F1126 as F59781,
'_Insight_Total' as F59782,
case
when ( sum(T59780.F1152) - sum(T59780.F1163) ) = 0 then 0
else ( sum(case
when T59780.F1169='1' then T59780.F1165
else 0
end) + sum( case
when T59780.F1169='1' then T59780.F1167 + T59780.F1168
else 0
end) ) / ( sum(T59780.F1152) - sum(T59780.F1163) )
end as F59783
from
(select
T1199.COMNAME1 as F1112,
T1198.PT as F1126,
T1198.CHGNTPREMIUM as F1152,
T1198.NODUTYNTPREMIUM as F1163,
T1198.CATASTROPHEFLAG as F1169,
T1198.YJ_SUMLOSS as F1165,
T1198.WJ_SUMLOSS as F1167,
T1198.WJ_SUMCLAIM as F1168
from
STAT_NOCAR_ADS_HIVE.ADS_PROP_STATEMENT_DF T1198
left outer join
STAT_NOCAR_DIM_HIVE.DIM_NOCAR_COMPANYLEVEL T1199
on T1198.COMCODE = T1199.COMCODE
where
T1199.COMCODE1 IN (
'05000000'
)
and T1198.PT ='2020-08-30') T59780
group by
T59780.F1126 】
it will fail.
But if I add "limit 10000" to the sql，it will success. Such as
【 select select T59780.F1126 as F59781, '_Insight_Total' as
F59782, case when ( sum(T59780.F1152) - sum(T59780.F1163) ) =
0 then 0 else ( sum(case when T59780.F1169='1' then
T59780.F1165 else 0 end) + sum( case
when T59780.F1169='1' then T59780.F1167 + T59780.F1168 else 0
end) ) / ( sum(T59780.F1152) - sum(T59780.F1163) ) end as F59783
from (select T1199.COMNAME1 as F1112, T1198.PT
as F1126, T1198.CHGNTPREMIUM as F1152,
T1198.NODUTYNTPREMIUM as F1163, T1198.CATASTROPHEFLAG as F1169,
T1198.YJ_SUMLOSS as F1165, T1198.WJ_SUMLOSS as F1167,
T1198.WJ_SUMCLAIM as F1168 from
STAT_NOCAR_ADS_HIVE.ADS_PROP_STATEMENT_DF T1198 left outer join
STAT_NOCAR_DIM_HIVE.DIM_NOCAR_COMPANYLEVEL T1199 on
T1198.COMCODE = T1199.COMCODE where T1199.COMCODE1 IN (
'05000000' ) and T1198.PT ='2020-08-30') T59780
group by T59780.F1126 limit 100000】
I would like to know why. Is it normal？
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
