The reason we don't see their emails is because they didn't subscribe to dev@ mailing list.
so even they sent emails to dev@, we won't be able to see, only people got CC'd in the mail will see it. That's why Lei has been forwarding their emails. I've redirected this thread discussion to user@ mailing list. We may close this thread on dev@ mailing list for now. -Goden On Fri, Jul 15, 2016 at 11:32 AM Goden Yao <[email protected]> wrote: > We do handle NULL for int and bigint. > based on your error message, it doesn't seem to be a NULL issue but more > data type conversion issue. > > Could you give us: > 1. HAWQ version > 2. external table definition of "gdm_m04_ord_det_sum" > 3. If you can provide us some sample data to reproduce the issue, that'd > be ideal. > > Thanks > -Goden > > On Thu, Jul 14, 2016 at 7:28 PM Lei Chang <[email protected]> wrote: > >> I got the email now, looks there are very big delays here, several hours, >> sometimes. >> >> Thanks >> Lei >> >> >> 2016-07-15 0:50 GMT+08:00 Roman Shaposhnik <[email protected]>: >> >> > You may want to check your spam filter. I saw all these messages. >> > >> > Thanks, >> > Roman. >> > >> > 2016-07-14 6:03 GMT-07:00 Lei Chang <[email protected]>: >> > >> > > >> > > FYI, looks dev mailing list does not get this email. forward to >> dev@hawq >> > > again. >> > > >> > > >> > > ---------- Forwarded message ---------- >> > > From: 吴彪 <[email protected]> >> > > Date: 2016-07-14 19:05 GMT+08:00 >> > > Subject: PXF读取HDFS数据NULL问题 >> > > To: [email protected] >> > > Cc: 周龙波 <[email protected]>, Brian Lu <[email protected]>, Lei Chang < >> > > [email protected]> >> > > >> > > >> > > 你好， >> > > >> > > 在使用PXF读取HDFS数据时遇到以下问题，HDFS上的数据是通过Hive生成的，： >> > > >> > > 1. Hive中String类型的字段有些为NULL，hawq >> 查询会报以下错误；在Hive中把NULL字段处理为非NULL时，在hawq >> > > 中可以正常查询。 >> > > >> > > >> > > >> > > >> > > >> > > 2. Hive中Bigint 类型的字段有些为NULL，hawq 查询会报以下错误： >> > > >> > > >> > > >> > > 请问有比较好的方案可以直接处理带有NULL的数据吗？谢谢 >> > > >> > > >> > > >> > > 吴彪 >> > > >> > > JD.COM 京东 【大数据部-大数据研发部-平台基础研发部】 >> > > >> > > --------------------------------------------------------------- >> > > >> > > 地址：北京市朝阳区北辰世纪中心A座10层 >> > > >> > > 邮编：100195 >> > > >> > > 手机：18810848987 >> > > >> > > 邮箱：*[email protected] <[email protected][email protected]>* >> > > >> > > ---------------------------------------------------------------- >> > > >> > > [image: j39] >> > > >> > > >> > > >> > > >> > > >> >
