impala-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lars Volker ...@cloudera.com>
Subject Re: Do we have a table in 'functional' with negative int/float values?
Date Thu, 26 Jan 2017 14:50:24 GMT
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
> >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message