jxxfxkp opened a new issue #5007:
URL: https://github.com/apache/incubator-doris/issues/5007


   The latest master branch supports presto query doris table.But doris view is 
not supported if this view has an varchar type.
   presto err(mysql jdbc):
   ```
   java.lang.IllegalArgumentException: Invalid VARCHAR length -1
        at 
io.prestosql.spi.type.VarcharType.createVarcharType(VarcharType.java:45)
        at 
io.prestosql.plugin.jdbc.StandardColumnMappings.jdbcTypeToPrestoType(StandardColumnMappings.java:504)
        at 
io.prestosql.plugin.jdbc.BaseJdbcClient.toPrestoType(BaseJdbcClient.java:310)
        at 
io.prestosql.plugin.mysql.MySqlClient.toPrestoType(MySqlClient.java:187)
        at 
io.prestosql.plugin.jdbc.BaseJdbcClient.getColumns(BaseJdbcClient.java:260)
        at 
io.prestosql.plugin.jdbc.ForwardingJdbcClient.getColumns(ForwardingJdbcClient.java:82)
        at 
io.prestosql.plugin.jdbc.jmx.StatisticsAwareJdbcClient.lambda$getColumns$4(StatisticsAwareJdbcClient.java:97)
        at io.prestosql.plugin.jdbc.jmx.JdbcApiStats.wrap(JdbcApiStats.java:35)
        at 
io.prestosql.plugin.jdbc.jmx.StatisticsAwareJdbcClient.getColumns(StatisticsAwareJdbcClient.java:97)
        at 
io.prestosql.plugin.jdbc.CachingJdbcClient.getColumns(CachingJdbcClient.java:112)
        at 
io.prestosql.plugin.jdbc.JdbcMetadata.getTableMetadata(JdbcMetadata.java:199)
        at 
io.prestosql.metadata.MetadataManager.getTableMetadata(MetadataManager.java:485)
        at 
io.prestosql.sql.analyzer.StatementAnalyzer$Visitor.visitTable(StatementAnalyzer.java:1035)
        at 
io.prestosql.sql.analyzer.StatementAnalyzer$Visitor.visitTable(StatementAnalyzer.java:300)
        at io.prestosql.sql.tree.Table.accept(Table.java:53)
        at io.prestosql.sql.tree.AstVisitor.process(AstVisitor.java:27)
        at 
io.prestosql.sql.analyzer.StatementAnalyzer$Visitor.process(StatementAnalyzer.java:315)
        at 
io.prestosql.sql.analyzer.StatementAnalyzer$Visitor.analyzeFrom(StatementAnalyzer.java:2307)
        at 
io.prestosql.sql.analyzer.StatementAnalyzer$Visitor.visitQuerySpecification(StatementAnalyzer.java:1257)
        at 
io.prestosql.sql.analyzer.StatementAnalyzer$Visitor.visitQuerySpecification(StatementAnalyzer.java:300)
        at 
io.prestosql.sql.tree.QuerySpecification.accept(QuerySpecification.java:144)
        at io.prestosql.sql.tree.AstVisitor.process(AstVisitor.java:27)
        at 
io.prestosql.sql.analyzer.StatementAnalyzer$Visitor.process(StatementAnalyzer.java:315)
        at 
io.prestosql.sql.analyzer.StatementAnalyzer$Visitor.process(StatementAnalyzer.java:325)
        at 
io.prestosql.sql.analyzer.StatementAnalyzer$Visitor.visitQuery(StatementAnalyzer.java:910)
        at 
io.prestosql.sql.analyzer.StatementAnalyzer$Visitor.visitQuery(StatementAnalyzer.java:300)
        at io.prestosql.sql.tree.Query.accept(Query.java:107)
        at io.prestosql.sql.tree.AstVisitor.process(AstVisitor.java:27)
        at 
io.prestosql.sql.analyzer.StatementAnalyzer$Visitor.process(StatementAnalyzer.java:315)
        at 
io.prestosql.sql.analyzer.StatementAnalyzer.analyze(StatementAnalyzer.java:292)
        at io.prestosql.sql.analyzer.Analyzer.analyze(Analyzer.java:83)
        at io.prestosql.sql.analyzer.Analyzer.analyze(Analyzer.java:75)
        at 
io.prestosql.execution.SqlQueryExecution.analyze(SqlQueryExecution.java:217)
        at 
io.prestosql.execution.SqlQueryExecution.<init>(SqlQueryExecution.java:176)
        at 
io.prestosql.execution.SqlQueryExecution.<init>(SqlQueryExecution.java:93)
        at 
io.prestosql.execution.SqlQueryExecution$SqlQueryExecutionFactory.createQueryExecution(SqlQueryExecution.java:705)
        at 
io.prestosql.dispatcher.LocalDispatchQueryFactory.lambda$createDispatchQuery$0(LocalDispatchQueryFactory.java:121)
        at io.prestosql.$gen.Presto_333____20201202_081906_2.call(Unknown 
Source)
        at 
com.google.common.util.concurrent.TrustedListenableFutureTask$TrustedFutureInterruptibleTask.runInterruptibly(TrustedListenableFutureTask.java:125)
        at 
com.google.common.util.concurrent.InterruptibleTask.run(InterruptibleTask.java:69)
        at 
com.google.common.util.concurrent.TrustedListenableFutureTask.run(TrustedListenableFutureTask.java:78)
        at 
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
        at 
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
        at java.base/java.lang.Thread.run(Thread.java:834)
   ```


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org

Reply via email to