Dremio ODBC connector to Elasticsearch. QlikView support

1

Hello,

I’m trying to connect Qlik View v.12 via Dremio ODBC connector with Direct Discovery option to Elasticsearch. Unfortunately, it fails with exception:

ERROR com.dremio.sabot.driver.SmartOp - UnsupportedOperationException: Map, List and Union should not be used in group by, order by or in a comparison operator. Dremio does not support compare between list and list.
com.dremio.common.exceptions.UserException: UnsupportedOperationException: Map, List and Union should not be used in group by, order by or in a comparison operator. Dremio does not support compare between list and list.

I’ve tried the same scenario for Qlik Sense and it works. Do you support Qlik View? Are there any differences between qlik view and qlik sense in terms of Dremio connector?

Thank you for your answers in advance!

2

The connector should work with both but you cannot use columns with complex types (like a list) for group by operations, so you might to check your list of dimensions and measures to prevent this.

Alternatively, you might want to not query your elastic source directly, and instead use a virtual dataset to flatten your dataset.

3

Thank you for your quick answer. Could you please provide more info or link about virtual dataset?

4

Here’s the documentation about working with virtual datasets: https://docs.dremio.com/working-with-datasets/virtual-datasets.html

5

Here’s a tutorial that may also be helpful: https://www.dremio.com/tutorials/data-curation-with-dremio/