Hello,
Probably Im doing something wrong...
Im trying to create a question with variable date filter.
select
count(1)
from
table
where
created_date_brt = {{created_date_brt}}
Presto show the following message:
com.facebook.presto.spi.PrestoException: Formatted query does not parse: Query{queryBody=QuerySpecification{select=Select{distinct=false, selectItems=["count"(1)]}, from=Optional[Table{raw_courier_api.order}], where=(created_date_brt = ?), groupBy=Optional.empty, having=null, orderBy=Optional.empty, offset=null, limit=null}, orderBy=Optional.empty}
at com.facebook.presto.sql.SqlFormatterUtil.getFormattedSql(SqlFormatterUtil.java:44)
at com.facebook.presto.execution.PrepareTask.execute(PrepareTask.java:71)
at com.facebook.presto.execution.PrepareTask.execute(PrepareTask.java:39)
at com.facebook.presto.execution.DataDefinitionExecution.start(DataDefinitionExecution.java:213)
at com.facebook.presto.$gen.Presto_0_263_SNAPSHOT_8478c37____20211112_190525_1.run(Unknown Source)
at com.facebook.presto.execution.SqlQueryManager.createQuery(SqlQueryManager.java:266)
at com.facebook.presto.dispatcher.LocalDispatchQuery.lambda$startExecution$7(LocalDispatchQuery.java:192)
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)
The query executed on Presto was:
PREPARE statement7 FROM -- Metabase:: userID: 2 queryType: native queryHash: 796b7243019213fd9c38481d0200180a2c0c81f5563fb589d724c970e4dfee96
select
count(1)
from
table
where
created_date_brt = ?