kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Francis Liang <>
Subject 答复: Extend Column Is Empty
Date Mon, 05 Nov 2018 09:20:49 GMT
Actually you need at least one aggregation, such as sum(lost_day_cnt), or you may try select
a, b from table group by a, b, which should not be the normal case however. Hope this makes
sense. Best, Feng.

发件人: 宋海涛<>
发送时间: 2018年11月5日 17:16
主题: 答复: Extend Column Is Empty

select zone, data_from,ent_name,org_no, org_name, goods_id,goods_spec, big_mc,mid_mc,sma_mc,mini_mc,lost_day_cnt,
from gjst.st_goods_lost_monitor_detail_day  where dt='20181102' and
zone='西南平台' and data_from='haitang' and org_no='16208'

发件人: Francis Liang []
发送时间: 2018年11月5日 17:14
主题: 答复: Extend Column Is Empty

Could you share your sql statement? Thanks. Best, Feng.

发件人: 宋海涛 <>
发送时间: Monday, November 5, 2018 4:58:53 PM
主题: Extend Column Is Empty

Hi guys,

         When I run a SQL which contains extended columns, I got empty values for extended
columns . Anyone knows why?
For example , ENT_NAME and ORG_NAME are extended column based on DATA_FROM and ORG_NO:

Thanks a lot.


View raw message