8debug opened a new issue #12237:
URL: https://github.com/apache/druid/issues/12237
Please provide a detailed title (e.g. "Broker crashes when using TopN query
with Bound filter" instead of just "Broker crashes").
### Affected Version
druid 1.1.13
### Description
The following is the sql content
```sql
with col_regid as (select first(regid) as regid, INID
from his.OPM_OTHER_INHOSAPPLY_INFO T32
where T32.EXT18 = '0'
AND T32.STATUS <> '3'
group by T32.INID),
col_staticname as (SELECT staticcode, first(staticname) as staticname
FROM his.FIN_STATICCODE_LOCAL
group by staticcode)
SELECT a.orgcode,
a.orgname,
to_date(A.FEEDATE),
first(T32.Regid),
first(i.staticname),
sum(A.TOTCOST - ifnull(A.FEE_DISCOUNT, 0))
FROM his.IPB_ITEMLIST A
left join col_regid T32 on T32.INID = a.INID,
his.OAM_OPERATION_APPLY t
left join col_staticname i on i.staticcode = t.szbm
WHERE a.ORGCODE <> '122'
and to_date(A.FEEDATE) between TO_DATE('2021-07-01') AND date_sub(now(), 1)
and a.inid = t.inid
and t.applystate = '3'
and t.source = '2'
AND t.ORGCODE <> '122'
GROUP BY a.orgcode, a.orgname, to_date(A.FEEDATE), t.szbm, a.INID
```
then execute `System.out.println(SQLUtils.formatHive(sql));`
The output statement is missing ``` his.OAM_OPERATION_APPLY ```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
