Question with dashboard filter on Boolean filed not working

Get Help
1

Hi, I have a dashboard filter applied on a boolean field. The filter is working for 90% of the question but some of them are not working with the following error (see screenshot). I am simply writing "True" or "False" in the filter.

image
image1010×246 20.4 KB

Thanks !

{
  "browser-info": {
    "language": "en-GB",
    "platform": "MacIntel",
    "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.90 Safari/537.36",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.10+9",
    "java.vendor": "AdoptOpenJDK",
    "java.vendor.url": "https://adoptopenjdk.net/",
    "java.version": "11.0.10",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.10+9",
    "os.name": "Linux",
    "os.version": "4.14.200-155.322.amzn2.x86_64",
    "user.language": "en",
    "user.timezone": "GMT"
  },
  "metabase-info": {
    "databases": [
      "bigquery"
    ],
    "hosting-env": "unknown",
    "application-database": "postgres",
    "application-database-details": {
      "database": {
        "name": "PostgreSQL",
        "version": "11.7"
      },
      "jdbc-driver": {
        "name": "PostgreSQL JDBC Driver",
        "version": "42.2.18"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2021-03-17",
      "tag": "v1.38.2",
      "branch": "release-x.38.x",
      "hash": "91f0ed6"
    },
    "settings": {
      "report-timezone": null
    }
  }
}
2

Hi @anton1
Please post the entire stacktrace from Admin > Troubleshooting > Logs.
I don't think BigQuery supports writing a string like that - fairly sure it needs to handle it more binary.
Since it's working 90% of the time - what's the difference between the working and non-working? Different questions, different dashboards, ...?

3

The stacktrace is attached below. The difference is that the concerned question is drawn from a joined table that I did using the Metabase's SQL editor. However for the questions where the filter is working, it is applied to exactly the same field (except that in those cases the table comes directly from Big Query).

Thanks !

{:status :failed,
   :class clojure.lang.ExceptionInfo,
   :error "Error reducing result rows",
   :stacktrace
   ["--> query_processor.context.default$default_reducef$fn__33032.invoke(default.clj:60)"
    "query_processor.context.default$default_reducef.invokeStatic(default.clj:57)"
    "query_processor.context.default$default_reducef.invoke(default.clj:48)"
    "query_processor.context$reducef.invokeStatic(context.clj:69)"
    "query_processor.context$reducef.invoke(context.clj:62)"
    "query_processor.context.default$default_runf$respond_STAR___33036.invoke(default.clj:69)"
    "driver.bigquery$post_process_native$fn__1498.invoke(bigquery.clj:251)"
    "driver.bigquery$do_with_finished_response.invokeStatic(bigquery.clj:171)"
    "driver.bigquery$do_with_finished_response.invoke(bigquery.clj:162)"
    "driver.bigquery$post_process_native.invokeStatic(bigquery.clj:234)"
    "driver.bigquery$post_process_native.invoke(bigquery.clj:228)"
    "driver.bigquery$process_native_STAR_$thunk__1596.invoke(bigquery.clj:277)"
    "driver.bigquery$process_native_STAR_.invokeStatic(bigquery.clj:279)"
    "driver.bigquery$process_native_STAR_.invoke(bigquery.clj:272)"
    "driver.bigquery$eval1600$fn__1602.invoke(bigquery.clj:299)"
    "query_processor.context$executef.invokeStatic(context.clj:59)"
    "query_processor.context$executef.invoke(context.clj:48)"
    "query_processor.context.default$default_runf.invokeStatic(default.clj:68)"
    "query_processor.context.default$default_runf.invoke(default.clj:66)"
    "query_processor.context$runf.invokeStatic(context.clj:45)"
    "query_processor.context$runf.invoke(context.clj:39)"
    "query_processor.reducible$pivot.invokeStatic(reducible.clj:34)"
    "query_processor.reducible$pivot.invoke(reducible.clj:31)"
    "query_processor.middleware.mbql_to_native$mbql__GT_native$fn__47232.invoke(mbql_to_native.clj:25)"
    "query_processor.middleware.check_features$check_features$fn__46484.invoke(check_features.clj:41)"
    "query_processor.middleware.limit$limit$fn__47218.invoke(limit.clj:37)"
    "query_processor.middleware.cache$maybe_return_cached_results$fn__46142.invoke(cache.clj:211)"
    "query_processor.middleware.optimize_datetime_filters$optimize_datetime_filters$fn__47397.invoke(optimize_datetime_filters.clj:133)"
    "query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values$fn__45288.invoke(auto_parse_filter_values.clj:43)"
    "query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__40740.invoke(wrap_value_literals.clj:147)"
    "query_processor.middleware.annotate$add_column_info$fn__40625.invoke(annotate.clj:582)"
    "query_processor.middleware.permissions$check_query_permissions$fn__46359.invoke(permissions.clj:75)"
    "query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__47920.invoke(pre_alias_aggregations.clj:40)"
    "query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__46557.invoke(cumulative_aggregations.clj:60)"
    "metabase_enterprise.sandbox.query_processor.middleware.row_level_restrictions$apply_row_level_permissions$fn__49492.invoke(row_level_restrictions.clj:331)"
    "query_processor.middleware.resolve_joined_fields$resolve_joined_fields$fn__48233.invoke(resolve_joined_fields.clj:94)"
    "query_processor.middleware.resolve_joins$resolve_joins$fn__48538.invoke(resolve_joins.clj:178)"
    "query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__44882.invoke(add_implicit_joins.clj:181)"
    "query_processor.middleware.large_int_id$convert_id_to_string$fn__47193.invoke(large_int_id.clj:44)"
    "query_processor.middleware.format_rows$format_rows$fn__47173.invoke(format_rows.clj:74)"
    "query_processor.middleware.desugar$desugar$fn__46623.invoke(desugar.clj:21)"
    "query_processor.middleware.binning$update_binning_strategy$fn__45648.invoke(binning.clj:228)"
    "query_processor.middleware.resolve_fields$resolve_fields$fn__46166.invoke(resolve_fields.clj:24)"
    "query_processor.middleware.add_dimension_projections$add_remapping$fn__44512.invoke(add_dimension_projections.clj:316)"
    "query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__44743.invoke(add_implicit_clauses.clj:146)"
    "metabase_enterprise.sandbox.query_processor.middleware.row_level_restrictions$apply_row_level_permissions$fn__49492.invoke(row_level_restrictions.clj:331)"
    "query_processor.middleware.upgrade_field_literals$upgrade_field_literals$fn__48968.invoke(upgrade_field_literals.clj:45)"
    "query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__45035.invoke(add_source_metadata.clj:122)"
    "metabase_enterprise.sandbox.query_processor.middleware.column_level_perms_check$maybe_apply_column_level_perms_check$fn__49009.invoke(column_level_perms_check.clj:25)"
    "query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__48117.invoke(reconcile_breakout_and_order_by_bucketing.clj:97)"
    "query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__45235.invoke(auto_bucket_datetimes.clj:139)"
    "query_processor.middleware.resolve_source_table$resolve_source_tables$fn__46213.invoke(resolve_source_table.clj:45)"
    "query_processor.middleware.parameters$substitute_parameters$fn__47902.invoke(parameters.clj:111)"
    "query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__46265.invoke(resolve_referenced.clj:79)"
    "query_processor.middleware.expand_macros$expand_macros$fn__46879.invoke(expand_macros.clj:155)"
    "query_processor.middleware.add_timezone_info$add_timezone_info$fn__45044.invoke(add_timezone_info.clj:15)"
    "query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__48904.invoke(splice_params_in_response.clj:32)"
    "query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__48128$fn__48132.invoke(resolve_database_and_driver.clj:31)"
    "driver$do_with_driver.invokeStatic(driver.clj:60)"
    "driver$do_with_driver.invoke(driver.clj:56)"
    "query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__48128.invoke(resolve_database_and_driver.clj:25)"
    "query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__47119.invoke(fetch_source_query.clj:274)"
    "query_processor.middleware.store$initialize_store$fn__48913$fn__48914.invoke(store.clj:11)"
    "query_processor.store$do_with_store.invokeStatic(store.clj:44)"
    "query_processor.store$do_with_store.invoke(store.clj:38)"
    "query_processor.middleware.store$initialize_store$fn__48913.invoke(store.clj:10)"
    "query_processor.middleware.validate$validate_query$fn__48975.invoke(validate.clj:10)"
    "query_processor.middleware.normalize_query$normalize$fn__47245.invoke(normalize_query.clj:22)"
    "query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__44900.invoke(add_rows_truncated.clj:35)"
    "metabase_enterprise.audit.query_processor.middleware.handle_audit_queries$handle_internal_queries$fn__31310.invoke(handle_audit_queries.clj:162)"
    "query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__48889.invoke(results_metadata.clj:147)"
    "query_processor.middleware.constraints$add_default_userland_constraints$fn__46500.invoke(constraints.clj:42)"
    "query_processor.middleware.process_userland_query$process_userland_query$fn__47991.invoke(process_userland_query.clj:135)"
    "query_processor.middleware.catch_exceptions$catch_exceptions$fn__46443.invoke(catch_exceptions.clj:173)"
    "query_processor.reducible$async_qp$qp_STAR___33118$thunk__33119.invoke(reducible.clj:103)"
    "query_processor.reducible$async_qp$qp_STAR___33118$fn__33121.invoke(reducible.clj:108)"],
   :error_type :qp,
   :ex-data {:type :qp}}],
 :error_type :qp,
 :json_query
 {:constraints {:max-results 10000, :max-results-bare-rows 2000},
  :type :query,
  :middleware {:js-int-to-string? true},
  :database 35,
  :query
  {:source-query
   {:source-table 318,
    :joins
    [{:fields :all,
      :source-table 315,
      :condition [:= [:field-id 4476] [:joined-field "timestamps" [:field-id 4400]]],
      :alias "timestamps"}
     {:fields :all,
      :source-table 314,
      :condition [:= [:field-id 4446] [:joined-field "experts" [:field-id 4391]]],
      :alias "experts"}],
    :aggregation [[:count]],
    :breakout
    [[:joined-field "experts" [:field-id 4386]]
     [:datetime-field [:joined-field "timestamps" [:field-id 4403]] :month]],
    :filter
    [:and
     [:not-empty [:joined-field "experts" [:field-id 4386]]]
     [:time-interval [:joined-field "timestamps" [:field-id 4403]] -6 :month {:include-current true}]]},
   :aggregation [[:avg [:field-literal "count" :type/Integer]]],
   :breakout [[:field-literal "expert_first_name" :type/Text]],
   :order-by [[:desc [:aggregation 0]]],
   :limit 1},
  :parameters [],
  :async? true,
  :cache-ttl nil},
 :native
 {:query
  "SELECT `source`.`experts__expert_first_name` AS `experts__expert_first_name`, avg(`source`.`count`) AS `avg` FROM (SELECT `experts`.`expert_first_name` AS `experts__expert_first_name`, timestamp_trunc(`timestamps`.`to_awaiting_publication`, month) AS `timestamps__to_awaiting_publication`, count(*) AS `count` FROM `business_production.sales` LEFT JOIN `business_production.timestamps` `timestamps` ON `business_production.sales`.`id` = `timestamps`.`sale_id` LEFT JOIN `business_production.experts` `experts` ON `business_production.sales`.`expert_id` = `experts`.`id` WHERE (`experts`.`expert_first_name` IS NOT NULL AND (`experts`.`expert_first_name` <> ? OR `experts`.`expert_first_name` IS NULL) AND timestamp_trunc(`timestamps`.`to_awaiting_publication`, month) BETWEEN CAST(datetime_trunc(datetime_add(current_datetime(), INTERVAL -6 month), month) AS timestamp) AND CAST(datetime_trunc(current_datetime(), month) AS timestamp)) GROUP BY `experts__expert_first_name`, `timestamps__to_awaiting_publication` ORDER BY `experts__expert_first_name` ASC, `timestamps__to_awaiting_publication` ASC) `source` GROUP BY `experts__expert_first_name` ORDER BY `avg` DESC, `experts__expert_first_name` ASC LIMIT 1",
  :params (""),
  :table-name "source",
  :mbql? true},
 :status :failed,
 :class org.eclipse.jetty.io.EofException,
 :stacktrace
 ["org.eclipse.jetty.server.HttpConnection$SendCallback.reset(HttpConnection.java:724)"
  "org.eclipse.jetty.server.HttpConnection$SendCallback.access$300(HttpConnection.java:683)"
  "org.eclipse.jetty.server.HttpConnection.send(HttpConnection.java:542)"
  "org.eclipse.jetty.server.HttpChannel.sendResponse(HttpChannel.java:833)"
  "org.eclipse.jetty.server.HttpChannel.write(HttpChannel.java:910)"
  "org.eclipse.jetty.server.HttpOutput.channelWrite(HttpOutput.java:284)"
  "org.eclipse.jetty.server.HttpOutput.channelWrite(HttpOutput.java:268)"
  "org.eclipse.jetty.server.HttpOutput.flush(HttpOutput.java:713)"
  "java.base/java.util.zip.DeflaterOutputStream.flush(Unknown Source)"
  "--> async.streaming_response$delay_output_stream$fn__17508.invoke(streaming_response.clj:119)"
  "async.streaming_response.proxy$java.io.OutputStream$ff19274a.flush(Unknown Source)"
  "query_processor.streaming.json$fn$reify__63514.write_row_BANG_(json.clj:62)"
  "query_processor.streaming$streaming_rff$fn__63982$fn__63983.invoke(streaming.clj:34)"
  "query_processor.middleware.process_userland_query$add_and_save_execution_info_xform_BANG_$execution_info_rf_STAR___47982.invoke(process_userland_query.clj:94)"
  "query_processor.reducible$combine_additional_reducing_fns$fn__33141.invoke(reducible.clj:216)"
  "query_processor.middleware.add_rows_truncated$add_rows_truncated_xform$fn__44895.invoke(add_rows_truncated.clj:27)"
  "query_processor.middleware.format_rows$format_rows_xform$fn__47166.invoke(format_rows.clj:68)"
  "query_processor.middleware.limit$limit_xform$fn__47215.invoke(limit.clj:24)"
  "query_processor.context.default$default_reducef$fn__33032.invoke(default.clj:58)"
  "query_processor.context.default$default_reducef.invokeStatic(default.clj:57)"
  "query_processor.context.default$default_reducef.invoke(default.clj:48)"
  "query_processor.context$reducef.invokeStatic(context.clj:69)"
  "query_processor.context$reducef.invoke(context.clj:62)"
  "query_processor.context.default$default_runf$respond_STAR___33036.invoke(default.clj:69)"
  "driver.bigquery$post_process_native$fn__1498.invoke(bigquery.clj:251)"
  "driver.bigquery$do_with_finished_response.invokeStatic(bigquery.clj:171)"
  "driver.bigquery$do_with_finished_response.invoke(bigquery.clj:162)"
  "driver.bigquery$post_process_native.invokeStatic(bigquery.clj:234)"
  "driver.bigquery$post_process_native.invoke(bigquery.clj:228)"
  "driver.bigquery$process_native_STAR_$thunk__1596.invoke(bigquery.clj:277)"
  "driver.bigquery$process_native_STAR_.invokeStatic(bigquery.clj:279)"
  "driver.bigquery$process_native_STAR_.invoke(bigquery.clj:272)"
  "driver.bigquery$eval1600$fn__1602.invoke(bigquery.clj:299)"
  "query_processor.context$executef.invokeStatic(context.clj:59)"
  "query_processor.context$executef.invoke(context.clj:48)"
  "query_processor.context.default$default_runf.invokeStatic(default.clj:68)"
  "query_processor.context.default$default_runf.invoke(default.clj:66)"
  "query_processor.context$runf.invokeStatic(context.clj:45)"
  "query_processor.context$runf.invoke(context.clj:39)"
  "query_processor.reducible$pivot.invokeStatic(reducible.clj:34)"
  "query_processor.reducible$pivot.invoke(reducible.clj:31)"
  "query_processor.middleware.mbql_to_native$mbql__GT_native$fn__47232.invoke(mbql_to_native.clj:25)"
  "query_processor.middleware.check_features$check_features$fn__46484.invoke(check_features.clj:41)"
  "query_processor.middleware.limit$limit$fn__47218.invoke(limit.clj:37)"
  "query_processor.middleware.cache$maybe_return_cached_results$fn__46142.invoke(cache.clj:211)"
  "query_processor.middleware.optimize_datetime_filters$optimize_datetime_filters$fn__47397.invoke(optimize_datetime_filters.clj:133)"
  "query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values$fn__45288.invoke(auto_parse_filter_values.clj:43)"
  "query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__40740.invoke(wrap_value_literals.clj:147)"
  "query_processor.middleware.annotate$add_column_info$fn__40625.invoke(annotate.clj:582)"
  "query_processor.middleware.permissions$check_query_permissions$fn__46359.invoke(permissions.clj:75)"
  "query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__47920.invoke(pre_alias_aggregations.clj:40)"
  "query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__46557.invoke(cumulative_aggregations.clj:60)"
  "metabase_enterprise.sandbox.query_processor.middleware.row_level_restrictions$apply_row_level_permissions$fn__49492.invoke(row_level_restrictions.clj:331)"
  "query_processor.middleware.resolve_joined_fields$resolve_joined_fields$fn__48233.invoke(resolve_joined_fields.clj:94)"
  "query_processor.middleware.resolve_joins$resolve_joins$fn__48538.invoke(resolve_joins.clj:178)"
  "query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__44882.invoke(add_implicit_joins.clj:181)"
  "query_processor.middleware.large_int_id$convert_id_to_string$fn__47193.invoke(large_int_id.clj:44)"
  "query_processor.middleware.format_rows$format_rows$fn__47173.invoke(format_rows.clj:74)"
  "query_processor.middleware.desugar$desugar$fn__46623.invoke(desugar.clj:21)"
  "query_processor.middleware.binning$update_binning_strategy$fn__45648.invoke(binning.clj:228)"
  "query_processor.middleware.resolve_fields$resolve_fields$fn__46166.invoke(resolve_fields.clj:24)"
  "query_processor.middleware.add_dimension_projections$add_remapping$fn__44512.invoke(add_dimension_projections.clj:316)"
  "query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__44743.invoke(add_implicit_clauses.clj:146)"
  "metabase_enterprise.sandbox.query_processor.middleware.row_level_restrictions$apply_row_level_permissions$fn__49492.invoke(row_level_restrictions.clj:331)"
  "query_processor.middleware.upgrade_field_literals$upgrade_field_literals$fn__48968.invoke(upgrade_field_literals.clj:45)"
  "query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__45035.invoke(add_source_metadata.clj:122)"
  "metabase_enterprise.sandbox.query_processor.middleware.column_level_perms_check$maybe_apply_column_level_perms_check$fn__49009.invoke(column_level_perms_check.clj:25)"
  "query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__48117.invoke(reconcile_breakout_and_order_by_bucketing.clj:97)"
  "query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__45235.invoke(auto_bucket_datetimes.clj:139)"
  "query_processor.middleware.resolve_source_table$resolve_source_tables$fn__46213.invoke(resolve_source_table.clj:45)"
  "query_processor.middleware.parameters$substitute_parameters$fn__47902.invoke(parameters.clj:111)"
  "query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__46265.invoke(resolve_referenced.clj:79)"
  "query_processor.middleware.expand_macros$expand_macros$fn__46879.invoke(expand_macros.clj:155)"
  "query_processor.middleware.add_timezone_info$add_timezone_info$fn__45044.invoke(add_timezone_info.clj:15)"
  "query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__48904.invoke(splice_params_in_response.clj:32)"
  "query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__48128$fn__48132.invoke(resolve_database_and_driver.clj:31)"
  "driver$do_with_driver.invokeStatic(driver.clj:60)"
  "driver$do_with_driver.invoke(driver.clj:56)"
  "query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__48128.invoke(resolve_database_and_driver.clj:25)"
  "query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__47119.invoke(fetch_source_query.clj:274)"
  "query_processor.middleware.store$initialize_store$fn__48913$fn__48914.invoke(store.clj:11)"
  "query_processor.store$do_with_store.invokeStatic(store.clj:44)"
  "query_processor.store$do_with_store.invoke(store.clj:38)"
  "query_processor.middleware.store$initialize_store$fn__48913.invoke(store.clj:10)"
  "query_processor.middleware.validate$validate_query$fn__48975.invoke(validate.clj:10)"
  "query_processor.middleware.normalize_query$normalize$fn__47245.invoke(normalize_query.clj:22)"
  "query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__44900.invoke(add_rows_truncated.clj:35)"
  "metabase_enterprise.audit.query_processor.middleware.handle_audit_queries$handle_internal_queries$fn__31310.invoke(handle_audit_queries.clj:162)"
  "query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__48889.invoke(results_metadata.clj:147)"
  "query_processor.middleware.constraints$add_default_userland_constraints$fn__46500.invoke(constraints.clj:42)"
  "query_processor.middleware.process_userland_query$process_userland_query$fn__47991.invoke(process_userland_query.clj:135)"
  "query_processor.middleware.catch_exceptions$catch_exceptions$fn__46443.invoke(catch_exceptions.clj:173)"
  "query_processor.reducible$async_qp$qp_STAR___33118$thunk__33119.invoke(reducible.clj:103)"
  "query_processor.reducible$async_qp$qp_STAR___33118$fn__33121.invoke(reducible.clj:108)"],
 :context :question,
 :error nil,
 :row_count 0,
 :running_time 0,
 :preprocessed
 {:constraints {:max-results 10000, :max-results-bare-rows 2000},
  :type :query,
  :middleware {:js-int-to-string? true},
  :info
  {:executed-by 68,
   :context :question,
   :card-id 518,
   :query-hash
4

@anton1 Are you sure that is the correct stacktrace? Seems like something is missing or not the right one