Question
Why is it not possible to query a column of the Boolean type?
| paste-code-macro | ||
|---|---|---|
| ||
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?
...
| hidden | true |
|---|
...
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).