The result of TPC-DS query 11 in Impala is wrong. It lost a record :
"AAAAAAAAOPDLAAAA | Ann | Pence N"
I'm using tpcds 1g validation dataset generated by command:
"./dsdgen -sc 1 -terminate N -validate Y"
Attachments are the query string, result of Impala and tpc-ds answer set.
Note: I have also run this query in PostgreSQL and it gives the same result as tpc-ds result set.