PowerBI Connector ODBC error when the column name has dot character "."

1

Hello,
I’m trying to connect to a table which has one or more column names with a dot “.” in it. Unfortunately this results in an error DataSource-error:

DataSource.Error: ODBC: ERROR [HY000] [Dremio][Connector] (1040) Dremio failed to execute the query:

[30038]Query execution error. Details:[ 
SYSTEM ERROR: UnsupportedOperationException: Unhandled field reference "server.sql.edition"; a field reference identifier must not have the form of a qualified name (i.e., with ".").

(java.lang.UnsupportedOperationException) Unhandled field reference "server.sql.edition"; a field reference identifier must not have the form of a qualified name (i.e., with ".").
    com.dremio.common.expression.FieldReference.validate():58
    com.dremio.common.expression.FieldReference.<init>():39
    com.dremio.common.expression.FieldReference.<init>():35
    com.dremio.sabot.op.project.ProjectOperator.getExpressionList():291
    com.dremio.sabot.op.project.ProjectOperator.setup():110
    com.dremio.sabot.driver.SmartOp$SmartSingleInput.setup():260
    com.dremio.sabot.driver.Pipe$SetupVisitor.visitSingleInput():73
    com.dremio.sabot.driver.Pipe$SetupVisitor.visitSingleInput():63
    com.dremio.sabot.driver.SmartOp$SmartSingleInput.accept():205
    com.dremio.sabot.driver.StraightPipe.setup():103
    com.dremio.sabot.driver.StraightPipe.setup():102
    com.dremio.sabot.driver.Pipeline.setup():68
    com.dremio.sabot.exec.fragment.FragmentExecutor.setupExecution():358
    com.dremio.sabot.exec.fragment.FragmentExecutor.run():248
    com.dremio.sabot.exec.fragment.FragmentExecutor.access$1000():93
    com.dremio.sabot.exec.fragment.FragmentExecutor$AsyncTaskImpl.run():619
    com.dremio.sabot.task.AsyncTaskWrapper.run():103
    com.dremio.sabot.task.slicing.SlicingThread.mainExecutionLoop():123
    com.dremio.sabot.task.slicing.SlicingThread.run():68

]

As Elasticsearch uses fields with dots in them by default (albeit as nested objects in JSON documents), I’m hoping there’s a way of working with this. Even more so considering they’re promoting the use of the Elastic Common Schema.

I’m using the latest version of the ODBC connector (1.3.22.1055) and Power BI desktop version 2.66.5376.2521 64-bit (februari 2019).

Thanks in advance!

Best,
Allard

2

Hello @allardt,

What source is this dataset part of? Elasticsearch? Please share a profile of the failed query if possible.

3

Sure thing! I’ve attached the query profile, but removed anything that could be related to our company. These were mostly connection things anyway, in which there is no issue. The source is indeed Elasticsearch.query_profile.zip (10,5 KB)