答复: Extend Column Is Empty

[Francis Liang]

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.

发件人: 宋海涛<mailto:hts...@gaojihealth.com>
发送时间: 2018年11月5日 17:16
收件人: user@kylin.apache.org<mailto:user@kylin.apache.org>
主题: 答复: 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,
lost_amt,avg_paid_in_amt,dt
from gjst.st_goods_lost_monitor_detail_day  where dt='20181102' and
zone='西南平台' and data_from='haitang' and org_no='16208'

发件人: Francis Liang [mailto:soulvagr...@hotmail.com]
发送时间: 2018年11月5日 17:14
收件人: user@kylin.apache.org
主题: 答复: Extend Column Is Empty

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


发件人: 宋海涛 <hts...@gaojihealth.com>
发送时间: Monday, November 5, 2018 4:58:53 PM
收件人: user@kylin.apache.org
主题: 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:
[cid:image001.png@01D4752B.489B5550]

Thanks a lot.

Leo