You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@impala.apache.org by Lars Volker <lv...@cloudera.com> on 2017/01/25 00:14:53 UTC
Do we have a table in 'functional' with negative int/float values?
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
Re: Do we have a table in 'functional' with negative int/float values?
Posted by Lars Volker <lv...@cloudera.com>.
Good to know, thanks for your reply.
On Wed, Jan 25, 2017 at 5:42 AM, Alex Behm <al...@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
> >
>
Re: Do we have a table in 'functional' with negative int/float values?
Posted by Alex Behm <al...@cloudera.com>.
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
>