Why is it not possible to query a column of the Boolean type?
datamartQuery.select("Distributor", "distributor") |
Distributor
is a Boolean and when I run the query then it returns null
and the following warning:
Invalid datamart query: [distributor] Projection invalid for rollup: Distributor
Is there any workaround for that?
The solution is to disable the rollup. You can do it by passing false
in the second parameter to DatamartContext.newQuery(Table table, boolean rollup)
.