# ERROR: collations are not supported by type uuid - Dremio AWS Edition **URL:** \ **Category:** Uncategorized\ **Created:** [May 20, 2020, 2:49pm UTC](https://community.dremio.com/t/error-collations-are-not-supported-by-type-uuid-dremio-aws-edition/5586 "2020-05-20T14:49:07Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![l-jhon](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/l-jhon/32/2403_2.png) [@l-jhon](https://community.dremio.com/u/l-jhon)\ **Post date:** [May 20, 2020, 2:49pm UTC](https://community.dremio.com/t/error-collations-are-not-supported-by-type-uuid-dremio-aws-edition/5586/1 "2020-05-20T14:49:07Z")
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! ---
**Author:** ![l-jhon](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/l-jhon/32/2403_2.png) [@l-jhon](https://community.dremio.com/u/l-jhon)\ **Post date:** [June 1, 2020, 5:02pm UTC](https://community.dremio.com/t/error-collations-are-not-supported-by-type-uuid-dremio-aws-edition/5586/2 "2020-06-01T17:02:21Z")
Hello people! Does anyone know anything about this? Thanks! ---
**Author:** ![Kyle\_Porter](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/kyle_porter/32/1881_2.png) [@Kyle\_Porter](https://community.dremio.com/u/Kyle_Porter)\ **Post date:** [June 1, 2020, 5:47pm UTC](https://community.dremio.com/t/error-collations-are-not-supported-by-type-uuid-dremio-aws-edition/5586/3 "2020-06-01T17:47:49Z")
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? ---
**Author:** ![l-jhon](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/l-jhon/32/2403_2.png) [@l-jhon](https://community.dremio.com/u/l-jhon)\ **Post date:** [June 1, 2020, 6:03pm UTC](https://community.dremio.com/t/error-collations-are-not-supported-by-type-uuid-dremio-aws-edition/5586/4 "2020-06-01T18:03:20Z")
Hi, I’m using version 4.2.1 - AWS Edition and it’s a clean install. ---
**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\ **Post date:** [June 2, 2020, 3:00am UTC](https://community.dremio.com/t/error-collations-are-not-supported-by-type-uuid-dremio-aws-edition/5586/5 "2020-06-02T03:00:37Z")
@l-jhon Can you please provide us with the job profile and the create table DDL from Postgres? [Share Dremio Query Profile](https://www.dremio.com/tutorials/share-query-profile-dremio/#:~:text=At%20the%20bottom%20of%20the,issues%20you%20may%20be%20encountering.) Thanks Bali ---
**Author:** ![jamesdouglas](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/jamesdouglas/32/2525_2.png) [@jamesdouglas](https://community.dremio.com/u/jamesdouglas)\ **Post date:** [June 3, 2020, 6:52pm UTC](https://community.dremio.com/t/error-collations-are-not-supported-by-type-uuid-dremio-aws-edition/5586/6 "2020-06-03T18:52:29Z")
Are you connecting to Aurora Postgres Serverless by any chance? ---
**Author:** ![harshal1107](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/harshal1107/32/2547_2.png) [@harshal1107](https://community.dremio.com/u/harshal1107)\ **Post date:** [June 4, 2020, 9:36am UTC](https://community.dremio.com/t/error-collations-are-not-supported-by-type-uuid-dremio-aws-edition/5586/7 "2020-06-04T09:36:09Z")
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] ---
**Author:** ![l-jhon](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/l-jhon/32/2403_2.png) [@l-jhon](https://community.dremio.com/u/l-jhon)\ **Post date:** [December 1, 2020, 5:49pm UTC](https://community.dremio.com/t/error-collations-are-not-supported-by-type-uuid-dremio-aws-edition/5586/8 "2020-12-01T17:49:53Z")
Hi everybody! I still have this problem. Has anyone get to solve? I’m using the latest version of Dremio. ---
**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\ **Post date:** [December 3, 2020, 9:30am UTC](https://community.dremio.com/t/error-collations-are-not-supported-by-type-uuid-dremio-aws-edition/5586/9 "2020-12-03T09:30:24Z")
@l-jhon This is still an open item on our side ---
**Author:** ![l-jhon](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/l-jhon/32/2403_2.png) [@l-jhon](https://community.dremio.com/u/l-jhon)\ **Post date:** [December 4, 2020, 2:40am UTC](https://community.dremio.com/t/error-collations-are-not-supported-by-type-uuid-dremio-aws-edition/5586/10 "2020-12-04T02:40:45Z")
Thanks @balaji.ramaswamy! ---
**Author:** ![Sukku](https://avatars.discourse-cdn.com/v4/letter/s/e0b2c6/32.png) [@Sukku](https://community.dremio.com/u/Sukku)\ **Post date:** [April 30, 2021, 9:21am UTC](https://community.dremio.com/t/error-collations-are-not-supported-by-type-uuid-dremio-aws-edition/5586/11 "2021-04-30T09:21:17Z")
@balaji.ramaswamy , I’m also facing similar problem, is there a fix for the reported issue?