Previously, I believed that this was associated with
https://github.com/metabase/metabase/issues/16202 and https://github.com/metabase/metabase/issues/15397.
1.39.3 appears to have fixed the reproduction in 16202, but not the root error that it was meant to represent.
An attempt to run a summary on an existing SQL query returned the error:
Unrecognized name: `integrated_reporting_precomp.source` at [2:28]
SysInfo
{
"browser-info": {
"language": "en-GB",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.77 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.11+9",
"java.vendor": "AdoptOpenJDK",
"java.vendor.url": "https://adoptopenjdk.net/",
"java.version": "11.0.11",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.11+9",
"os.name": "Linux",
"os.version": "4.14.219-164.354.amzn2.x86_64",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"bigquery",
"h2"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "11.9"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.2.18"
}
},
"run-mode": "prod",
"version": {
"date": "2021-05-27",
"tag": "v1.39.3",
"branch": "release-x.39.x",
"hash": "598a112"
},
"settings": {
"report-timezone": null
}
}
}
Logs
[4e41f61c-4ae4-419e-ae00-dbb2bfd8b312] 2021-06-07T11:23:11+08:00 INFO metabase.query-processor.middleware.fetch-source-query Fetched source query from Card 24:
{:template-tags
{"user_group"
{:id "1cb59f39-a306-2e37-9db7-6cd8ba6d96d5",
:name "user_group",
:display-name "User group",
:type :dimension,
:dimension [:field 190 nil],
:widget-type :category},
"company_name"
{:id "01b0f29f-1417-29b3-3ee0-b6365c7c2ab6",
:name "company_name",
:display-name "Company name",
:type :dimension,
:dimension [:field 201 nil],
:widget-type :category}},
:native
"WITH BT AS (\nSELECT * FROM `integrated_reporting_precomp.integrated_activity`\nLEFT JOIN \n(SELECT * FROM `integrated_reporting_precomp.total_user_groups` WHERE {{user_group}}) `Total User Groups`\nUSING (user_id)\nWHERE {{company_name}}\n),\nDAU_TBL AS (\nSELECT COUNT(DISTINCT user_id) AS dau, `date`, date_trunc(`date`, month) AS month_date,\nFROM BT\nGROUP BY `date`\nORDER BY `date`\n\n),\nMAU_TBL AS (\nSELECT COUNT(DISTINCT user_id) AS mau, date_trunc(`date`, month) AS month_date,\nFROM BT\nGROUP BY `month_date`\nORDER BY `month_date`\n),\nCOMBINED AS \n(\nSELECT *, dau / mau AS `dau_mau_ratio`\nFROM DAU_TBL\nLEFT JOIN MAU_TBL\nUSING (month_date)\n)\n\n\n\nSELECT * FROM COMBINED"}
[4e41f61c-4ae4-419e-ae00-dbb2bfd8b312] 2021-06-07T11:23:12+08:00 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: null
{:database_id 5,
:started_at #t "2021-06-07T03:23:10.897735Z[GMT]",
:via
[{:status :failed,
:class clojure.lang.ExceptionInfo,
:error "Error executing query",
:stacktrace
["--> driver.bigquery$execute_bigquery.invokeStatic(bigquery.clj:224)"
"driver.bigquery$execute_bigquery.invoke(bigquery.clj:203)"
"driver.bigquery$execute_bigquery.invokeStatic(bigquery.clj:205)"
"driver.bigquery$execute_bigquery.invoke(bigquery.clj:203)"
"driver.bigquery$process_native_STAR_$thunk__1576.invoke(bigquery.clj:277)"
"driver.bigquery$process_native_STAR_.invokeStatic(bigquery.clj:279)"
"driver.bigquery$process_native_STAR_.invoke(bigquery.clj:272)"
"driver.bigquery$eval1580$fn__1582.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__48373.invoke(mbql_to_native.clj:25)"
"query_processor.middleware.check_features$check_features$fn__47487.invoke(check_features.clj:39)"
"query_processor.middleware.limit$limit$fn__48359.invoke(limit.clj:37)"
"query_processor.middleware.cache$maybe_return_cached_results$fn__46939.invoke(cache.clj:211)"
"query_processor.middleware.optimize_temporal_filters$optimize_temporal_filters$fn__48619.invoke(optimize_temporal_filters.clj:204)"
"query_processor.middleware.validate_temporal_bucketing$validate_temporal_bucketing$fn__50549.invoke(validate_temporal_bucketing.clj:50)"
"query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values$fn__46058.invoke(auto_parse_filter_values.clj:43)"
"query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__41638.invoke(wrap_value_literals.clj:161)"
"query_processor.middleware.annotate$add_column_info$fn__41535.invoke(annotate.clj:605)"
"query_processor.middleware.permissions$check_query_permissions$fn__47359.invoke(permissions.clj:81)"
"query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__49477.invoke(pre_alias_aggregations.clj:40)"
"query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__47560.invoke(cumulative_aggregations.clj:60)"
"metabase_enterprise.sandbox.query_processor.middleware.row_level_restrictions$apply_row_level_permissions$fn__51067.invoke(row_level_restrictions.clj:335)"
"query_processor.middleware.resolve_joined_fields$resolve_joined_fields$fn__49776.invoke(resolve_joined_fields.clj:102)"
"query_processor.middleware.resolve_joins$resolve_joins$fn__50089.invoke(resolve_joins.clj:171)"
"query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__45634.invoke(add_implicit_joins.clj:190)"
"query_processor.middleware.large_int_id$convert_id_to_string$fn__48323.invoke(large_int_id.clj:59)"
"query_processor.middleware.format_rows$format_rows$fn__48304.invoke(format_rows.clj:74)"
"query_processor.middleware.add_default_temporal_unit$add_default_temporal_unit$fn__44928.invoke(add_default_temporal_unit.clj:23)"
"query_processor.middleware.desugar$desugar$fn__47626.invoke(desugar.clj:21)"
"query_processor.middleware.binning$update_binning_strategy$fn__46445.invoke(binning.clj:227)"
"query_processor.middleware.resolve_fields$resolve_fields$fn__47162.invoke(resolve_fields.clj:34)"
"query_processor.middleware.add_dimension_projections$add_remapping$fn__45283.invoke(add_dimension_projections.clj:314)"
"query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__45512.invoke(add_implicit_clauses.clj:147)"
"metabase_enterprise.sandbox.query_processor.middleware.row_level_restrictions$apply_row_level_permissions$fn__51067.invoke(row_level_restrictions.clj:335)"
"query_processor.middleware.upgrade_field_literals$upgrade_field_literals$fn__50498.invoke(upgrade_field_literals.clj:40)"
"query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__45797.invoke(add_source_metadata.clj:123)"
"metabase_enterprise.sandbox.query_processor.middleware.column_level_perms_check$maybe_apply_column_level_perms_check$fn__50579.invoke(column_level_perms_check.clj:30)"
"query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__49651.invoke(reconcile_breakout_and_order_by_bucketing.clj:100)"
"query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__46005.invoke(auto_bucket_datetimes.clj:147)"
"query_processor.middleware.resolve_source_table$resolve_source_tables$fn__47209.invoke(resolve_source_table.clj:45)"
"query_processor.middleware.parameters$substitute_parameters$fn__49459.invoke(parameters.clj:111)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__47261.invoke(resolve_referenced.clj:79)"
"query_processor.middleware.expand_macros$expand_macros$fn__48010.invoke(expand_macros.clj:184)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__45806.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__50451.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__49662$fn__49666.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__49662.invoke(resolve_database_and_driver.clj:25)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__48250.invoke(fetch_source_query.clj:273)"
"query_processor.middleware.store$initialize_store$fn__50460$fn__50461.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__50460.invoke(store.clj:10)"
"query_processor.middleware.validate$validate_query$fn__50505.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__48386.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__45652.invoke(add_rows_truncated.clj:35)"
"metabase_enterprise.audit.query_processor.middleware.handle_audit_queries$handle_internal_queries$fn__31908.invoke(handle_audit_queries.clj:162)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__50436.invoke(results_metadata.clj:147)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__47503.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__49548.invoke(process_userland_query.clj:135)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__47443.invoke(catch_exceptions.clj:173)"
"query_processor.reducible$async_qp$qp_STAR___33764$thunk__33765.invoke(reducible.clj:103)"
"query_processor.reducible$async_qp$qp_STAR___33764.invoke(reducible.clj:109)"
"query_processor.reducible$sync_qp$qp_STAR___33773$fn__33776.invoke(reducible.clj:135)"
"query_processor.reducible$sync_qp$qp_STAR___33773.invoke(reducible.clj:134)"
"query_processor$process_userland_query.invokeStatic(query_processor.clj:241)"
"query_processor$process_userland_query.doInvoke(query_processor.clj:237)"
"query_processor$fn__51113$process_query_and_save_execution_BANG___51122$fn__51125.invoke(query_processor.clj:253)"
"query_processor$fn__51113$process_query_and_save_execution_BANG___51122.invoke(query_processor.clj:245)"
"query_processor$fn__51157$process_query_and_save_with_max_results_constraints_BANG___51166$fn__51169.invoke(query_processor.clj:265)"
"query_processor$fn__51157$process_query_and_save_with_max_results_constraints_BANG___51166.invoke(query_processor.clj:258)"
"api.dataset$run_query_async$fn__66371.invoke(dataset.clj:56)"
"query_processor.streaming$streaming_response_STAR_$fn__66350$fn__66351.invoke(streaming.clj:72)"
"query_processor.streaming$streaming_response_STAR_$fn__66350.invoke(streaming.clj:71)"
"async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:65)"
"async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:63)"
"async.streaming_response$do_f_async$fn__17604.invoke(streaming_response.clj:84)"],
:error_type :invalid-query,
:ex-data
{:type :invalid-query,
:sql
"-- Metabase:: userID: 1 queryType: MBQL queryHash: 0adb488b750a5416be776ec3e6a54a24cbaa7fe23e0455f375fbbcf0dbb776ae\nSELECT datetime_trunc(CAST(`integrated_reporting_precomp.source`.`month_date` AS datetime), month) AS `month_date`, avg(`source`.`dau_mau_ratio`) AS `avg` FROM (WITH BT AS (\nSELECT * FROM `integrated_reporting_precomp.integrated_activity`\nLEFT JOIN \n(SELECT * FROM `integrated_reporting_precomp.total_user_groups` WHERE 1 = 1) `Total User Groups`\nUSING (user_id)\nWHERE 1 = 1\n),\nDAU_TBL AS (\nSELECT COUNT(DISTINCT user_id) AS dau, `date`, date_trunc(`date`, month) AS month_date,\nFROM BT\nGROUP BY `date`\nORDER BY `date`\n\n),\nMAU_TBL AS (\nSELECT COUNT(DISTINCT user_id) AS mau, date_trunc(`date`, month) AS month_date,\nFROM BT\nGROUP BY `month_date`\nORDER BY `month_date`\n),\nCOMBINED AS \n(\nSELECT *, dau / mau AS `dau_mau_ratio`\nFROM DAU_TBL\nLEFT JOIN MAU_TBL\nUSING (month_date)\n)\n\n\n\nSELECT * FROM COMBINED) `source` GROUP BY `month_date` ORDER BY `month_date` ASC",
:parameters nil}}],
:error_type :invalid-query,
:json_query
{:database 5,
:query
{:source-table "card__24",
:aggregation [["avg" ["field" "dau_mau_ratio" {:base-type "type/Float"}]]],
:breakout [["field" "month_date" {:base-type "type/Date", :temporal-unit "month"}]]},
:type "query",
:parameters [],
:middleware {:js-int-to-string? true, :add-default-userland-constraints? true}},
:native
{:query
"SELECT datetime_trunc(CAST(`integrated_reporting_precomp.source`.`month_date` AS datetime), month) AS `month_date`, avg(`source`.`dau_mau_ratio`) AS `avg` FROM (WITH BT AS (\nSELECT * FROM `integrated_reporting_precomp.integrated_activity`\nLEFT JOIN \n(SELECT * FROM `integrated_reporting_precomp.total_user_groups` WHERE 1 = 1) `Total User Groups`\nUSING (user_id)\nWHERE 1 = 1\n),\nDAU_TBL AS (\nSELECT COUNT(DISTINCT user_id) AS dau, `date`, date_trunc(`date`, month) AS month_date,\nFROM BT\nGROUP BY `date`\nORDER BY `date`\n\n),\nMAU_TBL AS (\nSELECT COUNT(DISTINCT user_id) AS mau, date_trunc(`date`, month) AS month_date,\nFROM BT\nGROUP BY `month_date`\nORDER BY `month_date`\n),\nCOMBINED AS \n(\nSELECT *, dau / mau AS `dau_mau_ratio`\nFROM DAU_TBL\nLEFT JOIN MAU_TBL\nUSING (month_date)\n)\n\n\n\nSELECT * FROM COMBINED) `source` GROUP BY `month_date` ORDER BY `month_date` ASC",
:params nil,
:table-name "source",
:mbql? true},
:status :failed,
:class clojure.lang.ExceptionInfo,
:stacktrace
["--> driver.google$execute_no_auto_retry.invokeStatic(google.clj:41)"
"driver.google$execute_no_auto_retry.invoke(google.clj:33)"
"driver.google$execute.invokeStatic(google.clj:55)"
"driver.google$execute.invoke(google.clj:45)"
"driver.bigquery$execute_bigquery.invokeStatic(bigquery.clj:216)"
"driver.bigquery$execute_bigquery.invoke(bigquery.clj:203)"
"driver.bigquery$execute_bigquery.invokeStatic(bigquery.clj:205)"
"driver.bigquery$execute_bigquery.invoke(bigquery.clj:203)"
"driver.bigquery$process_native_STAR_$thunk__1576.invoke(bigquery.clj:277)"
"driver.bigquery$process_native_STAR_.invokeStatic(bigquery.clj:279)"
"driver.bigquery$process_native_STAR_.invoke(bigquery.clj:272)"
"driver.bigquery$eval1580$fn__1582.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__48373.invoke(mbql_to_native.clj:25)"
"query_processor.middleware.check_features$check_features$fn__47487.invoke(check_features.clj:39)"
"query_processor.middleware.limit$limit$fn__48359.invoke(limit.clj:37)"
"query_processor.middleware.cache$maybe_return_cached_results$fn__46939.invoke(cache.clj:211)"
"query_processor.middleware.optimize_temporal_filters$optimize_temporal_filters$fn__48619.invoke(optimize_temporal_filters.clj:204)"
"query_processor.middleware.validate_temporal_bucketing$validate_temporal_bucketing$fn__50549.invoke(validate_temporal_bucketing.clj:50)"
"query_processor.middleware.auto_parse_filter_values$auto_parse_filter_values$fn__46058.invoke(auto_parse_filter_values.clj:43)"
"query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__41638.invoke(wrap_value_literals.clj:161)"
"query_processor.middleware.annotate$add_column_info$fn__41535.invoke(annotate.clj:605)"
"query_processor.middleware.permissions$check_query_permissions$fn__47359.invoke(permissions.clj:81)"
"query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__49477.invoke(pre_alias_aggregations.clj:40)"
"query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__47560.invoke(cumulative_aggregations.clj:60)"
"metabase_enterprise.sandbox.query_processor.middleware.row_level_restrictions$apply_row_level_permissions$fn__51067.invoke(row_level_restrictions.clj:335)"
"query_processor.middleware.resolve_joined_fields$resolve_joined_fields$fn__49776.invoke(resolve_joined_fields.clj:102)"
"query_processor.middleware.resolve_joins$resolve_joins$fn__50089.invoke(resolve_joins.clj:171)"
"query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__45634.invoke(add_implicit_joins.clj:190)"
"query_processor.middleware.large_int_id$convert_id_to_string$fn__48323.invoke(large_int_id.clj:59)"
"query_processor.middleware.format_rows$format_rows$fn__48304.invoke(format_rows.clj:74)"
"query_processor.middleware.add_default_temporal_unit$add_default_temporal_unit$fn__44928.invoke(add_default_temporal_unit.clj:23)"
"query_processor.middleware.desugar$desugar$fn__47626.invoke(desugar.clj:21)"
"query_processor.middleware.binning$update_binning_strategy$fn__46445.invoke(binning.clj:227)"
"query_processor.middleware.resolve_fields$resolve_fields$fn__47162.invoke(resolve_fields.clj:34)"
"query_processor.middleware.add_dimension_projections$add_remapping$fn__45283.invoke(add_dimension_projections.clj:314)"
"query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__45512.invoke(add_implicit_clauses.clj:147)"
"metabase_enterprise.sandbox.query_processor.middleware.row_level_restrictions$apply_row_level_permissions$fn__51067.invoke(row_level_restrictions.clj:335)"
"query_processor.middleware.upgrade_field_literals$upgrade_field_literals$fn__50498.invoke(upgrade_field_literals.clj:40)"
"query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__45797.invoke(add_source_metadata.clj:123)"
"metabase_enterprise.sandbox.query_processor.middleware.column_level_perms_check$maybe_apply_column_level_perms_check$fn__50579.invoke(column_level_perms_check.clj:30)"
"query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__49651.invoke(reconcile_breakout_and_order_by_bucketing.clj:100)"
"query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__46005.invoke(auto_bucket_datetimes.clj:147)"
"query_processor.middleware.resolve_source_table$resolve_source_tables$fn__47209.invoke(resolve_source_table.clj:45)"
"query_processor.middleware.parameters$substitute_parameters$fn__49459.invoke(parameters.clj:111)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__47261.invoke(resolve_referenced.clj:79)"
"query_processor.middleware.expand_macros$expand_macros$fn__48010.invoke(expand_macros.clj:184)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__45806.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__50451.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__49662$fn__49666.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__49662.invoke(resolve_database_and_driver.clj:25)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__48250.invoke(fetch_source_query.clj:273)"
"query_processor.middleware.store$initialize_store$fn__50460$fn__50461.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__50460.invoke(store.clj:10)"
"query_processor.middleware.validate$validate_query$fn__50505.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__48386.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__45652.invoke(add_rows_truncated.clj:35)"
"metabase_enterprise.audit.query_processor.middleware.handle_audit_queries$handle_internal_queries$fn__31908.invoke(handle_audit_queries.clj:162)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__50436.invoke(results_metadata.clj:147)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__47503.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__49548.invoke(process_userland_query.clj:135)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__47443.invoke(catch_exceptions.clj:173)"
"query_processor.reducible$async_qp$qp_STAR___33764$thunk__33765.invoke(reducible.clj:103)"
"query_processor.reducible$async_qp$qp_STAR___33764.invoke(reducible.clj:109)"
"query_processor.reducible$sync_qp$qp_STAR___33773$fn__33776.invoke(reducible.clj:135)"
"query_processor.reducible$sync_qp$qp_STAR___33773.invoke(reducible.clj:134)"
"query_processor$process_userland_query.invokeStatic(query_processor.clj:241)"
"query_processor$process_userland_query.doInvoke(query_processor.clj:237)"
"query_processor$fn__51113$process_query_and_save_execution_BANG___51122$fn__51125.invoke(query_processor.clj:253)"
"query_processor$fn__51113$process_query_and_save_execution_BANG___51122.invoke(query_processor.clj:245)"
"query_processor$fn__51157$process_query_and_save_with_max_results_constraints_BANG___51166$fn__51169.invoke(query_processor.clj:265)"
"query_processor$fn__51157$process_query_and_save_with_max_results_constraints_BANG___51166.invoke(query_processor.clj:258)"
"api.dataset$run_query_async$fn__66371.invoke(dataset.clj:56)"
"query_processor.streaming$streaming_response_STAR_$fn__66350$fn__66351.invoke(streaming.clj:72)"
"query_processor.streaming$streaming_response_STAR_$fn__66350.invoke(streaming.clj:71)"
"async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:65)"
"async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:63)"
"async.streaming_response$do_f_async$fn__17604.invoke(streaming_response.clj:84)"],
:context :ad-hoc,
:error "Unrecognized name: `integrated_reporting_precomp.source` at [2:28]",
:row_count 0,
:running_time 0,
:preprocessed
{:database 5,
:query
{:aggregation [[:aggregation-options [:avg [:field "dau_mau_ratio" {:base-type :type/Float}]] {:name "avg"}]],
:breakout [[:field "month_date" {:base-type :type/Date, :temporal-unit :month}]],
:source-metadata
[{:name "month_date",
:display_name "month_date",
:base_type :type/Date,
:field_ref [:field "month_date" {:base-type :type/Date, :temporal-unit :default}],
:semantic_type nil,
:fingerprint
{:global {:distinct-count 13, :nil% 0.0},
:type {:type/DateTime {:earliest "2020-06-01T00:00:00Z", :latest "2021-06-01T00:00:00Z"}}}}
{:name "dau",
:display_name "dau",
:base_type :type/Integer,
:field_ref [:field "dau" {:base-type :type/Integer}],
:semantic_type nil,
:fingerprint
{:global {:distinct-count 100, :nil% 0.0},
:type
{:type/Number
{:min 2.0,
:q1 28.085498091603526,
:q3 63.298547209947316,
:max 172.0,
:sd 27.065999759379547,
:avg 48.35243553008596}}}}
{:name "date",
:display_name "date",
:base_type :type/Date,
:field_ref [:field "date" {:base-type :type/Date, :temporal-unit :default}],
:semantic_type nil,
:fingerprint
{:global {:distinct-count 349, :nil% 0.0},
:type {:type/DateTime {:earliest "2020-06-23T00:00:00Z", :latest "2021-06-06T00:00:00Z"}}}}
{:name "mau",
:display_name "mau",
:base_type :type/Integer,
:field_ref [:field "mau" {:base-type :type/Integer}],
:semantic_type nil,
:fingerprint
{:global {:distinct-count 13, :nil% 0.0},
:type
{:type/Number
{:min 54.0,
:q1 265.2583333333333,
:q3 434.08870967741933,
:max 796.0,
:sd 198.65725820582364,
:avg 396.7106017191977}}}}
{:name "dau_mau_ratio",
:display_name "dau_mau_ratio",
:base_type :type/Float,
:field_ref [:field "dau_mau_ratio" {:base-type :type/Float}],
:semantic_type nil,
:fingerprint
{:global {:distinct-count 268, :nil% 0.0},
:type
{:type/Number
{:min 0.01507537688442211,
:q1 0.08419731313455661,
:q3 0.17235760586112944,
:max 0.5925925925925926,
:sd 0.07682277049373379,
:avg 0.13686027572956058}}}}],
:order-by [[:asc [:field "month_date" {:base-type :type/Date, :temporal-unit :month}]]],
:source-query
{:params [],
:native
"WITH BT AS (\nSELECT * FROM `integrated_reporting_precomp.integrated_activity`\nLEFT JOIN \n(SELECT * FROM `integrated_reporting_precomp.total_user_groups` WHERE 1 = 1) `Total User Groups`\nUSING (user_id)\nWHERE 1 = 1\n),\nDAU_TBL AS (\nSELECT COUNT(DISTINCT user_id) AS dau, `date`, date_trunc(`date`, month) AS month_date,\nFROM BT\nGROUP BY `date`\nORDER BY `date`\n\n),\nMAU_TBL AS (\nSELECT COUNT(DISTINCT user_id) AS mau, date_trunc(`date`, month) AS month_date,\nFROM BT\nGROUP BY `month_date`\nORDER BY `month_date`\n),\nCOMBINED AS \n(\nSELECT *, dau / mau AS `dau_mau_ratio`\nFROM DAU_TBL\nLEFT JOIN MAU_TBL\nUSING (month_date)\n)\n\n\n\nSELECT * FROM COMBINED"}},
:type :query,
:middleware {:js-int-to-string? true, :add-default-userland-constraints? true},
:info
{:executed-by 1,
:context :ad-hoc,
:card-id 24,
:nested? true,
:query-hash
[10, -37, 72, -117, 117, 10, 84, 22, -66, 119, 110, -61, -26, -91, 74, 36, -53, -86, 127, -30, 62, 4, 85, -13, 117,
-5, -68, -16, -37, -73, 118, -82]},
:constraints {:max-results 10000, :max-results-bare-rows 2000}},
:ex-data
{"code" 400,
"errors"
[{"domain" "global", "location" "q", "locationType" "parameter", "message" "Unrecognized name: `integrated_reporting_precomp.source` at [2:28]", "reason" "invalidQuery"}],
"message" "Unrecognized name: `integrated_reporting_precomp.source` at [2:28]",
"status" "INVALID_ARGUMENT"},
:data {:rows [], :cols []}}
[4e41f61c-4ae4-419e-ae00-dbb2bfd8b312] 2021-06-07T11:23:12+08:00 DEBUG metabase.server.middleware.log POST /api/dataset 202 [ASYNC: completed] 1.9 s (12 DB calls) App DB connections: 0/15 Jetty threads: 2/50 (18 idle, 0 queued) (120 total active threads) Queries in flight: 0 (0 queued)
I have been unable to trivially reproduce this issue on a simplified dataset at the moment.
Working around it with a SQL question should work though.
on the first post