Mailing-List: contact dev-help@impala.incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@impala.incubator.apache.org
MIME-Version: 1.0
In-Reply-To: <CAMvjXi-P55HbvYbc_RpjSuqwPQpEYCG46zLNK+jC+ccFfPqmBg@mail.gmail.com>
References: <CAM_aD9dYX=hjJ=uoBs04SfoWvLjzMft++tFNKqY6Cv1ZvkCYCA@mail.gmail.com>
 <CAMvjXi-P55HbvYbc_RpjSuqwPQpEYCG46zLNK+jC+ccFfPqmBg@mail.gmail.com>
From: Lars Volker <lv@cloudera.com>
Date: Thu, 26 Jan 2017 15:50:24 +0100
Message-ID: <CAM_aD9fPiwtxAFQboGXHhCcQkvPpYE=a9TrR263rTsOjaVR8jA@mail.gmail.com>
Subject: Re: Do we have a table in 'functional' with negative int/float values?
To: dev@impala.incubator.apache.org
Cc: dev@impala.apache.org
Content-Type: multipart/alternative; boundary=001a113de9568d76ce0547007a92
archived-at: Thu, 26 Jan 2017 14:51:13 -0000

--001a113de9568d76ce0547007a92
Content-Type: text/plain; charset=UTF-8

Good to know, thanks for your reply.

On Wed, Jan 25, 2017 at 5:42 AM, Alex Behm <alex.behm@cloudera.com> wrote:

> I don't think we have a test table in 'functional' with negative values.
>
> As far as I can tell, the table 'functional.overflow' is a text table that
> contains values that are larger/smaller than the maximum/minimum type
> declare for that column.
> When overflowing during a text scan, Impala will materialize the max value
> for that column (based on the column type in the schema), whereas Hive will
> return NULL or -Infinity.
> So I'd say the behavior you are seeing is expected.
>
> Alex
>
> On Tue, Jan 24, 2017 at 4:14 PM, Lars Volker <lv@cloudera.com> wrote:
>
> > Hi all,
> >
> > while writing tests for IMPALA-3909 I tried to find a test table in
> > 'functional' that has non-pathologic negative integer and float values
> but
> > couldn't find one. Does anyone know of a table with negative values in
> it?
> >
> > I did find functional.overflow, but Hive returns NULL when querying it.
> Is
> > that expected or a Hive bug?
> >
> > Thanks a lot, Lars
> >
>

--001a113de9568d76ce0547007a92--