Why can't I query a Boolean column?

Owned by Lukasz Wiktor (Deactivated)
Last updated: Aug 02, 2022 by Jan Panoušek
1 min read

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.