Cannot extract more than one field from mongodb nested object

1

Hi,
I have a MongoDB collection with a nested field “attributes”. Such field contains attributes that vary from document to document.
When I run a projection query to extract two or more nested attributes, as the following:

SELECT ual.attributes.score AS score, ual.attributes.query AS query FROM UserActivityLog ual

I receive an “UnsupportedOperationException” error.

This is the stack trace:
(java.lang.UnsupportedOperationException) null org.apache.arrow.vector.complex.UnionVector.setSafe():1490
org.apache.arrow.vector.complex.UnionVector.setSafe():1325
com.dremio.s.ProjectorGen43.doEval():39
com.dremio.sabot.op.project.ProjectorTemplate.projectRecords():530:
com.dremio.exec.expr.SplitStageExecutor.evaluateProjector():310
com.dremio.exec.expr.ExpressionSplitter.projectRecords() :422
com.dremio.sabot.op.project.ProjectOperator.outputData() :246
com.dremio.sabot.driver.SmartOp$SmartSingleInput.outputData():188
com.dremio.sabot.driver.StraightPipe.pump():56
com.dremio.sabot.driver.Pipeline.doPump():108
com.dremio.sabot.driver.Pipeline.pumpOnce():98:
com.dremio.sabot.exec.fragment.FragmentExecutor$DoAsPumper.run():341
com.dremio.sabot.exec.fragment.FragmentExecutor.run():290
com.dremio.sabot.exec.fragment.FragmentExecutor.access$1400():94
com.dremio.sabot.exec.fragment.FragmentExecutor$AsyncTaskImpl.run():733
com.dremio.sabot.task.AsyncTaskWrapper.run():112
com.dremio.sabot.task.slicing.SlicingThread.mainExecutionLoop():243
com.dremio.sabot.task.slicing.SlicingThread.run():171

2

@fdellutri Can you please send us the profile?

3

Hi @balaji.ramaswamy,
This is the profile.

Thx

18c537eb-e3ca-4e73-bab5-fd1e5161bf85.zip (15,9 KB)

4

@fdellutri Seems like a known issue, will update in a few days on some status