Join of two saved question with the grouping in them and custom columns causes an error

Alisa · September 2, 2020, 7:16pm

There are two saved question, both with filter and grouping within them. If one constructs new question with both of them, with all the fields from two questions, everything works fine. But if custom field (“test field”) is added, an error occurs: [Vertica]VJDBC ERROR: Column source.user_uid does not exist. In SQL for both cases it can be seen that indeed source.user_uid field (as well as “source”.“deposit_first_date”) are added. Why are they added and how can we get rid of this error?

CORRECT QUESTION:
SELECT “source”.“registration_date” AS “registration_date”, “source”.“count” AS “count”, “Question 6729”.“registration_date” AS “registration_date_2”,
“Question 6729”.“count” AS “count_2”
FROM (
SELECT date_trunc(‘month’, “rptbi”.“sse_client_dm_out”.“registration_date”) AS “registration_date”,
count(distinct “rptbi”.“sse_client_dm_out”.“user_uid”) AS “count” FROM “rptbi”.“sse_client_dm_out”
WHERE “rptbi”.“sse_client_dm_out”.“registration_date” BETWEEN timestamp with time zone ‘2020-01-01 00:00:00.000Z’
AND timestamp with time zone ‘2020-07-31 00:00:00.000Z’
GROUP BY date_trunc(‘month’, “rptbi”.“sse_client_dm_out”.“registration_date”)
ORDER BY date_trunc(‘month’, “rptbi”.“sse_client_dm_out”.“registration_date”) ASC
) “source”
LEFT JOIN (
SELECT date_trunc(‘month’, “rptbi”.“sse_client_dm_out”.“registration_date”) AS “registration_date”,
count(distinct “rptbi”.“sse_client_dm_out”.“user_uid”) AS “count” FROM “rptbi”.“sse_client_dm_out”
WHERE (“rptbi”.“sse_client_dm_out”.“deposit_first_date” IS NOT NULL AND “rptbi”.“sse_client_dm_out”.“registration_date” BETWEEN timestamp with time zone ‘2020-01-01 00:00:00.000Z’ AND timestamp with time zone ‘2020-07-31 00:00:00.000Z’)
GROUP BY date_trunc(‘month’, “rptbi”.“sse_client_dm_out”.“registration_date”)
) “Question 6729”
ON “source”.“registration_date” = “Question 6729”.“registration_date”
LIMIT 1048576

INCORRECT QUESTION:
SELECT “source”.“registration_date” AS “registration_date”, “source”.“count” AS “count”, “source”.“test field” AS “test field”,
“source”.“registration_date” AS “registration_date_2”, “source”.“count” AS “count_2”
FROM
(
SELECT (“source”.“count” * “Question 6729”.“count”) AS “test field”, “source”.“registration_date” AS “registration_date”,
“Question 6729”.“registration_date” AS “registration_date_2”, “source”.“user_uid” AS “user_uid”,
“source”.“deposit_first_date” AS “deposit_first_date”, “source”.“registration_date” AS “registration_date_3”,
“source”.“count” AS “count”, “Question 6729”.“count” AS “count_2” FROM
(
SELECT date_trunc(‘month’, “rptbi”.“sse_client_dm_out”.“registration_date”) AS “registration_date”,
count(distinct “rptbi”.“sse_client_dm_out”.“user_uid”) AS “count” FROM “rptbi”.“sse_client_dm_out”
WHERE “rptbi”.“sse_client_dm_out”.“registration_date” BETWEEN timestamp with time zone ‘2020-01-01 00:00:00.000Z’
AND timestamp with time zone ‘2020-07-31 00:00:00.000Z’
GROUP BY date_trunc(‘month’, “rptbi”.“sse_client_dm_out”.“registration_date”
)
ORDER BY date_trunc(‘month’, “rptbi”.“sse_client_dm_out”.“registration_date”) ASC
) “source”
LEFT JOIN (
SELECT date_trunc(‘month’, “rptbi”.“sse_client_dm_out”.“registration_date”) AS “registration_date”,
count(distinct “rptbi”.“sse_client_dm_out”.“user_uid”) AS “count” FROM “rptbi”.“sse_client_dm_out”
WHERE (“rptbi”.“sse_client_dm_out”.“deposit_first_date” IS NOT NULL AND “rptbi”.“sse_client_dm_out”.“registration_date” BETWEEN timestamp with time zone ‘2020-01-01 00:00:00.000Z’ AND timestamp with time zone ‘2020-07-31 00:00:00.000Z’)
GROUP BY date_trunc(‘month’, “rptbi”.“sse_client_dm_out”.“registration_date”)
) “Question 6729”
ON “source”.“registration_date” = “Question 6729”.“registration_date”

) “source”
LIMIT 1048576

flamber · September 2, 2020, 7:47pm

Hi @Alisa

Post “Diagnostic Info” from Admin > Troubleshooting.

It sounds like you’re seeing one of these issues - or one of the references in those issues - but it’s a little difficult to say for sure without more details on how the questions are constructed:
https://github.com/metabase/metabase/issues/12839
https://github.com/metabase/metabase/issues/12762

Alisa · September 18, 2020, 11:48am

Hi, here are error logs:

[6c549f43-310d-47a1-9557-6e6c97f7d2d4] 2020-09-18T14:42:42+03:00 ERROR metabase.query-processor.middleware.catch-exceptions Error processing query: null
{:database_id 3,
:started_at #t "2020-09-18T11:42:41.366534Z[GMT]",
:via
[{:status :failed,
:class java.sql.SQLSyntaxErrorException,
:error "[Vertica]VJDBC ERROR: Column source.user_uid does not exist",
:stacktrace
["com.vertica.util.ServerErrorData.buildException(Unknown Source)"
"com.vertica.io.ProtocolStream.readExpectedMessage(Unknown Source)"
"com.vertica.dataengine.VDataEngine.prepareImpl(Unknown Source)"
"com.vertica.dataengine.VDataEngine.prepare(Unknown Source)"
"com.vertica.dataengine.VDataEngine.prepare(Unknown Source)"
"com.vertica.jdbc.common.SPreparedStatement.(Unknown Source)"
"com.vertica.jdbc.jdbc4.S4PreparedStatement.(Unknown Source)"
"com.vertica.jdbc.VerticaJdbc4PreparedStatementImpl.(Unknown Source)"
"com.vertica.jdbc.VJDBCObjectFactory.createPreparedStatement(Unknown Source)"
"com.vertica.jdbc.common.SConnection.prepareStatement(Unknown Source)"
"com.vertica.jdbc.common.SConnection.prepareStatement(Unknown Source)"
"com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:267)"
"--> driver.sql_jdbc.execute$fn__72446.invokeStatic(execute.clj:239)"
"driver.sql_jdbc.execute$fn__72446.invoke(execute.clj:237)"
"driver.sql_jdbc.execute$prepared_statement_STAR_.invokeStatic(execute.clj:257)"
"driver.sql_jdbc.execute$prepared_statement_STAR_.invoke(execute.clj:254)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:387)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:377)"
"driver.sql_jdbc$fn__73834.invokeStatic(sql_jdbc.clj:49)"
"driver.sql_jdbc$fn__73834.invoke(sql_jdbc.clj:47)"
"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:69)"
"query_processor.context.default$default_runf.invoke(default.clj:67)"
"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__45532.invoke(mbql_to_native.clj:26)"
"query_processor.middleware.check_features$check_features$fn__44834.invoke(check_features.clj:42)"
"query_processor.middleware.optimize_datetime_filters$optimize_datetime_filters$fn__45697.invoke(optimize_datetime_filters.clj:133)"
"query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__47225.invoke(wrap_value_literals.clj:137)"
"query_processor.middleware.annotate$add_column_info$fn__43455.invoke(annotate.clj:574)"
"query_processor.middleware.permissions$check_query_permissions$fn__44709.invoke(permissions.clj:64)"
"query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__46215.invoke(pre_alias_aggregations.clj:40)"
"query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__44907.invoke(cumulative_aggregations.clj:61)"
"query_processor.middleware.resolve_joins$resolve_joins$fn__46747.invoke(resolve_joins.clj:183)"
"query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__39185.invoke(add_implicit_joins.clj:245)"
"query_processor.middleware.limit$limit$fn__45518.invoke(limit.clj:38)"
"query_processor.middleware.format_rows$format_rows$fn__45499.invoke(format_rows.clj:81)"
"query_processor.middleware.desugar$desugar$fn__44973.invoke(desugar.clj:22)"
"query_processor.middleware.binning$update_binning_strategy$fn__43999.invoke(binning.clj:229)"
"query_processor.middleware.resolve_fields$resolve_fields$fn__44515.invoke(resolve_fields.clj:24)"
"query_processor.middleware.add_dimension_projections$add_remapping$fn__38734.invoke(add_dimension_projections.clj:272)"
"query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__38941.invoke(add_implicit_clauses.clj:141)"
"query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__39334.invoke(add_source_metadata.clj:105)"
"query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__46412.invoke(reconcile_breakout_and_order_by_bucketing.clj:98)"
"query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__43640.invoke(auto_bucket_datetimes.clj:125)"
"query_processor.middleware.resolve_source_table$resolve_source_tables$fn__44562.invoke(resolve_source_table.clj:46)"
"query_processor.middleware.parameters$substitute_parameters$fn__46197.invoke(parameters.clj:114)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__44614.invoke(resolve_referenced.clj:80)"
"query_processor.middleware.expand_macros$expand_macros$fn__45229.invoke(expand_macros.clj:158)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__39365.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__47109.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46423$fn__46427.invoke(resolve_database_and_driver.clj:33)"
"driver$do_with_driver.invokeStatic(driver.clj:61)"
"driver$do_with_driver.invoke(driver.clj:57)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46423.invoke(resolve_database_and_driver.clj:27)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__45447.invoke(fetch_source_query.clj:267)"
"query_processor.middleware.store$initialize_store$fn__47118$fn__47119.invoke(store.clj:11)"
"query_processor.store$do_with_store.invokeStatic(store.clj:46)"
"query_processor.store$do_with_store.invoke(store.clj:40)"
"query_processor.middleware.store$initialize_store$fn__47118.invoke(store.clj:10)"
"query_processor.middleware.cache$maybe_return_cached_results$fn__44491.invoke(cache.clj:209)"
"query_processor.middleware.validate$validate_query$fn__47127.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__45545.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__39203.invoke(add_rows_truncated.clj:36)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__47094.invoke(results_metadata.clj:147)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__44850.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__46286.invoke(process_userland_query.clj:136)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__44793.invoke(catch_exceptions.clj:174)"
"query_processor.reducible$async_qp$qp_STAR___38013$thunk__38014.invoke(reducible.clj:101)"
"query_processor.reducible$async_qp$qp_STAR___38013.invoke(reducible.clj:107)"
"query_processor.reducible$sync_qp$qp_STAR___38022$fn__38025.invoke(reducible.clj:133)"
"query_processor.reducible$sync_qp$qp_STAR___38022.invoke(reducible.clj:132)"
"query_processor$process_userland_query.invokeStatic(query_processor.clj:213)"
"query_processor$process_userland_query.doInvoke(query_processor.clj:209)"
"query_processor$fn__47269$process_query_and_save_execution_BANG___47278$fn__47281.invoke(query_processor.clj:225)"
"query_processor$fn__47269$process_query_and_save_execution_BANG___47278.invoke(query_processor.clj:217)"
"query_processor$fn__47313$process_query_and_save_with_max_results_constraints_BANG___47322$fn__47325.invoke(query_processor.clj:237)"
"query_processor$fn__47313$process_query_and_save_with_max_results_constraints_BANG___47322.invoke(query_processor.clj:230)"
"api.dataset$fn__50604$fn__50607.invoke(dataset.clj:54)"
"query_processor.streaming$streaming_response_STAR_$fn__35435$fn__35436.invoke(streaming.clj:73)"
"query_processor.streaming$streaming_response_STAR_$fn__35435.invoke(streaming.clj:72)"
"async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:66)"
"async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:64)"
"async.streaming_response$do_f_async$fn__23249.invoke(streaming_response.clj:85)"],
:state "42703"}],
:json_query
{:type "query",
:query
{:source-table "card__6729",
:joins
[{:fields "all",
:source-table "card__6730",
:condition ["=" ["field-literal" "registration_date" "type/DateTime"] ["joined-field" "Question 6730" ["field-literal" "registration_date" "type/DateTime"]]],
:alias "Question 6730",
:strategy "inner-join"}],
:expressions {:prcnt ["/" ["field-literal" "count" "type/Integer"] ["joined-field" "Question 6730" ["field-literal" "count" "type/Integer"]]]}},
:database 3,
:parameters ,
:middleware {:add-default-userland-constraints? true}},
:native
{:query
"SELECT "source"."registration_date" AS "registration_date", "source"."count" AS "count", "source"."prcnt" AS "prcnt", "source"."registration_date" AS "registration_date_2", "source"."count" AS "count_2" FROM (SELECT (CAST("source"."count" AS float) / CASE WHEN "Question 6730"."count" = 0 THEN NULL ELSE "Question 6730"."count" END) AS "prcnt", "source"."registration_date" AS "registration_date", "Question 6730"."registration_date" AS "registration_date_2", "source"."registration_date" AS "registration_date_3", "source"."user_uid" AS "user_uid", "source"."count" AS "count", "Question 6730"."count" AS "count_2", "source"."deposit_first_date" AS "deposit_first_date" FROM (SELECT date_trunc('month', "rptbi"."sse_client_dm_out"."registration_date") AS "registration_date", count(distinct "rptbi"."sse_client_dm_out"."user_uid") AS "count" FROM "rptbi"."sse_client_dm_out" WHERE ("rptbi"."sse_client_dm_out"."deposit_first_date" IS NOT NULL AND "rptbi"."sse_client_dm_out"."registration_date" BETWEEN ? AND ?) GROUP BY date_trunc('month', "rptbi"."sse_client_dm_out"."registration_date") ORDER BY date_trunc('month', "rptbi"."sse_client_dm_out"."registration_date") ASC) "source" INNER JOIN (SELECT date_trunc('month', "rptbi"."sse_client_dm_out"."registration_date") AS "registration_date", count(distinct "rptbi"."sse_client_dm_out"."user_uid") AS "count" FROM "rptbi"."sse_client_dm_out" WHERE "rptbi"."sse_client_dm_out"."registration_date" BETWEEN ? AND ? GROUP BY date_trunc('month', "rptbi"."sse_client_dm_out"."registration_date")) "Question 6730" ON "source"."registration_date" = "Question 6730"."registration_date") "source" LIMIT 2000",
:params (#t "2020-01-01T00:00Z[GMT]" #t "2020-07-31T00:00Z[GMT]" #t "2020-01-01T00:00Z[GMT]" #t "2020-07-31T00:00Z[GMT]")},
:status :failed,
:class com.vertica.support.exceptions.SyntaxErrorException,
:stacktrace
["com.vertica.util.ServerErrorData.buildException(Unknown Source)"
"com.vertica.io.ProtocolStream.readExpectedMessage(Unknown Source)"
"com.vertica.dataengine.VDataEngine.prepareImpl(Unknown Source)"
"com.vertica.dataengine.VDataEngine.prepare(Unknown Source)"
"com.vertica.dataengine.VDataEngine.prepare(Unknown Source)"
"com.vertica.jdbc.common.SPreparedStatement.(Unknown Source)"
"com.vertica.jdbc.jdbc4.S4PreparedStatement.(Unknown Source)"
"com.vertica.jdbc.VerticaJdbc4PreparedStatementImpl.(Unknown Source)"
"com.vertica.jdbc.VJDBCObjectFactory.createPreparedStatement(Unknown Source)"
"com.vertica.jdbc.common.SConnection.prepareStatement(Unknown Source)"
"com.vertica.jdbc.common.SConnection.prepareStatement(Unknown Source)"
"com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:267)"
"--> driver.sql_jdbc.execute$fn__72446.invokeStatic(execute.clj:239)"
"driver.sql_jdbc.execute$fn__72446.invoke(execute.clj:237)"
"driver.sql_jdbc.execute$prepared_statement_STAR_.invokeStatic(execute.clj:257)"
"driver.sql_jdbc.execute$prepared_statement_STAR_.invoke(execute.clj:254)"
"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:387)"
"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:377)"
"driver.sql_jdbc$fn__73834.invokeStatic(sql_jdbc.clj:49)"
"driver.sql_jdbc$fn__73834.invoke(sql_jdbc.clj:47)"
"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:69)"
"query_processor.context.default$default_runf.invoke(default.clj:67)"
"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__45532.invoke(mbql_to_native.clj:26)"
"query_processor.middleware.check_features$check_features$fn__44834.invoke(check_features.clj:42)"
"query_processor.middleware.optimize_datetime_filters$optimize_datetime_filters$fn__45697.invoke(optimize_datetime_filters.clj:133)"
"query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__47225.invoke(wrap_value_literals.clj:137)"
"query_processor.middleware.annotate$add_column_info$fn__43455.invoke(annotate.clj:574)"
"query_processor.middleware.permissions$check_query_permissions$fn__44709.invoke(permissions.clj:64)"
"query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__46215.invoke(pre_alias_aggregations.clj:40)"
"query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__44907.invoke(cumulative_aggregations.clj:61)"
"query_processor.middleware.resolve_joins$resolve_joins$fn__46747.invoke(resolve_joins.clj:183)"
"query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__39185.invoke(add_implicit_joins.clj:245)"
"query_processor.middleware.limit$limit$fn__45518.invoke(limit.clj:38)"
"query_processor.middleware.format_rows$format_rows$fn__45499.invoke(format_rows.clj:81)"
"query_processor.middleware.desugar$desugar$fn__44973.invoke(desugar.clj:22)"
"query_processor.middleware.binning$update_binning_strategy$fn__43999.invoke(binning.clj:229)"
"query_processor.middleware.resolve_fields$resolve_fields$fn__44515.invoke(resolve_fields.clj:24)"
"query_processor.middleware.add_dimension_projections$add_remapping$fn__38734.invoke(add_dimension_projections.clj:272)"
"query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__38941.invoke(add_implicit_clauses.clj:141)"
"query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__39334.invoke(add_source_metadata.clj:105)"
"query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__46412.invoke(reconcile_breakout_and_order_by_bucketing.clj:98)"
"query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__43640.invoke(auto_bucket_datetimes.clj:125)"
"query_processor.middleware.resolve_source_table$resolve_source_tables$fn__44562.invoke(resolve_source_table.clj:46)"
"query_processor.middleware.parameters$substitute_parameters$fn__46197.invoke(parameters.clj:114)"
"query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__44614.invoke(resolve_referenced.clj:80)"
"query_processor.middleware.expand_macros$expand_macros$fn__45229.invoke(expand_macros.clj:158)"
"query_processor.middleware.add_timezone_info$add_timezone_info$fn__39365.invoke(add_timezone_info.clj:15)"
"query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__47109.invoke(splice_params_in_response.clj:32)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46423$fn__46427.invoke(resolve_database_and_driver.clj:33)"
"driver$do_with_driver.invokeStatic(driver.clj:61)"
"driver$do_with_driver.invoke(driver.clj:57)"
"query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__46423.invoke(resolve_database_and_driver.clj:27)"
"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__45447.invoke(fetch_source_query.clj:267)"
"query_processor.middleware.store$initialize_store$fn__47118$fn__47119.invoke(store.clj:11)"
"query_processor.store$do_with_store.invokeStatic(store.clj:46)"
"query_processor.store$do_with_store.invoke(store.clj:40)"
"query_processor.middleware.store$initialize_store$fn__47118.invoke(store.clj:10)"
"query_processor.middleware.cache$maybe_return_cached_results$fn__44491.invoke(cache.clj:209)"
"query_processor.middleware.validate$validate_query$fn__47127.invoke(validate.clj:10)"
"query_processor.middleware.normalize_query$normalize$fn__45545.invoke(normalize_query.clj:22)"
"query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__39203.invoke(add_rows_truncated.clj:36)"
"query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__47094.invoke(results_metadata.clj:147)"
"query_processor.middleware.constraints$add_default_userland_constraints$fn__44850.invoke(constraints.clj:42)"
"query_processor.middleware.process_userland_query$process_userland_query$fn__46286.invoke(process_userland_query.clj:136)"
"query_processor.middleware.catch_exceptions$catch_exceptions$fn__44793.invoke(catch_exceptions.clj:174)"
"query_processor.reducible$async_qp$qp_STAR___38013$thunk__38014.invoke(reducible.clj:101)"
"query_processor.reducible$async_qp$qp_STAR___38013.invoke(reducible.clj:107)"
"query_processor.reducible$sync_qp$qp_STAR___38022$fn__38025.invoke(reducible.clj:133)"
"query_processor.reducible$sync_qp$qp_STAR___38022.invoke(reducible.clj:132)"
"query_processor$process_userland_query.invokeStatic(query_processor.clj:213)"
"query_processor$process_userland_query.doInvoke(query_processor.clj:209)"
"query_processor$fn__47269$process_query_and_save_execution_BANG___47278$fn__47281.invoke(query_processor.clj:225)"
"query_processor$fn__47269$process_query_and_save_execution_BANG___47278.invoke(query_processor.clj:217)"
"query_processor$fn__47313$process_query_and_save_with_max_results_constraints_BANG___47322$fn__47325.invoke(query_processor.clj:237)"
"query_processor$fn__47313$process_query_and_save_with_max_results_constraints_BANG___47322.invoke(query_processor.clj:230)"
"api.dataset$fn__50604$fn__50607.invoke(dataset.clj:54)"
"query_processor.streaming$streaming_response_STAR_$fn__35435$fn__35436.invoke(streaming.clj:73)"
"query_processor.streaming$streaming_response_STAR_$fn__35435.invoke(streaming.clj:72)"
"async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:66)"
"async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:64)"
"async.streaming_response$do_f_async$fn__23249.invoke(streaming_response.clj:85)"],
:context :ad-hoc,
:error "[Vertica]VJDBC ERROR: Column source.user_uid does not exist",
:row_count 0,
:running_time 0,
:preprocessed
{:type :query,
:query
{:joins
[{:strategy :inner-join,
:condition [:= [:field-literal "registration_date" :type/DateTime] [:joined-field "Question 6730" [:field-literal "registration_date" :type/DateTime]]],
:alias "Question 6730",
:source-query
{:source-table 3183,
:filter [:between [:field-id 79521] [:absolute-datetime #t "2020-01-01T00:00Z[GMT]" :default] [:absolute-datetime #t "2020-07-31T00:00Z[GMT]" :default]],
:aggregation [[:aggregation-options [:distinct [:field-id 79532]] {:name "count"}]],
:breakout [[:datetime-field [:field-id 79521] :month]]},
:source-metadata
[{:base_type :type/DateTime,
:display_name "Registration Date",
:name "registration_date",
:unit "month",
:fingerprint {:global {:distinct-count 2455, :nil% 5.0E-4}, :type {:type/DateTime {:earliest "2009-12-06", :latest "2020-07-07"}}}}
{:base_type :type/Integer,
:display_name "Distinct values of User UID",
:name "count",
:special_type :type/Quantity,
:fingerprint {:global {:distinct-count 7, :nil% 0.0}, :type {:type/Number {:min 77246.0, :q1 107335.25, :q3 185373.5, :max 203013.0, :sd 47951.7245039713, :avg 150769.7142857143}}}}]}],
:expressions {:prcnt [ [:field-literal "count" :type/Integer] [:joined-field "Question 6730" [:field-literal "count" :type/Integer]]]},
:source-query
{:source-table 3183,
:aggregation [[:aggregation-options [:distinct [:field-id 79532]] {:name "count"}]],
:filter
[:and
[:!= [:field-id 79528] [:value nil {:base_type :type/Date, :special_type nil, :database_type "Date", :name "deposit_first_date", :unit :default}]]
[:between [:field-id 79521] [:absolute-datetime #t "2020-01-01T00:00Z[GMT]" :default] [:absolute-datetime #t "2020-07-31T00:00Z[GMT]" :default]]],
:breakout [[:datetime-field [:field-id 79521] :month]],
:order-by [[:asc [:datetime-field [:field-id 79521] :month]]]},
:source-metadata
[{:base_type :type/DateTime,
:display_name "Registration Date",
:name "registration_date",
:unit "month",
:fingerprint {:global {:distinct-count 2455, :nil% 5.0E-4}, :type {:type/DateTime {:earliest "2009-12-06", :latest "2020-07-07"}}}}
{:base_type :type/Integer,
:display_name "Distinct values of User UID",
:name "count",
:special_type :type/Quantity,
:fingerprint {:global {:distinct-count 7, :nil% 0.0}, :type {:type/Number {:min 13323.0, :q1 17833.0, :q3 28548.25, :max 30179.0, :sd 6743.204628859091, :avg 23755.0}}}}],
:fields
[[:field-literal "registration_date" :type/DateTime]
[:field-literal "count" :type/Integer]
[:expression "prcnt"]
[:joined-field "Question 6730" [:field-literal "registration_date" :type/DateTime]]
[:joined-field "Question 6730" [:field-literal "count" :type/Integer]]],
:limit 2000},
:database 3,
:middleware {:add-default-userland-constraints? true},
:info
{:executed-by 474,
:context :ad-hoc,
:card-id 6729,
:nested? true,
:query-hash [-108, 127, 1, 35, -82, 125, 16, -89, 82, -116, -69, -62, 45, -69, -86, 116, -90, 123, -94, 50, 42, 53, -23, 87, -78, 126, -20, -15, -52, 120, -123, -49]},
:constraints {:max-results 10000, :max-results-bare-rows 2000}},
:data {:rows , :cols }}

flamber · September 18, 2020, 12:16pm

@Alisa I was asking for “Diagnostic Info” from Admin > Troubleshooting. Not the logs.
Please read the issues I linked to, I’m sure you’re seeing one of those.

Alisa · September 18, 2020, 12:29pm

Below is the Diagnostic Info:
My issue seems a bit similar, SQL not created correctly, but I wanted to be sure.

{
“browser-info”: {
“language”: “en”,
“platform”: “Win32”,
“userAgent”: “Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.135 Safari/537.36 OPR/70.0.3728.178”,
“vendor”: “Google Inc.”
},
“system-info”: {
“file.encoding”: “UTF-8”,
“java.runtime.name”: “OpenJDK Runtime Environment”,
“java.runtime.version”: “11.0.8+10”,
“java.vendor”: “AdoptOpenJDK”,
“java.vendor.url”: “https://adoptopenjdk.net/”,
“java.version”: “11.0.8”,
“java.vm.name”: “OpenJDK 64-Bit Server VM”,
“java.vm.version”: “11.0.8+10”,
“os.name”: “Linux”,
“os.version”: “4.14.146-119.123.amzn2.x86_64”,
“user.language”: “en”,
“user.timezone”: “GMT”
},
“metabase-info”: {
“databases”: [
“postgres”,
“vertica”
],
“hosting-env”: “unknown”,
“application-database”: “postgres”,
“application-database-details”: {
“database”: {
“name”: “PostgreSQL”,
“version”: “10.5”
},
“jdbc-driver”: {
“name”: “PostgreSQL JDBC Driver”,
“version”: “42.2.8”
}
},
“run-mode”: “prod”,
“version”: {
“date”: “2020-08-17”,
“tag”: “v0.36.4”,
“branch”: “release-0.36.x”,
“hash”: “196c1f6”
},
“settings”: {
“report-timezone”: null
}
}
}