I discovered what I think is a bug, when I was trying to do some operations on a filtered data source in Tableau.
It seems to be an issue when I try to create an exclude filter when using the windows driver, and it seems that the mac osx driver and the windows driver creates two different queries for the same operation.
Mac osx:
SELECT lindorff
.CustomerType
AS CustomerType
,
lindorff
.LedgerGroup
AS LedgerGroup
,
lindorff
.RevenueCategory
AS RevenueCategory
,
SUM( lindorff
.NetAmount
) AS sum:NetAmount:ok
FROM dremio_nas.dremio_nas
.lindorff
lindorff
WHERE ( ( NOT ( ( ( lindorff
.Dim1
>= ‘1502’) AND ( lindorff
.Dim1
<= ‘1609’)) OR ( ( lindorff
.Dim1
>= ‘1711’) AND ( lindorff
.Dim1
<= ‘2012’)))) AND ( lindorff
.FileType
= ‘tot’))
GROUP BY lindorff
.CustomerType
,
lindorff
.LedgerGroup
,
lindorff
.RevenueCategory
Windows:
SELECT “lindorff”.“CustomerType” AS “CustomerType”,
“lindorff”.“RevenueCategory” AS “RevenueCategory”,
SUM( “lindorff”.“NetAmount”) AS “sum_NetAmount_ok”
FROM “dremio_nas.dremio_nas”.“lindorff” “lindorff”
WHERE ( ( NOT ( “lindorff”.“Dim1” NOT IN ( ‘1701’, ‘1611’, ‘1710’, ‘1610’, ‘1612’, ‘1702’, ‘1705’, ‘1703’, ‘1707’, ‘1706’, ‘1704’, ‘1709’, ‘1708’))) AND ( “lindorff”.“FileType” = ‘tot’))
GROUP BY “lindorff”.“CustomerType”,
“lindorff”.“RevenueCategory”