hawq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Goden Yao <goden...@apache.org>
Subject Re: PXF读取HDFS数据NULL问题
Date Fri, 15 Jul 2016 18:32:03 GMT
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 <lei_chang@apache.org> 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 <roman@shaposhnik.org>:
>
> > 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 <lchang@pivotal.io>:
> >
> > >
> > > FYI, looks dev mailing list does not get this email. forward to
> dev@hawq
> > > again.
> > >
> > >
> > > ---------- Forwarded message ----------
> > > From: 吴彪 <sywubiao@jd.com>
> > > Date: 2016-07-14 19:05 GMT+08:00
> > > Subject: PXF读取HDFS数据NULL问题
> > > To: dev@hawq.incubator.apache.org
> > > Cc: 周龙波 <zhoulongbo@jd.com>, Brian Lu <blu@pivotal.io>, Lei
Chang <
> > > lchang@pivotal.io>
> > >
> > >
> > > 你好,
> > >
> > >        在使用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
> > >
> > > 邮箱:*sywubiao@jd.com <sywubiao@jd.com?subject=sywubiao@jd.com>*
> > >
> > > ----------------------------------------------------------------
> > >
> > > [image: j39]
> > >
> > >
> > >
> > >
> >
>
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message