ERROR: collations are not supported by type uuid - Dremio AWS Edition

Hi!

When running a query on dremio, I came across the following error:

DATA_READ ERROR: The JDBC storage plug-in failed when trying to configure the SQL query.

When checking the job profile, I found more details about the error:

(org.postgresql.util.PSQLException) ERROR: collations are not supported by type uuid
  Position: 13
    org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse():2440
    org.postgresql.core.v3.QueryExecutorImpl.processResults():2183
    org.postgresql.core.v3.QueryExecutorImpl.execute():308
    org.postgresql.jdbc.PgStatement.executeInternal():441
    org.postgresql.jdbc.PgStatement.execute():365
    org.postgresql.jdbc.PgStatement.executeWithFlags():307
    org.postgresql.jdbc.PgStatement.executeCachedSql():293
    org.postgresql.jdbc.PgStatement.executeWithFlags():270
    org.postgresql.jdbc.PgStatement.executeQuery():224
    org.apache.commons.dbcp2.DelegatingStatement.executeQuery():206
    org.apache.commons.dbcp2.DelegatingStatement.executeQuery():206
    com.dremio.exec.store.jdbc.JdbcRecordReader.setup():199
    com.dremio.exec.store.CoercionReader.setup():125
    com.dremio.sabot.op.scan.ScanOperator.setupReaderAsCorrectUser():222
    com.dremio.sabot.op.scan.ScanOperator.setupReader():195
    com.dremio.sabot.op.scan.ScanOperator.setup():181
    com.dremio.sabot.driver.SmartOp$SmartProducer.setup():563
    com.dremio.sabot.driver.Pipe$SetupVisitor.visitProducer():79
    com.dremio.sabot.driver.Pipe$SetupVisitor.visitProducer():63
    com.dremio.sabot.driver.SmartOp$SmartProducer.accept():533
    com.dremio.sabot.driver.StraightPipe.setup():102
    com.dremio.sabot.driver.StraightPipe.setup():102
    com.dremio.sabot.driver.StraightPipe.setup():102
    com.dremio.sabot.driver.Pipeline.setup():68
    com.dremio.sabot.exec.fragment.FragmentExecutor.setupExecution():388
    com.dremio.sabot.exec.fragment.FragmentExecutor.run():270
    com.dremio.sabot.exec.fragment.FragmentExecutor.access$1200():92
    com.dremio.sabot.exec.fragment.FragmentExecutor$AsyncTaskImpl.run():674
    com.dremio.sabot.task.AsyncTaskWrapper.run():104
    com.dremio.sabot.task.slicing.SlicingThread.mainExecutionLoop():226
    com.dremio.sabot.task.slicing.SlicingThread.run():156

Has anyone experienced this problem? Would there be a solution?

Thanks!

Hello people! Does anyone know anything about this?

Thanks!

Hi - UUID should be returned as a VARCHAR within Dremio, and for some types to ensure consistency a COLLATION clause is added to them. UUID should not be one of them, so there’s obviously something amiss.

Can you let me know which version of Dremio you’re using, and if this is a clean install or an upgrade?

Hi, I’m using version 4.2.1 - AWS Edition and it’s a clean install.