Why can't I query a Boolean column?


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).

Found an issue in documentation? Write to us.