Resent to see whether you guys can see images in the email
---------------------------------------------------------
你好,
在使用PXF读取HDFS数据时遇到以下问题,HDFS上的数据是通过Hive生成的,:
1. Hive中String类型的字段有些为NULL,hawq 查询会报以下错误;在Hive中把NULL字段处理为非NULL时,在hawq
中可以正常查询。
2. Hive中Bigint 类型的字段有些为NULL,hawq 查询会报以下错误:
请问有比较好的方案可以直接处理带有NULL的数据吗?谢谢
吴彪
JD.COM <http://jd.com/> 京东 【大数据部-大数据研发部-平台基础研发部】
---------------------------------------------------------------
地址:北京市朝阳区北辰世纪中心A座10层
邮编:100195
手机:18810848987
邮箱:*[email protected] <[email protected][email protected]>*
2016-07-15 1:31 GMT+08:00 Goden Yao <[email protected]>:
> Also I cannot see the screenshots attached in the email, can you ask the
> issue reporter to resend (or you can help to resend the picture, Lei?)
>
> On Thu, Jul 14, 2016 at 10:28 AM Goden Yao <[email protected]> wrote:
>
> > I believe the sender needs to be part of dev mailing list to send email.
> >
> >
> > On Thu, Jul 14, 2016 at 6:13 AM Lei Chang <[email protected]> wrote:
> >
> >>
> >> looks our mailing list has some issues, no one see this email. forward
> >> from my apache email.
> >>
> >>
> >> ---------- 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]
> >>
> >>
> >>
> >>
> >>
>