Hello everyone, I am new to Metabase. For some reason, our company starting to use Metabase to visualize our data set and yes Metabase doing a very good job making our life easier. But we meet some challenges when we trying to use Metabase
We have modified the maximum query rows to 5,000,000. Our system spec is 4core 8GB. When every time we trying to open the dataset we meet SQLTransientException. This is the error log.
Appreciate for your help. Thanks
{:database_id 3,
:started_at #t “2020-08-18T02:13:02.464153Z[UTC]”,
:via
[{:status :failed,
:class java.sql.SQLTransientException,
:error “(conn=92803) Query execution was interrupted”,
:stacktrace
[“org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:255)”
“org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:164)”
“org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:258)”
“org.mariadb.jdbc.ClientSidePreparedStatement.executeInternal(ClientSidePreparedStatement.java:225)”
“org.mariadb.jdbc.ClientSidePreparedStatement.execute(ClientSidePreparedStatement.java:145)”
“org.mariadb.jdbc.ClientSidePreparedStatement.executeQuery(ClientSidePreparedStatement.java:159)”
“com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:431)”
“–> driver.sql_jdbc.execute$fn__72670.invokeStatic(execute.clj:267)”
“driver.sql_jdbc.execute$fn__72670.invoke(execute.clj:265)”
“driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:389)”
“driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:377)”
“driver.sql_jdbc$fn__72760.invokeStatic(sql_jdbc.clj:49)”
“driver.sql_jdbc$fn__72760.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__45048.invoke(mbql_to_native.clj:26)”
“query_processor.middleware.check_features$check_features$fn__44350.invoke(check_features.clj:42)”
“query_processor.middleware.optimize_datetime_filters$optimize_datetime_filters$fn__45213.invoke(optimize_datetime_filters.clj:133)”
“query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__46741.invoke(wrap_value_literals.clj:137)”
“query_processor.middleware.annotate$add_column_info$fn__42325.invoke(annotate.clj:574)”
“query_processor.middleware.permissions$check_query_permissions$fn__44225.invoke(permissions.clj:64)”
“query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__45731.invoke(pre_alias_aggregations.clj:40)”
“query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__44423.invoke(cumulative_aggregations.clj:61)”
“query_processor.middleware.resolve_joins$resolve_joins$fn__46263.invoke(resolve_joins.clj:183)”
“query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__37977.invoke(add_implicit_joins.clj:245)”
“query_processor.middleware.limit$limit$fn__45034.invoke(limit.clj:38)”
“query_processor.middleware.format_rows$format_rows$fn__45015.invoke(format_rows.clj:81)”
“query_processor.middleware.desugar$desugar$fn__44489.invoke(desugar.clj:22)”
“query_processor.middleware.binning$update_binning_strategy$fn__42869.invoke(binning.clj:229)”
“query_processor.middleware.resolve_fields$resolve_fields$fn__44031.invoke(resolve_fields.clj:24)”
“query_processor.middleware.add_dimension_projections$add_remapping$fn__37526.invoke(add_dimension_projections.clj:272)”
“query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__37733.invoke(add_implicit_clauses.clj:141)”
“query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__38204.invoke(add_source_metadata.clj:105)”
“query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__45928.invoke(reconcile_breakout_and_order_by_bucketing.clj:98)”
“query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__42510.invoke(auto_bucket_datetimes.clj:125)”
“query_processor.middleware.resolve_source_table$resolve_source_tables$fn__44078.invoke(resolve_source_table.clj:46)”
“query_processor.middleware.parameters$substitute_parameters$fn__45713.invoke(parameters.clj:114)”
“query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__44130.invoke(resolve_referenced.clj:80)”
“query_processor.middleware.expand_macros$expand_macros$fn__44745.invoke(expand_macros.clj:158)”
“query_processor.middleware.add_timezone_info$add_timezone_info$fn__38235.invoke(add_timezone_info.clj:15)”
“query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__46625.invoke(splice_params_in_response.clj:32)”
“query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__45939$fn__45943.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__45939.invoke(resolve_database_and_driver.clj:27)”
“query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__44963.invoke(fetch_source_query.clj:267)”
“query_processor.middleware.store$initialize_store$fn__46634$fn__46635.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__46634.invoke(store.clj:10)”
“query_processor.middleware.cache$maybe_return_cached_results$fn__43361.invoke(cache.clj:209)”
“query_processor.middleware.validate$validate_query$fn__46643.invoke(validate.clj:10)”
“query_processor.middleware.normalize_query$normalize$fn__45061.invoke(normalize_query.clj:22)”
“query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__38073.invoke(add_rows_truncated.clj:36)”
“query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__46610.invoke(results_metadata.clj:147)”
“query_processor.middleware.constraints$add_default_userland_constraints$fn__44366.invoke(constraints.clj:42)”
“query_processor.middleware.process_userland_query$process_userland_query$fn__45802.invoke(process_userland_query.clj:136)”
“query_processor.middleware.catch_exceptions$catch_exceptions$fn__44309.invoke(catch_exceptions.clj:174)”
“query_processor.reducible$async_qp$qp_STAR___21737$thunk__21738.invoke(reducible.clj:101)”
“query_processor.reducible$async_qp$qp_STAR___21737.invoke(reducible.clj:107)”
“query_processor.reducible$sync_qp$qp_STAR___21746$fn__21749.invoke(reducible.clj:133)”
“query_processor.reducible$sync_qp$qp_STAR___21746.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__46785$process_query_and_save_execution_BANG___46794$fn__46797.invoke(query_processor.clj:225)”
“query_processor$fn__46785$process_query_and_save_execution_BANG___46794.invoke(query_processor.clj:217)”
“query_processor$fn__46829$process_query_and_save_with_max_results_constraints_BANG___46838$fn__46841.invoke(query_processor.clj:237)”
“query_processor$fn__46829$process_query_and_save_with_max_results_constraints_BANG___46838.invoke(query_processor.clj:230)”
“api.dataset$fn__60188$fn__60191.invoke(dataset.clj:54)”
“query_processor.streaming$streaming_response_STAR_$fn__34470$fn__34471.invoke(streaming.clj:73)”
“query_processor.streaming$streaming_response_STAR_$fn__34470.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__23771.invoke(streaming_response.clj:85)”],
:state “70100”}],
:state “70100”,
:json_query {:database 3, :query {:source-table 7, :limit 1000000}, :type “query”, :parameters [], :middleware {:add-default-userland-constraints? true}},
:native
{:query
“SELECT rc_authtxn
.AUTHTXN_ADDITIONAL_AMT
AS AUTHTXN_ADDITIONAL_AMT
, rc_authtxn
.AUTHTXN_APPROVAL_CODE
AS AUTHTXN_APPROVAL_CODE
, rc_authtxn
.AUTHTXN_BILL_NO
AS AUTHTXN_BILL_NO
, rc_authtxn
.AUTHTXN_BUSINESS_DATE
AS AUTHTXN_BUSINESS_DATE
, rc_authtxn
.AUTHTXN_CARD_FIID
AS AUTHTXN_CARD_FIID
, rc_authtxn
.AUTHTXN_CARD_NO
AS AUTHTXN_CARD_NO
, rc_authtxn
.AUTHTXN_CURRENCY_ID
AS AUTHTXN_CURRENCY_ID
, rc_authtxn
.AUTHTXN_EDC_SETTLED_IND
AS AUTHTXN_EDC_SETTLED_IND
, rc_authtxn
.AUTHTXN_EXTRA_FIELD
AS AUTHTXN_EXTRA_FIELD
, rc_authtxn
.AUTHTXN_MCC_ID
AS AUTHTXN_MCC_ID
, rc_authtxn
.AUTHTXN_MCCS_DATA
AS AUTHTXN_MCCS_DATA
, rc_authtxn
.AUTHTXN_MEPS_RECON_IND
AS AUTHTXN_MEPS_RECON_IND
, rc_authtxn
.AUTHTXN_MERCHANT_ID
AS AUTHTXN_MERCHANT_ID
, rc_authtxn
.AUTHTXN_MERCHANT_NAME
AS AUTHTXN_MERCHANT_NAME
, rc_authtxn
.AUTHTXN_MTI
AS AUTHTXN_MTI
, rc_authtxn
.AUTHTXN_NO
AS AUTHTXN_NO
, rc_authtxn
.AUTHTXN_POS_ENTRY_CODE
AS AUTHTXN_POS_ENTRY_CODE
, rc_authtxn
.AUTHTXN_POS_ENTRY_MODE
AS AUTHTXN_POS_ENTRY_MODE
, rc_authtxn
.AUTHTXN_PROC_CODE
AS AUTHTXN_PROC_CODE
, rc_authtxn
.AUTHTXN_REMARKS
AS AUTHTXN_REMARKS
, rc_authtxn
.AUTHTXN_REQUEST_AMT
AS AUTHTXN_REQUEST_AMT
, rc_authtxn
.AUTHTXN_REQUEST_DATETIME
AS AUTHTXN_REQUEST_DATETIME
, rc_authtxn
.AUTHTXN_RESPONSE_CODE
AS AUTHTXN_RESPONSE_CODE
, rc_authtxn
.AUTHTXN_RESPONSE_DATETIME
AS AUTHTXN_RESPONSE_DATETIME
, rc_authtxn
.AUTHTXN_RESPONSE_REASON_CODE
AS AUTHTXN_RESPONSE_REASON_CODE
, rc_authtxn
.AUTHTXN_RETRIEVAL_REFNO
AS AUTHTXN_RETRIEVAL_REFNO
, rc_authtxn
.AUTHTXN_SETTLED_DATE
AS AUTHTXN_SETTLED_DATE
, rc_authtxn
.AUTHTXN_STAN
AS AUTHTXN_STAN
, rc_authtxn
.AUTHTXN_TERMINAL_BATCH_NO
AS AUTHTXN_TERMINAL_BATCH_NO
, rc_authtxn
.AUTHTXN_TERMINAL_ID
AS AUTHTXN_TERMINAL_ID
, rc_authtxn
.AUTHTXN_TERMINAL_INVOICE_NO
AS AUTHTXN_TERMINAL_INVOICE_NO
, rc_authtxn
.AUTHTXN_TERMINAL_OWNER
AS AUTHTXN_TERMINAL_OWNER
, rc_authtxn
.AUTHTXN_TRACK2_DATA
AS AUTHTXN_TRACK2_DATA
, rc_authtxn
.AUTHTXN_TXNTYPE_DESCRIPTION
AS AUTHTXN_TXNTYPE_DESCRIPTION
, rc_authtxn
.AUTHTXN_TXNTYPE_ID
AS AUTHTXN_TXNTYPE_ID
, rc_authtxn
.AUTHTXN_TXNTYPE_IND
AS AUTHTXN_TXNTYPE_IND
, rc_authtxn
.MOD_DATE
AS MOD_DATE
, rc_authtxn
.USER_ID
AS USER_ID
, rc_authtxn
.VERSION
AS VERSION
FROM rc_authtxn
LIMIT 1000000”,
:params nil},
:status :failed,
:class java.sql.SQLTransientException,
:stacktrace
[“org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:255)”
“org.mariadb.jdbc.internal.com.read.resultset.SelectResultSet.readNextValue(SelectResultSet.java:379)”
“org.mariadb.jdbc.internal.com.read.resultset.SelectResultSet.fetchAllResults(SelectResultSet.java:282)”
“org.mariadb.jdbc.internal.com.read.resultset.SelectResultSet.(SelectResultSet.java:144)”
“org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readResultSet(AbstractQueryProtocol.java:1755)”
“org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1474)”
“org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1424)”
“org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:240)”
“org.mariadb.jdbc.ClientSidePreparedStatement.executeInternal(ClientSidePreparedStatement.java:216)”
“org.mariadb.jdbc.ClientSidePreparedStatement.execute(ClientSidePreparedStatement.java:145)”
“org.mariadb.jdbc.ClientSidePreparedStatement.executeQuery(ClientSidePreparedStatement.java:159)”
“com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:431)”
“–> driver.sql_jdbc.execute$fn__72670.invokeStatic(execute.clj:267)”
“driver.sql_jdbc.execute$fn__72670.invoke(execute.clj:265)”
“driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:389)”
“driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:377)”
“driver.sql_jdbc$fn__72760.invokeStatic(sql_jdbc.clj:49)”
“driver.sql_jdbc$fn__72760.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__45048.invoke(mbql_to_native.clj:26)”
“query_processor.middleware.check_features$check_features$fn__44350.invoke(check_features.clj:42)”
“query_processor.middleware.optimize_datetime_filters$optimize_datetime_filters$fn__45213.invoke(optimize_datetime_filters.clj:133)”
“query_processor.middleware.wrap_value_literals$wrap_value_literals$fn__46741.invoke(wrap_value_literals.clj:137)”
“query_processor.middleware.annotate$add_column_info$fn__42325.invoke(annotate.clj:574)”
“query_processor.middleware.permissions$check_query_permissions$fn__44225.invoke(permissions.clj:64)”
“query_processor.middleware.pre_alias_aggregations$pre_alias_aggregations$fn__45731.invoke(pre_alias_aggregations.clj:40)”
“query_processor.middleware.cumulative_aggregations$handle_cumulative_aggregations$fn__44423.invoke(cumulative_aggregations.clj:61)”
“query_processor.middleware.resolve_joins$resolve_joins$fn__46263.invoke(resolve_joins.clj:183)”
“query_processor.middleware.add_implicit_joins$add_implicit_joins$fn__37977.invoke(add_implicit_joins.clj:245)”
“query_processor.middleware.limit$limit$fn__45034.invoke(limit.clj:38)”
“query_processor.middleware.format_rows$format_rows$fn__45015.invoke(format_rows.clj:81)”
“query_processor.middleware.desugar$desugar$fn__44489.invoke(desugar.clj:22)”
“query_processor.middleware.binning$update_binning_strategy$fn__42869.invoke(binning.clj:229)”
“query_processor.middleware.resolve_fields$resolve_fields$fn__44031.invoke(resolve_fields.clj:24)”
“query_processor.middleware.add_dimension_projections$add_remapping$fn__37526.invoke(add_dimension_projections.clj:272)”
“query_processor.middleware.add_implicit_clauses$add_implicit_clauses$fn__37733.invoke(add_implicit_clauses.clj:141)”
“query_processor.middleware.add_source_metadata$add_source_metadata_for_source_queries$fn__38204.invoke(add_source_metadata.clj:105)”
“query_processor.middleware.reconcile_breakout_and_order_by_bucketing$reconcile_breakout_and_order_by_bucketing$fn__45928.invoke(reconcile_breakout_and_order_by_bucketing.clj:98)”
“query_processor.middleware.auto_bucket_datetimes$auto_bucket_datetimes$fn__42510.invoke(auto_bucket_datetimes.clj:125)”
“query_processor.middleware.resolve_source_table$resolve_source_tables$fn__44078.invoke(resolve_source_table.clj:46)”
“query_processor.middleware.parameters$substitute_parameters$fn__45713.invoke(parameters.clj:114)”
“query_processor.middleware.resolve_referenced$resolve_referenced_card_resources$fn__44130.invoke(resolve_referenced.clj:80)”
“query_processor.middleware.expand_macros$expand_macros$fn__44745.invoke(expand_macros.clj:158)”
“query_processor.middleware.add_timezone_info$add_timezone_info$fn__38235.invoke(add_timezone_info.clj:15)”
“query_processor.middleware.splice_params_in_response$splice_params_in_response$fn__46625.invoke(splice_params_in_response.clj:32)”
“query_processor.middleware.resolve_database_and_driver$resolve_database_and_driver$fn__45939$fn__45943.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__45939.invoke(resolve_database_and_driver.clj:27)”
“query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__44963.invoke(fetch_source_query.clj:267)”
“query_processor.middleware.store$initialize_store$fn__46634$fn__46635.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__46634.invoke(store.clj:10)”
“query_processor.middleware.cache$maybe_return_cached_results$fn__43361.invoke(cache.clj:209)”
“query_processor.middleware.validate$validate_query$fn__46643.invoke(validate.clj:10)”
“query_processor.middleware.normalize_query$normalize$fn__45061.invoke(normalize_query.clj:22)”
“query_processor.middleware.add_rows_truncated$add_rows_truncated$fn__38073.invoke(add_rows_truncated.clj:36)”
“query_processor.middleware.results_metadata$record_and_return_metadata_BANG_$fn__46610.invoke(results_metadata.clj:147)”
“query_processor.middleware.constraints$add_default_userland_constraints$fn__44366.invoke(constraints.clj:42)”
“query_processor.middleware.process_userland_query$process_userland_query$fn__45802.invoke(process_userland_query.clj:136)”
“query_processor.middleware.catch_exceptions$catch_exceptions$fn__44309.invoke(catch_exceptions.clj:174)”
“query_processor.reducible$async_qp$qp_STAR___21737$thunk__21738.invoke(reducible.clj:101)”
“query_processor.reducible$async_qp$qp_STAR___21737.invoke(reducible.clj:107)”
“query_processor.reducible$sync_qp$qp_STAR___21746$fn__21749.invoke(reducible.clj:133)”
“query_processor.reducible$sync_qp$qp_STAR___21746.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__46785$process_query_and_save_execution_BANG___46794$fn__46797.invoke(query_processor.clj:225)”
“query_processor$fn__46785$process_query_and_save_execution_BANG___46794.invoke(query_processor.clj:217)”
“query_processor$fn__46829$process_query_and_save_with_max_results_constraints_BANG___46838$fn__46841.invoke(query_processor.clj:237)”
“query_processor$fn__46829$process_query_and_save_with_max_results_constraints_BANG___46838.invoke(query_processor.clj:230)”
“api.dataset$fn__60188$fn__60191.invoke(dataset.clj:54)”
“query_processor.streaming$streaming_response_STAR_$fn__34470$fn__34471.invoke(streaming.clj:73)”
“query_processor.streaming$streaming_response_STAR_$fn__34470.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__23771.invoke(streaming_response.clj:85)”],
:context :ad-hoc,
:error “Query execution was interrupted”,
:row_count 0,
:running_time 0,
:preprocessed
{:database 3,
:query
{:source-table 7,
:limit 1000000,
:fields
[[:field-id 175]
[:field-id 143]
[:field-id 159]
[:datetime-field [:field-id 150] :default]
[:field-id 144]
[:field-id 165]
[:field-id 141]
[:field-id 164]
[:field-id 167]
[:field-id 161]
[:field-id 156]
[:field-id 174]
[:field-id 142]
[:field-id 147]
[:field-id 171]
[:field-id 152]
[:field-id 140]
[:field-id 154]
[:field-id 166]
[:field-id 146]
[:field-id 148]
[:datetime-field [:field-id 158] :default]
[:field-id 145]
[:datetime-field [:field-id 155] :default]
[:field-id 153]
[:field-id 176]
[:datetime-field [:field-id 177] :default]
[:field-id 162]
[:field-id 157]
[:field-id 172]
[:field-id 168]
[:field-id 173]
[:field-id 151]
[:field-id 149]
[:field-id 160]
[:field-id 169]
[:datetime-field [:field-id 163] :default]
[:field-id 170]
[:field-id 178]]},
:type :query,
:middleware {:add-default-userland-constraints? true},
:info
{:executed-by 1,
:context :ad-hoc,
:nested? false,
:query-hash [-112, 44, -81, -88, 119, -54, -58, -103, -75, -32, -10, -80, 82, 53, 63, -75, -48, -5, 107, -59, -37, -101, -34, -42, 16, -81, -53, -125, 104, 29, -124, 99]},
:constraints {:max-results 5000000, :max-results-bare-rows 5000000}},
:data {:rows [], :cols []}}