kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Francis Liang <soulvagr...@hotmail.com>
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.

发件人: 宋海涛<mailto:htsong@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:soulvagrant@hotmail.com]
发送时间: 2018年11月5日 17:14
收件人: user@kylin.apache.org
主题: 答复: Extend Column Is Empty

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


发件人: 宋海涛 <htsong@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

Mime
View raw message