# Concatenation of character literasl fails.org.apache.calcite.sql2rel.ReflectiveConvertletTable$1.convertCall

**URL:** <https://community.dremio.com/t/concatenation-of-character-literasl-fails-org-apache-calcite-sql2rel-reflectiveconvertlettable-1-convertcall/7123>\
**Category:** Uncategorized\
**Created:** [March 14, 2021, 10:36pm UTC](https://community.dremio.com/t/concatenation-of-character-literasl-fails-org-apache-calcite-sql2rel-reflectiveconvertlettable-1-convertcall/7123 "2021-03-14T22:36:27Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![dqmdev](https://avatars.discourse-cdn.com/v4/letter/d/82dd89/32.png) [@dqmdev](https://community.dremio.com/u/dqmdev)\
**Post date:** [March 14, 2021, 10:36pm UTC](https://community.dremio.com/t/concatenation-of-character-literasl-fails-org-apache-calcite-sql2rel-reflectiveconvertlettable-1-convertcall/7123/1 "2021-03-14T22:36:27Z")

</div>

Dremio server 14.0.0-202103011714040666-9a0c2e10  
Deremio JDBC driver 14.0.0-202103011714040666-9a0c2e10

select rnum, ‘๛’ || c1 from cert.tlth where rnum = 47

PLAN ERROR: while converting ‘๛’ || `tlth`.`c1`

SQL Query select rnum, ‘๛’ || c1 from cert.tlth where rnum = 47

[Error Id: 1a3c097c-0da2-4f10-b440-76c87a8f0888 on 172.31.61.147:31010]

(java.lang.RuntimeException) while converting ‘๛’ || `tlth`.`c1`  
org.apache.calcite.sql2rel.ReflectiveConvertletTable$1.convertCall():90  
org.apache.calcite.sql2rel.SqlNodeToRexConverterImpl.convertCall():63  
org.apache.calcite.sql2rel.SqlToRelConverter$Blackboard.visit():4667  
org.apache.calcite.sql2rel.SqlToRelConverter$Blackboard.visit():4005  
org.apache.calcite.sql.SqlCall.accept():138  
org.apache.calcite.sql2rel.SqlToRelConverter$Blackboard.convertExpression():4569  
org.apache.calcite.sql2rel.SqlToRelConverter.convertSelectList():3848  
org.apache.calcite.sql2rel.SqlToRelConverter.convertSelectImpl():663  
org.apache.calcite.sql2rel.SqlToRelConverter.convertSelect():620  
org.apache.calcite.sql2rel.SqlToRelConverter.convertQueryRecursive():3073  
org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery():556  
com.dremio.exec.planner.sql.SqlConverter.toConvertibleRelRoot():325  
com.dremio.exec.planner.sql.SqlConverter.toConvertibleRelRoot():308  
com.dremio.exec.planner.sql.handlers.PrelTransformer.toConvertibleRelRoot():921  
com.dremio.exec.planner.sql.handlers.PrelTransformer.convertToRelRoot():1006  
com.dremio.exec.planner.sql.handlers.PrelTransformer.convertToRel():1035  
com.dremio.exec.planner.sql.handlers.PrelTransformer.validateAndConvert():186  
com.dremio.exec.planner.sql.handlers.PrelTransformer.validateAndConvert():176  
com.dremio.exec.planner.sql.handlers.query.NormalHandler.getPlan():47  
com.dremio.exec.planner.sql.handlers.commands.HandlerToExec.plan():59  
com.dremio.exec.work.foreman.AttemptManager.plan():457  
com.dremio.exec.work.foreman.AttemptManager.lambda$run$1():361  
com.dremio.service.commandpool.CommandWrapper.run():62  
com.dremio.context.RequestContext.run():95  
com.dremio.common.concurrent.ContextMigratingExecutorService.lambda$decorate$3():199  
com.dremio.common.concurrent.ContextMigratingExecutorService$ComparableRunnable.run():180  
java.util.concurrent.ThreadPoolExecutor.runWorker():1149  
java.util.concurrent.ThreadPoolExecutor$Worker.run():624  
java.lang.Thread.run():748  
Caused By (java.lang.reflect.InvocationTargetException) null  
sun.reflect.GeneratedMethodAccessor315.invoke():-1  
…  
Caused By (org.apache.calcite.runtime.CalciteException) Failed to encode ‘๛’ in character set ‘ISO-8859-1’  
sun.reflect.GeneratedConstructorAccessor292.newInstance():-1  
sun.reflect.DelegatingConstructorAccessorImpl.newInstance():45

---

<div class="post-metadata">

**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:** [March 15, 2021, 3:45am UTC](https://community.dremio.com/t/concatenation-of-character-literasl-fails-org-apache-calcite-sql2rel-reflectiveconvertlettable-1-convertcall/7123/2 "2021-03-15T03:45:50Z")

</div>

@dqmdev

We are targeting a fix for this later this month

This only fixes the case that we have utf8 or utf16 encoded strings as literals in the SQL statement. As for the actual data, Dremio only supports utf8 encoded varchar columns. Anything other than utf-8 is not supported