Why can't I query a Boolean column?
Question
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?
Answer
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)
.
Found an issue in documentation? Write to us.