question Impala where xxx in () list operator not working correctly in Archives of Support Questions (Read Only)

Impala where xxx in () list operator not working correctly

TomasTF — Fri, 16 Sep 2022 09:14:46 GMT

Hi,

running a simple query where in the WHERE condition is a column IN ( ) condition and the list contains 13 elements (numbers).

The column is type of int.

Every time I run a query I got a different result, sometimes 5 rows, sometimes 2 rows, sometimes 10 rows.

Of course I checked ID by ID that all elements are in the table...

is this a known bug or I am missing something?

select * from tmp_ext_item where item_id in ( 3040607, 5645020, 69772482, 2030547, 1753459, 9972822, 1846553, 6098104, 1874789, 1834370, 1829598, 1779239, 7932306 )

Re: Impala where xxx in () list operator not working correctly

TomasTF — Wed, 10 Dec 2014 12:59:31 GMT

During my test I came to one (maybe not correct) conclusion.

The table is big and partitioned, and maybe Impala just limits the query to a subset of a table.

Because if I change the query like

create table result as

select * from tmp_ext_item where item_id in ( 3040607, 5645020, 69772482, 2030547, 1753459, 9972822, 1846553, 6098104, 1874789, 1834370, 1829598, 1779239, 7932306 )

then it runs correctly and returns all items with the specified item_id.