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 Mon, 18 Jul 2016 18:13:44 GMT
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 <godenyao@apache.org> 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 <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