Hi, i’m using dremio 13.1.0 on elasticsearch 6.8.14.
Simple aggregation query like
select count() from elastic-index
fails, because:
“AssertionError: Relational expression should override copy. Class=[class com.dremio.plugins.elastic.planning.rels.ElasticScanPrel]; traits=[PHYSICAL.ANY([]).[]]; desired traits=[PHYSICAL.SINGLETON([]).[]]”
But adding the “distinct”:
select count(distinct ) from elastic-index
the problem disappear
Profiles:
count_distinct_cig.zip (34,3 KB) count_cig.zip (8,4 KB)
index mapping:
mapping.zip (750 Byte)