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

1

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!

1 Like
2

Hello people! Does anyone know anything about this?

Thanks!

3

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?

4

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

5

@l-jhon

Can you please provide us with the job profile and the create table DDL from Postgres?

Share Dremio Query Profile

Thanks
Bali

6

Are you connecting to Aurora Postgres Serverless by any chance?

7

facing similar kind of issue
‘ERROR: collations are not supported by type bigint[] Position: 378’
I am connecting to RDS postgres service .
All table schemas which have array type , are failing .

DDL statement :
CREATE TABLE “public”.“series” (
“seriesId” int8 NOT NULL,
“eventTimestamp” timestamp NOT NULL,
“eventTimestampSys” int8 NOT NULL,
“companyId” int8 NOT NULL,
“name” text NOT NULL,
“createdBy” text NOT NULL,
“state” text,
“visibility” text,
“expiryTime” timestamp,
“startTime” timestamp,
“creationTime” timestamp,
“entities” _int8,
“createdByName” text,
“publishedGamesCount” int4,
“companyIdPartition” int8,
“partitionkey” int8
)

“entities” _int8 -> array[BigInt]

8

Hi everybody!
I still have this problem. Has anyone get to solve? I’m using the latest version of Dremio.

9

@l-jhon

This is still an open item on our side

10

Thanks @balaji.ramaswamy!

11

@balaji.ramaswamy , I’m also facing similar problem, is there a fix for the reported issue?