You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2020/10/14 16:29:15 UTC
[GitHub] [incubator-superset] tooptoop4 opened a new issue #11267: Explore filter on presto 'timestamp with time zone' type is invalid
tooptoop4 opened a new issue #11267:
URL: https://github.com/apache/incubator-superset/issues/11267
superset 0.36, presto 336
presto table has column with below data type:
datetime_value timestamp with time zone
Explore tab in superset generates this bad filter
WHERE "datetime_value" >= '1920-10-14 00:00:00.000000'
presto doesn't like it
io.prestosql.spi.PrestoException: line 19:24: '>=' cannot be applied to timestamp with time zone, varchar(26)
at io.prestosql.sql.analyzer.SemanticExceptions.semanticException(SemanticExceptions.java:48)
at io.prestosql.sql.analyzer.SemanticExceptions.semanticException(SemanticExceptions.java:43)
at io.prestosql.sql.analyzer.ExpressionAnalyzer$Visitor.getOperator(ExpressionAnalyzer.java:1435)
at io.prestosql.sql.analyzer.ExpressionAnalyzer$Visitor.visitComparisonExpression(ExpressionAnalyzer.java:520)
at io.prestosql.sql.analyzer.ExpressionAnalyzer$Visitor.visitComparisonExpression(ExpressionAnalyzer.java:333)
at io.prestosql.sql.tree.ComparisonExpression.accept(ComparisonExpression.java:71)
at io.prestosql.sql.tree.StackableAstVisitor.process(StackableAstVisitor.java:27)
at io.prestosql.sql.analyzer.ExpressionAnalyzer$Visitor.process(ExpressionAnalyzer.java:356)
at io.prestosql.sql.analyzer.ExpressionAnalyzer.analyze(ExpressionAnalyzer.java:294)
at io.prestosql.sql.analyzer.ExpressionAnalyzer.analyzeExpression(ExpressionAnalyzer.java:1644)
at io.prestosql.sql.analyzer.StatementAnalyzer$Visitor.analyzeExpression(StatementAnalyzer.java:2455)
at io.prestosql.sql.analyzer.StatementAnalyzer$Visitor.analyzeWhere(StatementAnalyzer.java:2316)
at io.prestosql.sql.analyzer.StatementAnalyzer$Visitor.lambda$visitQuerySpecification$19(StatementAnalyzer.java:1286)
at java.base/java.util.Optional.ifPresent(Unknown Source)
at io.prestosql.sql.analyzer.StatementAnalyzer$Visitor.visitQuerySpecification(StatementAnalyzer.java:1286)
at io.prestosql.sql.analyzer.StatementAnalyzer$Visitor.visitQuerySpecification(StatementAnalyzer.java:306)
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:323)
at io.prestosql.sql.analyzer.StatementAnalyzer$Visitor.process(StatementAnalyzer.java:333)
at io.prestosql.sql.analyzer.StatementAnalyzer$Visitor.visitQuery(StatementAnalyzer.java:918)
at io.prestosql.sql.analyzer.StatementAnalyzer$Visitor.visitQuery(StatementAnalyzer.java:306)
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:323)
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:237)
at io.prestosql.execution.SqlQueryExecution.<init>(SqlQueryExecution.java:183)
at io.prestosql.execution.SqlQueryExecution$SqlQueryExecutionFactory.createQueryExecution(SqlQueryExecution.java:737)
at io.prestosql.dispatcher.LocalDispatchQueryFactory.lambda$createDispatchQuery$0(LocalDispatchQueryFactory.java:121)
at io.prestosql.$gen.Presto_1c5b75e_dirty____20200924_104517_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(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.base/java.lang.Thread.run(Unknown Source)
----------------------------------------------------------------
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:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] villebro commented on issue #11267: Explore filter on presto 'timestamp with time zone' type is invalid
Posted by GitBox <gi...@apache.org>.
villebro commented on issue #11267:
URL: https://github.com/apache/incubator-superset/issues/11267#issuecomment-713881491
Hmm, these types of problems should have been fixed in 0.35.2 already. What is generating the time filter? A filter box from a different datasource? or a manually entered adhoc filter?
----------------------------------------------------------------
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:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] issue-label-bot[bot] commented on issue #11267: Explore filter on presto 'timestamp with time zone' type is invalid
Posted by GitBox <gi...@apache.org>.
issue-label-bot[bot] commented on issue #11267:
URL: https://github.com/apache/incubator-superset/issues/11267#issuecomment-708516232
Issue-Label Bot is automatically applying the label `#bug` to this issue, with a confidence of 0.96. Please mark this comment with :thumbsup: or :thumbsdown: to give our bot feedback!
Links: [app homepage](https://github.com/marketplace/issue-label-bot), [dashboard](https://mlbot.net/data/apache/incubator-superset) and [code](https://github.com/hamelsmu/MLapp) for this bot.
----------------------------------------------------------------
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:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] tooptoop4 commented on issue #11267: Explore filter on presto 'timestamp with time zone' type is invalid
Posted by GitBox <gi...@apache.org>.
tooptoop4 commented on issue #11267:
URL: https://github.com/apache/incubator-superset/issues/11267#issuecomment-708638657
@villebro do u know which commit?
----------------------------------------------------------------
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:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] villebro closed issue #11267: Explore filter on presto 'timestamp with time zone' type is invalid
Posted by GitBox <gi...@apache.org>.
villebro closed issue #11267:
URL: https://github.com/apache/incubator-superset/issues/11267
----------------------------------------------------------------
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:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] tooptoop4 commented on issue #11267: Explore filter on presto 'timestamp with time zone' type is invalid
Posted by GitBox <gi...@apache.org>.
tooptoop4 commented on issue #11267:
URL: https://github.com/apache/incubator-superset/issues/11267#issuecomment-708516376
![image](https://user-images.githubusercontent.com/33283496/96018129-c8893e00-0e42-11eb-93dc-189715da3f91.png)
----------------------------------------------------------------
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:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] villebro commented on issue #11267: Explore filter on presto 'timestamp with time zone' type is invalid
Posted by GitBox <gi...@apache.org>.
villebro commented on issue #11267:
URL: https://github.com/apache/incubator-superset/issues/11267#issuecomment-741619708
@tooptoop4 are you able to test on the latest release (0.38.0)?
----------------------------------------------------------------
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:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] tooptoop4 commented on issue #11267: Explore filter on presto 'timestamp with time zone' type is invalid
Posted by GitBox <gi...@apache.org>.
tooptoop4 commented on issue #11267:
URL: https://github.com/apache/incubator-superset/issues/11267#issuecomment-741401379
that filter is defaulted somehow, I just click explore from sql lab @villebro
----------------------------------------------------------------
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:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] villebro commented on issue #11267: Explore filter on presto 'timestamp with time zone' type is invalid
Posted by GitBox <gi...@apache.org>.
villebro commented on issue #11267:
URL: https://github.com/apache/incubator-superset/issues/11267#issuecomment-708546358
This functionality has been fixed in the latest release, I recommend upgrading.
----------------------------------------------------------------
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:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org