com.dremio.common.exceptions.UserException: Source ‘appdb’ returned error ‘Failed getting columns for dap_new_alpha4t.company.’
at com.dremio.common.exceptions.UserException$Builder.build(UserException.java:804)
at com.dremio.exec.store.jdbc.JdbcDatasetMetadata.getColumnMetadata(JdbcDatasetMetadata.java:152)
at com.dremio.exec.store.jdbc.JdbcDatasetMetadata.apiColumnMetadata(JdbcDatasetMetadata.java:107)
at com.dremio.exec.store.jdbc.JdbcDatasetMetadata.build(JdbcDatasetMetadata.java:77)
at com.dremio.exec.store.jdbc.JdbcSchemaFetcherImpl.getTableMetadata(JdbcSchemaFetcherImpl.java:643)
at com.dremio.exec.store.jdbc.JdbcStoragePlugin$JdbcDatasetHandle.getTableMetadataResponse(JdbcStoragePlugin.java:505)
at com.dremio.exec.store.jdbc.JdbcStoragePlugin.listPartitionChunks(JdbcStoragePlugin.java:270)
at com.dremio.exec.catalog.DatasetSaver.save(DatasetSaver.java:94)
at com.dremio.exec.catalog.DatasetSaver.save(DatasetSaver.java:143)
at com.dremio.exec.catalog.DatasetManager.getTableFromPlugin(DatasetManager.java:364)
at com.dremio.exec.catalog.DatasetManager.getTable(DatasetManager.java:209)
at com.dremio.exec.catalog.CatalogImpl.getTable(CatalogImpl.java:194)
at com.dremio.exec.catalog.SourceAccessChecker.lambda$getTable$3(SourceAccessChecker.java:121)
at com.dremio.exec.catalog.SourceAccessChecker.getIfVisible(SourceAccessChecker.java:90)
at com.dremio.exec.catalog.SourceAccessChecker.getTable(SourceAccessChecker.java:121)
at com.dremio.exec.catalog.DelegatingCatalog.getTable(DelegatingCatalog.java:83)
at com.dremio.exec.catalog.CachingCatalog.getTable(CachingCatalog.java:93)
at com.dremio.exec.catalog.DremioCatalogReader.getTable(DremioCatalogReader.java:94)
at com.dremio.exec.catalog.DremioCatalogReader.getTable(DremioCatalogReader.java:71)
at org.apache.calcite.sql.validate.EmptyScope.getTableNamespace(EmptyScope.java:76)
at org.apache.calcite.sql.validate.DelegatingScope.getTableNamespace(DelegatingScope.java:197)
at org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:102)
at org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:120)
at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84)
at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:946)
at org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:927)
at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2983)
at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2968)
at org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:3209)
at org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60)
at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84)
at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:946)
at org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:927)
at org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:226)
at org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:902)
at org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:612)
at com.dremio.exec.planner.sql.SqlConverter.validate(SqlConverter.java:227)
at com.dremio.exec.planner.sql.handlers.PrelTransformer.validateNode(PrelTransformer.java:195)
at com.dremio.exec.planner.sql.handlers.PrelTransformer.validateAndConvert(PrelTransformer.java:180)
at com.dremio.exec.planner.sql.handlers.PrelTransformer.validateAndConvert(PrelTransformer.java:176)
at com.dremio.exec.planner.sql.handlers.query.NormalHandler.getPlan(NormalHandler.java:65)
at com.dremio.exec.planner.sql.handlers.commands.HandlerToExec.plan(HandlerToExec.java:59)
at com.dremio.exec.work.foreman.AttemptManager.plan(AttemptManager.java:457)
at com.dremio.exec.work.foreman.AttemptManager.lambda$run$1(AttemptManager.java:361)
at com.dremio.service.commandpool.CommandWrapper.run(CommandWrapper.java:62)
at com.dremio.context.RequestContext.run(RequestContext.java:95)
at com.dremio.common.concurrent.ContextMigratingExecutorService.lambda$decorate$3(ContextMigratingExecutorService.java:199)
at com.dremio.common.concurrent.ContextMigratingExecutorService$ComparableRunnable.run(ContextMigratingExecutorService.java:180)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLException: (conn=1931631) Illegal mix of collations (utf8_general_ci,COERCIBLE) and (utf8_unicode_ci,COERCIBLE) for operation ‘=’
at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:255)
at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:165)
at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:238)
at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:356)
at org.mariadb.jdbc.MariaDbStatement.executeQuery(MariaDbStatement.java:530)
at org.mariadb.jdbc.MariaDbDatabaseMetaData.executeQuery(MariaDbDatabaseMetaData.java:474)
at org.mariadb.jdbc.MariaDbDatabaseMetaData.getColumns(MariaDbDatabaseMetaData.java:785)
at com.dremio.exec.store.jdbc.dialect.TypeMapper.convertGetColumnsCallToSourceTypeDescriptors(TypeMapper.java:295)
at com.dremio.exec.store.jdbc.dialect.TypeMapper.mapJdbcToArrowFields(TypeMapper.java:104)
at com.dremio.exec.store.jdbc.JdbcDatasetMetadata.lambda$apiColumnMetadata$2(JdbcDatasetMetadata.java:108)
at com.dremio.exec.store.jdbc.JdbcDatasetMetadata.getColumnMetadata(JdbcDatasetMetadata.java:138)
… 49 common frames omitted
Caused by: java.sql.SQLException: Illegal mix of collations (utf8_general_ci,COERCIBLE) and (utf8_unicode_ci,COERCIBLE) for operation ‘=’
Query is: SELECT TABLE_SCHEMA TABLE_CAT, NULL TABLE_SCHEM, TABLE_NAME, COLUMN_NAME, CASE data_type WHEN ‘bit’ THEN -7 WHEN ‘tinyblob’ THEN -3 WHEN ‘mediumblob’ THEN -4 WHEN ‘longblob’ THEN -4 WHEN ‘blob’ THEN -4 WHEN ‘tinytext’ THEN 12 WHEN ‘mediumtext’ THEN -1 WHEN ‘longtext’ THEN -1 WHEN ‘text’ THEN -1 WHEN ‘date’ THEN 91 WHEN ‘datetime’ THEN 93 WHEN ‘decimal’ THEN 3 WHEN ‘double’ THEN 8 WHEN ‘enum’ THEN 12 WHEN ‘float’ THEN 7 WHEN ‘int’ THEN IF( COLUMN_TYPE like ‘%unsigned%’, 4,4) WHEN ‘bigint’ THEN -5 WHEN ‘mediumint’ THEN 4 WHEN ‘null’ THEN 0 WHEN ‘set’ THEN 12 WHEN ‘smallint’ THEN IF( COLUMN_TYPE like ‘%unsigned%’, 5,5) WHEN ‘varchar’ THEN 12 WHEN ‘varbinary’ THEN -3 WHEN ‘char’ THEN 1 WHEN ‘binary’ THEN -2 WHEN ‘time’ THEN 92 WHEN ‘timestamp’ THEN 93 WHEN ‘tinyint’ THEN IF(COLUMN_TYPE like ‘tinyint(1)%’,-7,-6) WHEN ‘year’ THEN 91 ELSE 1111 END DATA_TYPE, IF(COLUMN_TYPE like ‘tinyint(1)%’, ‘BIT’, UCASE(IF( COLUMN_TYPE LIKE ‘%(%)%’, CONCAT(SUBSTRING( COLUMN_TYPE,1, LOCATE(’(’,COLUMN_TYPE) - 1 ), SUBSTRING(CO…
java thread: 1f01552a-3d57-d754-a52f-bf3378988d00/0:foreman-planning
at org.mariadb.jdbc.internal.util.LogQueryTool.exceptionWithQuery(LogQueryTool.java:126)
@balaji.ramaswamy Please help
@Dremio Please help here
@jitenderdheeman It seems like you are comparing 2 columns with different collations?