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:[email protected]> 发送时间: 2018年11月5日 17:16 收件人: [email protected]<mailto:[email protected]> 主题: 答复: 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:[email protected]] 发送时间: 2018年11月5日 17:14 收件人: [email protected] 主题: 答复: Extend Column Is Empty Could you share your sql statement? Thanks. Best, Feng. 发件人: 宋海涛 <[email protected]> 发送时间: Monday, November 5, 2018 4:58:53 PM 收件人: [email protected] 主题: 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:[email protected]] Thanks a lot. Leo
