Invalid input syntax error

shrey · January 11, 2024, 6:30am

I keep running into this error, due to which my model is not working properly, leading to charts & dashboards also not working.

Error:

ERROR: invalid input syntax for type bigint: "0.384"

Now, in my db table, there's only 1 column which is 'bigint', which is the the primary key:

I've also tried to identify the responsible record in the table, by running the query:

select * from logs where "id" = 0.384;

but this yields 0 results.

Then why am i getting the error?

I have already deleted field values and resynced the table multiple times.

Luiggi · January 11, 2024, 11:28am

Please post troubleshooting info and the queries

shrey · January 11, 2024, 3:23pm

@Luiggi

Action: Navigated to the 'Edit metadata' page of a Model.

Logs:

Jan 11 20:49:472024-01-11 15:19:47,467 DEBUG middleware.log :: GET /api/user/current 200 23.5 ms (10 DB calls) App DB connections: 0/15 Jetty threads: 6/50 (8 idle, 0 queued) (131 total active threads) Queries in flight: 0 (0 queued)
Jan 11 20:49:472024-01-11 15:19:47,619 DEBUG middleware.log :: GET /api/bookmark 200 3.9 ms (1 DB calls) App DB connections: 0/15 Jetty threads: 6/50 (8 idle, 0 queued) (133 total active threads) Queries in flight: 0 (0 queued)
Jan 11 20:49:472024-01-11 15:19:47,627 DEBUG middleware.log :: GET /api/database 200 9.6 ms (3 DB calls) App DB connections: 0/15 Jetty threads: 5/50 (8 idle, 0 queued) (133 total active threads) Queries in flight: 0 (0 queued)
Jan 11 20:49:472024-01-11 15:19:47,747 DEBUG middleware.log :: GET /api/timeline 200 4.7 ms (3 DB calls) App DB connections: 1/15 Jetty threads: 6/50 (8 idle, 0 queued) (133 total active threads) Queries in flight: 0 (0 queued)
Jan 11 20:49:472024-01-11 15:19:47,779 DEBUG middleware.log :: GET /api/card/36 200 34.6 ms (14 DB calls) App DB connections: 1/15 Jetty threads: 5/50 (8 idle, 0 queued) (133 total active threads) Queries in flight: 0 (0 queued)
Jan 11 20:49:472024-01-11 15:19:47,855 DEBUG middleware.log :: GET /api/alert/question/36 200 2.1 ms (1 DB calls) App DB connections: 0/15 Jetty threads: 5/50 (8 idle, 0 queued) (133 total active threads) Queries in flight: 0 (0 queued)
Jan 11 20:49:472024-01-11 15:19:47,869 DEBUG middleware.log :: GET /api/database/2/schemas 200 12.1 ms (4 DB calls) App DB connections: 0/15 Jetty threads: 7/50 (8 idle, 0 queued) (133 total active threads) Queries in flight: 0 (0 queued)
Jan 11 20:49:472024-01-11 15:19:47,887 DEBUG middleware.log :: GET /api/table/card__36/query_metadata 200 17.7 ms (7 DB calls) App DB connections: 1/15 Jetty threads: 6/50 (8 idle, 0 queued) (133 total active threads) Queries in flight: 0 (0 queued)
Jan 11 20:49:472024-01-11 15:19:47,925 DEBUG middleware.log :: GET /api/table/5/query_metadata 200 64.5 ms (9 DB calls) App DB connections: 0/15 Jetty threads: 5/50 (8 idle, 0 queued) (133 total active threads) Queries in flight: 0 (0 queued)
Jan 11 20:49:482024-01-11 15:19:48,074 DEBUG middleware.log :: GET /api/model-index 200 17.1 ms (4 DB calls) App DB connections: 0/15 Jetty threads: 5/50 (8 idle, 0 queued) (133 total active threads) Queries in flight: 0 (0 queued)
Jan 11 20:49:522024-01-11 15:19:52,825 ERROR middleware.catch-exceptions :: Error processing query: ERROR: invalid input syntax for type bigint: "0.384"
Jan 11 20:49:52{:database_id 2,
Jan 11 20:49:52:started_at #t "2024-01-11T15:19:48.205045Z[Etc/UTC]",
Jan 11 20:49:52:via
Jan 11 20:49:52[{:status :failed,
Jan 11 20:49:52:class clojure.lang.ExceptionInfo,
Jan 11 20:49:52:error "Error executing query: ERROR: invalid input syntax for type bigint: \"0.384\"",
Jan 11 20:49:52:stacktrace
Jan 11 20:49:52["--> driver.sql_jdbc.execute$execute_reducible_query$fn__81096$fn__81097.invoke(execute.clj:698)"
Jan 11 20:49:52"driver.sql_jdbc.execute$execute_reducible_query$fn__81096.invoke(execute.clj:695)"
Jan 11 20:49:52"driver.sql_jdbc.execute$fn__80891$fn__80892.invoke(execute.clj:388)"
Jan 11 20:49:52"driver.sql_jdbc.execute$fn__80856$_AMPERSAND_f__80857.invoke(execute.clj:334)"
Jan 11 20:49:52"driver.sql_jdbc.execute$fn__80856$fn__80860.invoke(execute.clj:317)"
Jan 11 20:49:52"driver.sql_jdbc.execute$fn__80891.invokeStatic(execute.clj:382)"
Jan 11 20:49:52"driver.sql_jdbc.execute$fn__80891.invoke(execute.clj:380)"
Jan 11 20:49:52"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:689)"
Jan 11 20:49:52"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:678)"
Jan 11 20:49:52"driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:686)"
Jan 11 20:49:52"driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:678)"
Jan 11 20:49:52"driver.sql_jdbc$fn__109979.invokeStatic(sql_jdbc.clj:82)"
Jan 11 20:49:52"driver.sql_jdbc$fn__109979.invoke(sql_jdbc.clj:80)"
Jan 11 20:49:52"query_processor.context$executef.invokeStatic(context.clj:60)"
Jan 11 20:49:52"query_processor.context$executef.invoke(context.clj:49)"
Jan 11 20:49:52"query_processor.context.default$default_runf.invokeStatic(default.clj:44)"
Jan 11 20:49:52"query_processor.context.default$default_runf.invoke(default.clj:42)"
Jan 11 20:49:52"query_processor.context$runf.invokeStatic(context.clj:46)"
Jan 11 20:49:52"query_processor.context$runf.invoke(context.clj:40)"
Jan 11 20:49:52"query_processor.reducible$identity_qp.invokeStatic(reducible.clj:39)"
Jan 11 20:49:52"query_processor.reducible$identity_qp.invoke(reducible.clj:36)"
Jan 11 20:49:52"query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___73881.invoke(cache.clj:229)"
Jan 11 20:49:52"query_processor.middleware.permissions$check_query_permissions$fn__67586.invoke(permissions.clj:140)"
Jan 11 20:49:52"query_processor.middleware.enterprise$check_download_permissions_middleware$fn__73692.invoke(enterprise.clj:51)"
Jan 11 20:49:52"query_processor.middleware.enterprise$maybe_apply_column_level_perms_check_middleware$fn__73702.invoke(enterprise.clj:64)"
Jan 11 20:49:52"query_processor.middleware.mbql_to_native$mbql__GT_native$fn__72844.invoke(mbql_to_native.clj:24)"
Jan 11 20:49:52"query_processor$fn__75084$combined_post_process__75089$combined_post_process_STAR___75090.invoke(query_processor.clj:261)"
Jan 11 20:49:52"query_processor$fn__75084$combined_pre_process__75085$combined_pre_process_STAR___75086.invoke(query_processor.clj:258)"
Jan 11 20:49:52"query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__67713.invoke(fetch_source_query.clj:303)"
Jan 11 20:49:52"query_processor.middleware.resolve_database_and_driver$resolve_driver_and_database_local_values$fn__73792$fn__73796.invoke(resolve_database_and_driver.clj:77)"
Jan 11 20:49:52"driver$do_with_driver.invokeStatic(driver.clj:94)"
Jan 11 20:49:52"driver$do_with_driver.invoke(driver.clj:89)"
Jan 11 20:49:52"query_processor.middleware.resolve_database_and_driver$resolve_driver_and_database_local_values$fn__73792.invoke(resolve_database_and_driver.clj:76)"
Jan 11 20:49:52"query_processor.middleware.store$initialize_store$fn__68130$fn__68131.invoke(store.clj:14)"
Jan 11 20:49:52"query_processor.store$do_with_metadata_provider.invokeStatic(store.clj:169)"
Jan 11 20:49:52"query_processor.store$do_with_metadata_provider.invoke(store.clj:150)"
Jan 11 20:49:52"query_processor.store$do_with_metadata_provider.invokeStatic(store.clj:158)"
Jan 11 20:49:52"query_processor.store$do_with_metadata_provider.invoke(store.clj:150)"
Jan 11 20:49:52"query_processor.middleware.store$initialize_store$fn__68130.invoke(store.clj:13)"
Jan 11 20:49:52"query_processor.middleware.resolve_database_and_driver$resolve_database$fn__73789.invoke(resolve_database_and_driver.clj:60)"
Jan 11 20:49:52"query_processor.middleware.normalize_query$normalize$fn__74099.invoke(normalize_query.clj:38)"
Jan 11 20:49:52"query_processor.middleware.enterprise$fn__73719$handle_audit_app_internal_queries__73720$fn__73722.invoke(enterprise.clj:96)"
Jan 11 20:49:52"query_processor.middleware.enterprise$handle_audit_app_internal_queries_middleware$fn__73730.invoke(enterprise.clj:103)"
Jan 11 20:49:52"query_processor.middleware.constraints$add_default_userland_constraints$fn__70703.invoke(constraints.clj:81)"
Jan 11 20:49:52"query_processor.middleware.process_userland_query$process_userland_query$fn__74030.invoke(process_userland_query.clj:156)"
Jan 11 20:49:52"query_processor.middleware.catch_exceptions$catch_exceptions$fn__74628.invoke(catch_exceptions.clj:171)"
Jan 11 20:49:52"query_processor.reducible$async_qp$qp_STAR___62560$thunk__62562.invoke(reducible.clj:126)"
Jan 11 20:49:52"query_processor.reducible$async_qp$qp_STAR___62560$fn__62564.invoke(reducible.clj:131)"],
Jan 11 20:49:52:error_type :invalid-query,
Jan 11 20:49:52:ex-data
Jan 11 20:49:52{:driver :postgres,
Jan 11 20:49:52:sql
Jan 11 20:49:52["-- Metabase:: userID: 1 queryType: MBQL queryHash: d381aa35472f1dea138070af7378c14d98df604ae9af37c2b03f764791587a83"
Jan 11 20:49:52"SELECT"
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ? ] :: text [ ]) :: text AS \"device_meta → connection\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ? ] :: text [ ]) :: double precision AS \"device_meta → connection → downlink\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ? ] :: text [ ]) :: bigint AS \"device_meta → connection → downlinkMax\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ? ] :: text [ ]) :: text AS \"device_meta → connection → effectiveType\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ? ] :: text [ ]) :: bigint AS \"device_meta → connection → rtt\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ? ] :: text [ ]) :: text AS \"device_meta → connection → type\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ? ] :: text [ ]) :: text AS \"device_meta → displayMode\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ? ] :: text [ ]) :: text AS \"device_meta → getInstalledRelatedApps\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ? ] :: text [ ]) :: text AS \"device_meta → languages\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ? ] :: text [ ]) :: boolean AS \"device_meta → onLine\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ?, ? ] :: text [ ]) :: bigint AS \"device_meta → reverseGeo → city → geoname_id\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ?, ?, ? ] :: text [ ]) :: text AS \"device_meta → reverseGeo → city → names → de\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ?, ?, ? ] :: text [ ]) :: text AS \"device_meta → reverseGeo → city → names → en\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ?, ?, ? ] :: text [ ]) :: text AS \"device_meta → reverseGeo → city → names → es\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ?, ?, ? ] :: text [ ]) :: text AS \"device_meta → reverseGeo → city → names → fr\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ?, ?, ? ] :: text [ ]) :: text AS \"device_meta → reverseGeo → city → names → ja\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ?, ?, ? ] :: text [ ]) :: text AS \"device_meta → reverseGeo → city → names → pt-BR\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ?, ?, ? ] :: text [ ]) :: text AS \"device_meta → reverseGeo → city → names → ru\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ?, ?, ? ] :: text [ ]) :: text AS \"device_meta → reverseGeo → city → names → zh-CN\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ?, ? ] :: text [ ]) :: text AS \"device_meta → reverseGeo → continent → code\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ?, ? ] :: text [ ]) :: bigint AS \"device_meta → reverseGeo → continent → geoname_id\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ?, ? ] :: text [ ]) :: text AS \"device_meta → reverseGeo → continent → names\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ?, ?, ? ] :: text [ ]) :: text AS \"device_meta → reverseGeo → continent → names → de\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ?, ?, ? ] :: text [ ]) :: text AS \"device_meta → reverseGeo → continent → names → en\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ?, ?, ? ] :: text [ ]) :: text AS \"device_meta → reverseGeo → continent → names → es\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ?, ?, ? ] :: text [ ]) :: text AS \"device_meta → reverseGeo → continent → names → fr\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ?, ?, ? ] :: text [ ]) :: text AS \"device_meta → reverseGeo → continent → names → ja\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ?, ?, ? ] :: text [ ]) :: text AS \"device_meta → reverseGeo → continent → names → pt-BR\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ?, ?, ? ] :: text [ ]) :: text AS \"device_meta → reverseGeo → continent → names → ru\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ?, ?, ? ] :: text [ ]) :: text AS \"device_meta → reverseGeo → continent → names → zh-CN\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ?, ? ] :: text [ ]) :: bigint AS \"device_meta → reverseGeo → country → geoname_id\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ?, ? ] :: text [ ]) :: text AS \"device_meta → reverseGeo → country → iso_code\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ?, ? ] :: text [ ]) :: text AS \"device_meta → reverseGeo → country → names\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ?, ?, ? ] :: text [ ]) :: text AS \"device_meta → reverseGeo → country → names → de\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ?, ?, ? ] :: text [ ]) :: text AS \"device_meta → reverseGeo → country → names → en\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ?, ?, ? ] :: text [ ]) :: text AS \"device_meta → reverseGeo → country → names → es\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ?, ?, ? ] :: text [ ]) :: text AS \"device_meta → reverseGeo → country → names → fr\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ?, ?, ? ] :: text [ ]) :: text AS \"device_meta → reverseGeo → country → names → ja\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ?, ?, ? ] :: text [ ]) :: text AS \"device_meta → reverseGeo → country → names → pt-BR\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ?, ?, ? ] :: text [ ]) :: text AS \"device_meta → reverseGeo → country → names → ru\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ?, ?, ? ] :: text [ ]) :: text AS \"device_meta → reverseGeo → country → names → zh-CN\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ?, ? ] :: text [ ]) :: bigint AS \"device_meta → reverseGeo → location → accuracy_radius\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ?, ? ] :: text [ ]) :: double precision AS \"device_meta → reverseGeo → location → latitude\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ?, ? ] :: text [ ]) :: double precision AS \"device_meta → reverseGeo → location → longitude\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ?, ? ] :: text [ ]) :: text AS \"device_meta → reverseGeo → location → time_zone\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ?, ? ] :: text [ ]) :: text AS \"device_meta → reverseGeo → postal → code\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ?, ? ] :: text [ ]) :: bigint AS \"device_meta → reverseGeo → registered_country _4b835e0b\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ?, ? ] :: text [ ]) :: text AS \"device_meta → reverseGeo → registered_country _1c532f71\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ?, ? ] :: text [ ]) :: text AS \"device_meta → reverseGeo → registered_country → names\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ?, ?, ? ] :: text [ ]) :: text AS \"device_meta → reverseGeo → registered_country _03816fde\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ?, ?, ? ] :: text [ ]) :: text AS \"device_meta → reverseGeo → registered_country _8d488717\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ?, ?, ? ] :: text [ ]) :: text AS \"device_meta → reverseGeo → registered_country _ee4eebce\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ?, ?, ? ] :: text [ ]) :: text AS \"device_meta → reverseGeo → registered_country _b264889b\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ?, ?, ? ] :: text [ ]) :: text AS \"device_meta → reverseGeo → registered_country _9a6f8649\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ?, ?, ? ] :: text [ ]) :: text AS \"device_meta → reverseGeo → registered_country _0af6cca1\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ?, ?, ? ] :: text [ ]) :: text AS \"device_meta → reverseGeo → registered_country _02aeca6d\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ?, ?, ? ] :: text [ ]) :: text AS \"device_meta → reverseGeo → registered_country _57935129\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ? ] :: text [ ]) :: text AS \"device_meta → reverseGeo → subdivisions\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ? ] :: text [ ]) :: text AS \"device_meta → software_version\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ? ] :: text [ ]) :: text AS \"device_meta → userAgent\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ? ] :: text [ ]) :: text AS \"device_meta → userAgentData → brands\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ? ] :: text [ ]) :: boolean AS \"device_meta → userAgentData → mobile\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ?, ? ] :: text [ ]) :: text AS \"device_meta → userAgentData → platform\","
Jan 11 20:49:52" (\"source\".\"device_meta\" #>> array [ ? ] :: text [ ]) :: text AS \"device_meta → uuid\","
Jan 11 20:49:52" (\"source\".\"headers\" #>> array [ ? ] :: text [ ]) :: text AS \"headers → accept\","
Jan 11 20:49:52" (\"source\".\"headers\" #>> array [ ? ] :: text [ ]) :: text AS \"headers → accept-encoding\","
Jan 11 20:49:52" (\"source\".\"headers\" #>> array [ ? ] :: text [ ]) :: text AS \"headers → accept-language\","
Jan 11 20:49:52" (\"source\".\"headers\" #>> array [ ? ] :: text [ ]) :: text AS \"headers → connection\","
Jan 11 20:49:52" (\"source\".\"headers\" #>> array [ ? ] :: text [ ]) :: text AS \"headers → dnt\","
Jan 11 20:49:52" (\"source\".\"headers\" #>> array [ ? ] :: text [ ]) :: text AS \"headers → host\","
Jan 11 20:49:52" (\"source\".\"headers\" #>> array [ ? ] :: text [ ]) :: text AS \"headers → if-none-match\","
Jan 11 20:49:52" (\"source\".\"headers\" #>> array [ ? ] :: text [ ]) :: text AS \"headers → origin\","
Jan 11 20:49:52" (\"source\".\"headers\" #>> array [ ? ] :: text [ ]) :: text AS \"headers → referer\","
Jan 11 20:49:52" (\"source\".\"headers\" #>> array [ ? ] :: text [ ]) :: text AS \"headers → save-data\","
Jan 11 20:49:52" (\"source\".\"headers\" #>> array [ ? ] :: text [ ]) :: text AS \"headers → sec-ch-ua\","
Jan 11 20:49:52" (\"source\".\"headers\" #>> array [ ? ] :: text [ ]) :: text AS \"headers → sec-ch-ua-mobile\","
Jan 11 20:49:52" (\"source\".\"headers\" #>> array [ ? ] :: text [ ]) :: text AS \"headers → sec-ch-ua-platform\","
Jan 11 20:49:52" (\"source\".\"headers\" #>> array [ ? ] :: text [ ]) :: text AS \"headers → sec-fetch-dest\","
Jan 11 20:49:52" (\"source\".\"headers\" #>> array [ ? ] :: text [ ]) :: text AS \"headers → sec-fetch-mode\","
Jan 11 20:49:52" (\"source\".\"headers\" #>> array [ ? ] :: text [ ]) :: text AS \"headers → sec-fetch-site\","
Jan 11 20:49:52" (\"source\".\"headers\" #>> array [ ? ] :: text [ ]) :: text AS \"headers → sec-gpc\","
Jan 11 20:49:52" (\"source\".\"headers\" #>> array [ ? ] :: text [ ]) :: text AS \"headers → te\","
Jan 11 20:49:52" (\"source\".\"headers\" #>> array [ ? ] :: text [ ]) :: text AS \"headers → user-agent\","
Jan 11 20:49:52" (\"source\".\"headers\" #>> array [ ? ] :: text [ ]) :: text AS \"headers → x-forwarded-for\","
Jan 11 20:49:52" (\"source\".\"headers\" #>> array [ ? ] :: text [ ]) :: text AS \"headers → x-forwarded-host\","
Jan 11 20:49:52" (\"source\".\"headers\" #>> array [ ? ] :: text [ ]) :: text AS \"headers → x-forwarded-port\","
Jan 11 20:49:52" (\"source\".\"headers\" #>> array [ ? ] :: text [ ]) :: text AS \"headers → x-forwarded-proto\","
Jan 11 20:49:52" (\"source\".\"headers\" #>> array [ ? ] :: text [ ]) :: text AS \"headers → x-forwarded-server\","
Jan 11 20:49:52" (\"source\".\"headers\" #>> array [ ? ] :: text [ ]) :: text AS \"headers → x-real-ip\","
Jan 11 20:49:52" \"source\".\"id\" AS \"id\","
Jan 11 20:49:52" \"source\".\"createdAt\" AS \"createdAt\","
Jan 11 20:49:52" \"source\".\"headers\" AS \"headers\","
Jan 11 20:49:52" \"source\".\"query\" AS \"query\","
Jan 11 20:49:52" \"source\".\"network_type\" AS \"network_type\","
Jan 11 20:49:52" \"source\".\"software_version\" AS \"software_version\","
Jan 11 20:49:52" \"source\".\"device_meta\" AS \"device_meta\","
Jan 11 20:49:52" \"source\".\"source\" AS \"source\","
Jan 11 20:49:52" \"source\".\"CreatedAt (IST)\" AS \"CreatedAt (IST)\""
Jan 11 20:49:52"FROM"
Jan 11 20:49:52" ("
Jan 11 20:49:52" SELECT"
Jan 11 20:49:52" (\"public\".\"logs\".\"device_meta\" #>> array [ ? ] :: text [ ]) :: text AS \"device_meta → connection\","
Jan 11 20:49:52" ("
Jan 11 20:49:52" \"public\".\"logs\".\"device_meta\" #>> array [ ?,"
Jan 11 20:49:52" ? ] :: text [ ]"
Jan 11 20:49:52" ) :: double precision AS \"device_meta → connection → downlink\","
Jan 11 20:49:52" ("
Jan 11 20:49:52" \"public\".\"logs\".\"device_meta\" #>> array [ ?,"
Jan 11 20:49:52" ? ] :: text [ ]"
Jan 11 20:49:52" ) :: bigint AS \"device_meta → connection → downlinkMax\","
Jan 11 20:49:52" ("
Jan 11 20:49:52" \"public\".\"logs\".\"device_meta\" #>> array [ ?,"
Jan 11 20:49:52" ? ] :: text [ ]"
Jan 11 20:49:52" ?,"
Jan 11 20:49:52" ? ] :: text [ ]"
Jan 11 20:49:52" ) :: text AS \"device_meta → reverseGeo → city → names → ja\","
Jan 11 20:49:52" ("
Jan 11 20:49:52" \"public\".\"logs\".\"device_meta\" #>> array [ ?,"
Jan 11 20:49:52" ?,"
Jan 11 20:49:52" ?,"
Jan 11 20:49:52" ? ] :: text [ ]"
Jan 11 20:49:52" ) :: text AS \"device_meta → reverseGeo → city → names → pt-BR\","
Jan 11 20:49:52" ("
Jan 11 20:49:52" \"public\".\"logs\".\"device_meta\" #>> array [ ?,"
Jan 11 20:49:52" ?,"
Jan 11 20:49:52" ?,"
Jan 11 20:49:52" ? ] :: text [ ]"
Jan 11 20:49:52" ) :: text AS \"device_meta → reverseGeo → city → names → ru\","
Jan 11 20:49:52" ("
Jan 11 20:49:52" \"public\".\"logs\".\"device_meta\" #>> array [ ?,"
Jan 11 20:49:52" ?,"
Jan 11 20:49:52" ?,"
Jan 11 20:49:52" ? ] :: text [ ]"
Jan 11 20:49:52" ) :: text AS \"device_meta → reverseGeo → city → names → zh-CN\","
Jan 11 20:49:52" ("
Jan 11 20:49:52" \"public\".\"logs\".\"device_meta\" #>> array [ ?,"
Jan 11 20:49:52" ?,"
Jan 11 20:49:52" ? ] :: text [ ]"
Jan 11 20:49:52" ) :: text AS \"device_meta → reverseGeo → continent → code\","
Jan 11 20:49:52" ("
Jan 11 20:49:52" \"public\".\"logs\".\"device_meta\" #>> array [ ?,"
Jan 11 20:49:52" ?,"
Jan 11 20:49:52" ? ] :: text [ ]"
Jan 11 20:49:52" ) :: bigint AS \"device_meta → reverseGeo → continent → geoname_id\","
Jan 11 20:49:52" ("
Jan 11 20:49:52" \"public\".\"logs\".\"device_meta\" #>> array [ ?,"
Jan 11 20:49:52" ?,"
Jan 11 20:49:52" ? ] :: text [ ]"
Jan 11 20:49:52" ) :: text AS \"device_meta → reverseGeo → continent → names\","
Jan 11 20:49:52" ("
Jan 11 20:49:52" \"public\".\"logs\".\"device_meta\" #>> array [ ?,"
Jan 11 20:49:52" ?,"
Jan 11 20:49:52" ?,"
Jan 11 20:49:52" ? ] :: text [ ]"
Jan 11 20:49:52" ) :: text AS \"device_meta → reverseGeo → continent → names → de\","
Jan 11 20:49:52" ("
Jan 11 20:49:52" \"public\".\"logs\".\"device_meta\" #>> array [ ?,"
Jan 11 20:49:52" ?,"
Jan 11 20:49:52" ?,"
Jan 11 20:49:52" ? ] :: text [ ]"
Jan 11 20:49:52" (\"public\".\"logs\".\"device_meta\" #>> array [ ? ] :: text [ ]) :: text AS \"device_meta → software_version\","
Jan 11 20:49:52" (\"public\".\"logs\".\"device_meta\" #>> array [ ? ] :: text [ ]) :: text AS \"device_meta → userAgent\","
Jan 11 20:49:52" ("
Jan 11 20:49:52" \"public\".\"logs\".\"device_meta\" #>> array [ ?,"
Jan 11 20:49:52" ? ] :: text [ ]"
Jan 11 20:49:52" ) :: text AS \"device_meta → userAgentData → brands\","
Jan 11 20:49:52" ("
Jan 11 20:49:52" \"public\".\"logs\".\"device_meta\" #>> array [ ?,"
Jan 11 20:49:52" ? ] :: text [ ]"
Jan 11 20:49:52" ) :: boolean AS \"device_meta → userAgentData → mobile\","
Jan 11 20:49:52" ("
Jan 11 20:49:52" \"public\".\"logs\".\"device_meta\" #>> array [ ?,"
Jan 11 20:49:52" ? ] :: text [ ]"
Jan 11 20:49:52" ) :: text AS \"device_meta → userAgentData → platform\","
Jan 11 20:49:52" (\"public\".\"logs\".\"device_meta\" #>> array [ ? ] :: text [ ]) :: text AS \"device_meta → uuid\","
Jan 11 20:49:52" (\"public\".\"logs\".\"headers\" #>> array [ ? ] :: text [ ]) :: text AS \"headers → accept\","
Jan 11 20:49:52" (\"public\".\"logs\".\"headers\" #>> array [ ? ] :: text [ ]) :: text AS \"headers → accept-encoding\","
Jan 11 20:49:52" (\"public\".\"logs\".\"headers\" #>> array [ ? ] :: text [ ]) :: text AS \"headers → accept-language\","
Jan 11 20:49:52" (\"public\".\"logs\".\"headers\" #>> array [ ? ] :: text [ ]) :: text AS \"headers → connection\","
Jan 11 20:49:52" (\"public\".\"logs\".\"headers\" #>> array [ ? ] :: text [ ]) :: text AS \"headers → dnt\","
Jan 11 20:49:52" (\"public\".\"logs\".\"headers\" #>> array [ ? ] :: text [ ]) :: text AS \"headers → host\","
Jan 11 20:49:52" (\"public\".\"logs\".\"headers\" #>> array [ ? ] :: text [ ]) :: text AS \"headers → if-none-match\","
Jan 11 20:49:52" (\"public\".\"logs\".\"headers\" #>> array [ ? ] :: text [ ]) :: text AS \"headers → origin\","
Jan 11 20:49:52" (\"public\".\"logs\".\"headers\" #>> array [ ? ] :: text [ ]) :: text AS \"headers → referer\","
Jan 11 20:49:52" (\"public\".\"logs\".\"headers\" #>> array [ ? ] :: text [ ]) :: text AS \"headers → save-data\","
Jan 11 20:49:52" (\"public\".\"logs\".\"headers\" #>> array [ ? ] :: text [ ]) :: text AS \"headers → sec-ch-ua\","
Jan 11 20:49:52" (\"public\".\"logs\".\"headers\" #>> array [ ? ] :: text [ ]) :: text AS \"headers → sec-ch-ua-mobile\","
Jan 11 20:49:52" (\"public\".\"logs\".\"headers\" #>> array [ ? ] :: text [ ]) :: text AS \"headers → sec-ch-ua-platform\","
Jan 11 20:49:52" (\"public\".\"logs\".\"headers\" #>> array [ ? ] :: text [ ]) :: text AS \"headers → sec-fetch-dest\","
Jan 11 20:49:52" (\"public\".\"logs\".\"headers\" #>> array [ ? ] :: text [ ]) :: text AS \"headers → sec-fetch-mode\","
Jan 11 20:49:52" (\"public\".\"logs\".\"headers\" #>> array [ ? ] :: text [ ]) :: text AS \"headers → sec-fetch-site\","
Jan 11 20:49:52" (\"public\".\"logs\".\"headers\" #>> array [ ? ] :: text [ ]) :: text AS \"headers → sec-gpc\","
Jan 11 20:49:52" (\"public\".\"logs\".\"headers\" #>> array [ ? ] :: text [ ]) :: text AS \"headers → te\","
Jan 11 20:49:52" (\"public\".\"logs\".\"headers\" #>> array [ ? ] :: text [ ]) :: text AS \"headers → user-agent\","
Jan 11 20:49:52" (\"public\".\"logs\".\"headers\" #>> array [ ? ] :: text [ ]) :: text AS \"headers → x-forwarded-for\","
Jan 11 20:49:52" (\"public\".\"logs\".\"headers\" #>> array [ ? ] :: text [ ]) :: text AS \"headers → x-forwarded-host\","
Jan 11 20:49:52" (\"public\".\"logs\".\"headers\" #>> array [ ? ] :: text [ ]) :: text AS \"headers → x-forwarded-port\","
Jan 11 20:49:52" (\"public\".\"logs\".\"headers\" #>> array [ ? ] :: text [ ]) :: text AS \"headers → x-forwarded-proto\","
Jan 11 20:49:52" (\"public\".\"logs\".\"headers\" #>> array [ ? ] :: text [ ]) :: text AS \"headers → x-forwarded-server\","
Jan 11 20:49:52" (\"public\".\"logs\".\"headers\" #>> array [ ? ] :: text [ ]) :: text AS \"headers → x-real-ip\","
Jan 11 20:49:52" \"public\".\"logs\".\"id\" AS \"id\","
Jan 11 20:49:52" \"public\".\"logs\".\"createdAt\" AS \"createdAt\","
Jan 11 20:49:52" \"public\".\"logs\".\"headers\" AS \"headers\","
Jan 11 20:49:52:parameters [],
Jan 11 20:49:52:async? true,
Jan 11 20:49:52:cache-ttl nil},
Jan 11 20:49:52:native
Jan 11 20:49:52{:query
Jan 11 20:49:52"SELECT (\"source\".\"device_meta\"#>> array[?]::text[])::text AS \"device_meta → connection\", (\"source\".\"device_meta\"#>> array[?, ?]::text[])::double precision AS \"device_meta → connection → downlink\", (\"source\".\"device_meta\"#>> array[?, ?]::text[])::bigint AS \"device_meta → connection → downlinkMax\", (\"source\".\"device_meta\"#>> array[?, ?]::text[])::text AS \"device_meta → connection → effectiveType\", (\"source\".\"device_meta\"#>> array[?, ?]::text[])::bigint AS \"device_meta → connection → rtt\", (\"source\".\"device_meta\"#>> array[?, ?]::text[])::text AS \"device_meta → connection → type\", (\"source\".\"device_meta\"#>> array[?]::text[])::text AS \"device_meta → displayMode\", (\"source\".\"device_meta\"#>> array[?]::text[])::text AS \"device_meta → getInstalledRelatedApps\", (\"source\".\"device_meta\"#>> array[?]::text[])::text AS \"device_meta → languages\", (\"source\".\"device_meta\"#>> array[?]::text[])::boolean AS \"device_meta → onLine\", (\"source\".\"device_meta\"#>> array[?, ?, ?]::text[])::bigint AS \"device_meta → reverseGeo → city → geoname_id\", (\"source\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → city → names → de\", (\"source\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → city → names → en\", (\"source\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → city → names → es\", (\"source\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → city → names → fr\", (\"source\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → city → names → ja\", (\"source\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → city → names → pt-BR\", (\"source\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → city → names → ru\", (\"source\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → city → names → zh-CN\", (\"source\".\"device_meta\"#>> array[?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → continent → code\", (\"source\".\"device_meta\"#>> array[?, ?, ?]::text[])::bigint AS \"device_meta → reverseGeo → continent → geoname_id\", (\"source\".\"device_meta\"#>> array[?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → continent → names\", (\"source\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → continent → names → de\", (\"source\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → continent → names → en\", (\"source\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → continent → names → es\", (\"source\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → continent → names → fr\", (\"source\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → continent → names → ja\", (\"source\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → continent → names → pt-BR\", (\"source\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → continent → names → ru\", (\"source\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → continent → names → zh-CN\", (\"source\".\"device_meta\"#>> array[?, ?, ?]::text[])::bigint AS \"device_meta → reverseGeo → country → geoname_id\", (\"source\".\"device_meta\"#>> array[?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → country → iso_code\", (\"source\".\"device_meta\"#>> array[?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → country → names\", (\"source\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → country → names → de\", (\"source\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → country → names → en\", (\"source\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → country → names → es\", (\"source\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → country → names → fr\", (\"source\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → country → names → ja\", (\"source\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → country → names → pt-BR\", (\"source\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → country → names → ru\", (\"source\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → country → names → zh-CN\", (\"source\".\"device_meta\"#>> array[?, ?, ?]::text[])::bigint AS \"device_meta → reverseGeo → location → accuracy_radius\", (\"source\".\"device_meta\"#>> array[?, ?, ?]::text[])::double precision AS \"device_meta → reverseGeo → location → latitude\", (\"source\".\"device_meta\"#>> array[?, ?, ?]::text[])::double precision AS \"device_meta → reverseGeo → location → longitude\", (\"source\".\"device_meta\"#>> array[?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → location → time_zone\", (\"source\".\"device_meta\"#>> array[?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → postal → code\", (\"source\".\"device_meta\"#>> array[?, ?, ?]::text[])::bigint AS \"device_meta → reverseGeo → registered_country _4b835e0b\", (\"source\".\"device_meta\"#>> array[?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → registered_country _1c532f71\", (\"source\".\"device_meta\"#>> array[?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → registered_country → names\", (\"source\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → registered_country _03816fde\", (\"source\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → registered_country _8d488717\", (\"source\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → registered_country _ee4eebce\", (\"source\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → registered_country _b264889b\", (\"source\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → registered_country _9a6f8649\", (\"source\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → registered_country _0af6cca1\", (\"source\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → registered_country _02aeca6d\", (\"source\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → registered_country _57935129\", (\"source\".\"device_meta\"#>> array[?, ?]::text[])::text AS \"device_meta → reverseGeo → subdivisions\", (\"source\".\"device_meta\"#>> array[?]::text[])::text AS \"device_meta → software_version\", (\"source\".\"device_meta\"#>> array[?]::text[])::text AS \"device_meta → userAgent\", (\"source\".\"device_meta\"#>> array[?, ?]::text[])::text AS \"device_meta → userAgentData → brands\", (\"source\".\"device_meta\"#>> array[?, ?]::text[])::boolean AS \"device_meta → userAgentData → mobile\", (\"source\".\"device_meta\"#>> array[?, ?]::text[])::text AS \"device_meta → userAgentData → platform\", (\"source\".\"device_meta\"#>> array[?]::text[])::text AS \"device_meta → uuid\", (\"source\".\"headers\"#>> array[?]::text[])::text AS \"headers → accept\", (\"source\".\"headers\"#>> array[?]::text[])::text AS \"headers → accept-encoding\", (\"source\".\"headers\"#>> array[?]::text[])::text AS \"headers → accept-language\", (\"source\".\"headers\"#>> array[?]::text[])::text AS \"headers → connection\", (\"source\".\"headers\"#>> array[?]::text[])::text AS \"headers → dnt\", (\"source\".\"headers\"#>> array[?]::text[])::text AS \"headers → host\", (\"source\".\"headers\"#>> array[?]::text[])::text AS \"headers → if-none-match\", (\"source\".\"headers\"#>> array[?]::text[])::text AS \"headers → origin\", (\"source\".\"headers\"#>> array[?]::text[])::text AS \"headers → referer\", (\"source\".\"headers\"#>> array[?]::text[])::text AS \"headers → save-data\", (\"source\".\"headers\"#>> array[?]::text[])::text AS \"headers → sec-ch-ua\", (\"source\".\"headers\"#>> array[?]::text[])::text AS \"headers → sec-ch-ua-mobile\", (\"source\".\"headers\"#>> array[?]::text[])::text AS \"headers → sec-ch-ua-platform\", (\"source\".\"headers\"#>> array[?]::text[])::text AS \"headers → sec-fetch-dest\", (\"source\".\"headers\"#>> array[?]::text[])::text AS \"headers → sec-fetch-mode\", (\"source\".\"headers\"#>> array[?]::text[])::text AS \"headers → sec-fetch-site\", (\"source\".\"headers\"#>> array[?]::text[])::text AS \"headers → sec-gpc\", (\"source\".\"headers\"#>> array[?]::text[])::text AS \"headers → te\", (\"source\".\"headers\"#>> array[?]::text[])::text AS \"headers → user-agent\", (\"source\".\"headers\"#>> array[?]::text[])::text AS \"headers → x-forwarded-for\", (\"source\".\"headers\"#>> array[?]::text[])::text AS \"headers → x-forwarded-host\", (\"source\".\"headers\"#>> array[?]::text[])::text AS \"headers → x-forwarded-port\", (\"source\".\"headers\"#>> array[?]::text[])::text AS \"headers → x-forwarded-proto\", (\"source\".\"headers\"#>> array[?]::text[])::text AS \"headers → x-forwarded-server\", (\"source\".\"headers\"#>> array[?]::text[])::text AS \"headers → x-real-ip\", \"source\".\"id\" AS \"id\", \"source\".\"createdAt\" AS \"createdAt\", \"source\".\"headers\" AS \"headers\", \"source\".\"query\" AS \"query\", \"source\".\"network_type\" AS \"network_type\", \"source\".\"software_version\" AS \"software_version\", \"source\".\"device_meta\" AS \"device_meta\", \"source\".\"source\" AS \"source\", \"source\".\"CreatedAt (IST)\" AS \"CreatedAt (IST)\" FROM (SELECT (\"public\".\"logs\".\"device_meta\"#>> array[?]::text[])::text AS \"device_meta → connection\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?]::text[])::double precision AS \"device_meta → connection → downlink\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?]::text[])::bigint AS \"device_meta → connection → downlinkMax\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?]::text[])::text AS \"device_meta → connection → effectiveType\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?]::text[])::bigint AS \"device_meta → connection → rtt\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?]::text[])::text AS \"device_meta → connection → type\", (\"public\".\"logs\".\"device_meta\"#>> array[?]::text[])::text AS \"device_meta → displayMode\", (\"public\".\"logs\".\"device_meta\"#>> array[?]::text[])::text AS \"device_meta → getInstalledRelatedApps\", (\"public\".\"logs\".\"device_meta\"#>> array[?]::text[])::text AS \"device_meta → languages\", (\"public\".\"logs\".\"device_meta\"#>> array[?]::text[])::boolean AS \"device_meta → onLine\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?, ?]::text[])::bigint AS \"device_meta → reverseGeo → city → geoname_id\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → city → names → de\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → city → names → en\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → city → names → es\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → city → names → fr\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → city → names → ja\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → city → names → pt-BR\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → city → names → ru\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → city → names → zh-CN\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → continent → code\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?, ?]::text[])::bigint AS \"device_meta → reverseGeo → continent → geoname_id\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → continent → names\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → continent → names → de\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → continent → names → en\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → continent → names → es\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → continent → names → fr\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → continent → names → ja\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → continent → names → pt-BR\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → continent → names → ru\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → continent → names → zh-CN\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?, ?]::text[])::bigint AS \"device_meta → reverseGeo → country → geoname_id\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → country → iso_code\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → country → names\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → country → names → de\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → country → names → en\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → country → names → es\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → country → names → fr\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → country → names → ja\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → country → names → pt-BR\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → country → names → ru\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → country → names → zh-CN\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?, ?]::text[])::bigint AS \"device_meta → reverseGeo → location → accuracy_radius\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?, ?]::text[])::double precision AS \"device_meta → reverseGeo → location → latitude\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?, ?]::text[])::double precision AS \"device_meta → reverseGeo → location → longitude\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → location → time_zone\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → postal → code\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?, ?]::text[])::bigint AS \"device_meta → reverseGeo → registered_country _4b835e0b\", (\"public\".\"logs\".\"d
Jan 11 20:49:52evice_meta\"#>> array[?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → registered_country _1c532f71\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → registered_country → names\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → registered_country _03816fde\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → registered_country _8d488717\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → registered_country _ee4eebce\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → registered_country _b264889b\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → registered_country _9a6f8649\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → registered_country _0af6cca1\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → registered_country _02aeca6d\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?, ?, ?]::text[])::text AS \"device_meta → reverseGeo → registered_country _57935129\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?]::text[])::text AS \"device_meta → reverseGeo → subdivisions\", (\"public\".\"logs\".\"device_meta\"#>> array[?]::text[])::text AS \"device_meta → software_version\", (\"public\".\"logs\".\"device_meta\"#>> array[?]::text[])::text AS \"device_meta → userAgent\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?]::text[])::text AS \"device_meta → userAgentData → brands\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?]::text[])::boolean AS \"device_meta → userAgentData → mobile\", (\"public\".\"logs\".\"device_meta\"#>> array[?, ?]::text[])::text AS \"device_meta → userAgentData → platform\", (\"public\".\"logs\".\"device_meta\"#>> array[?]::text[])::text AS \"device_meta → uuid\", (\"public\".\"logs\".\"headers\"#>> array[?]::text[])::text AS \"headers → accept\", (\"public\".\"logs\".\"headers\"#>> array[?]::text[])::text AS \"headers → accept-encoding\", (\"public\".\"logs\".\"headers\"#>> array[?]::text[])::text AS \"headers → accept-language\", (\"public\".\"logs\".\"headers\"#>> array[?]::text[])::text AS \"headers → connection\", (\"public\".\"logs\".\"headers\"#>> array[?]::text[])::text AS \"headers → dnt\", (\"public\".\"logs\".\"headers\"#>> array[?]::text[])::text AS \"headers → host\", (\"public\".\"logs\".\"headers\"#>> array[?]::text[])::text AS \"headers → if-none-match\", (\"public\".\"logs\".\"headers\"#>> array[?]::text[])::text AS \"headers → origin\", (\"public\".\"logs\".\"headers\"#>> array[?]::text[])::text AS \"headers → referer\", (\"public\".\"logs\".\"headers\"#>> array[?]::text[])::text AS \"headers → save-data\", (\"public\".\"logs\".\"headers\"#>> array[?]::text[])::text AS \"headers → sec-ch-ua\", (\"public\".\"logs\".\"headers\"#>> array[?]::text[])::text AS \"headers → sec-ch-ua-mobile\", (\"public\".\"logs\".\"headers\"#>> array[?]::text[])::text AS \"headers → sec-ch-ua-platform\", (\"public\".\"logs\".\"headers\"#>> array[?]::text[])::text AS \"headers → sec-fetch-dest\", (\"public\".\"logs\".\"headers\"#>> array[?]::text[])::text AS \"headers → sec-fetch-mode\", (\"public\".\"logs\".\"headers\"#>> array[?]::text[])::text AS \"headers → sec-fetch-site\", (\"public\".\"logs\".\"headers\"#>> array[?]::text[])::text AS \"headers → sec-gpc\", (\"public\".\"logs\".\"headers\"#>> array[?]::text[])::text AS \"headers → te\", (\"public\".\"logs\".\"headers\"#>> array[?]::text[])::text AS \"headers → user-agent\", (\"public\".\"logs\".\"headers\"#>> array[?]::text[])::text AS \"headers → x-forwarded-for\", (\"public\".\"logs\".\"headers\"#>> array[?]::text[])::text AS \"headers → x-forwarded-host\", (\"public\".\"logs\".\"headers\"#>> array[?]::text[])::text AS \"headers → x-forwarded-port\", (\"public\".\"logs\".\"headers\"#>> array[?]::text[])::text AS \"headers → x-forwarded-proto\", (\"public\".\"logs\".\"headers\"#>> array[?]::text[])::text AS \"headers → x-forwarded-server\", (\"public\".\"logs\".\"headers\"#>> array[?]::text[])::text AS \"headers → x-real-ip\", \"public\".\"logs\".\"id\" AS \"id\", \"public\".\"logs\".\"createdAt\" AS \"createdAt\", \"public\".\"logs\".\"headers\" AS \"headers\", \"public\".\"logs\".\"query\" AS \"query\", \"public\".\"logs\".\"network_type\" AS \"network_type\", \"public\".\"logs\".\"software_version\" AS \"software_version\", \"public\".\"logs\".\"device_meta\" AS \"device_meta\", \"public\".\"logs\".\"source\" AS \"source\", (\"public\".\"logs\".\"createdAt\" + INTERVAL '330 minute') AS \"CreatedAt (IST)\" FROM \"public\".\"logs\" WHERE (((\"public\".\"logs\".\"headers\"#>> array[?]::text[])::text <> ?) OR ((\"public\".\"logs\".\"headers\"#>> array[?]::text[])::text IS NULL)) AND (((\"public\".\"logs\".\"headers\"#>> array[?]::text[])::text <> ?) OR ((\"public\".\"logs\".\"headers\"#>> array[?]::text[])::text IS NULL)) AND (((\"public\".\"logs\".\"headers\"#>> array[?]::text[])::text <> ?) OR ((\"public\".\"logs\".\"headers\"#>> array[?]::text[])::text IS NULL)) AND (((\"public\".\"logs\".\"headers\"#>> array[?]::text[])::text <> ?) OR ((\"public\".\"logs\".\"headers\"#>> array[?]::text[])::text IS NULL)) AND (\"public\".\"logs\".\"id\" > 1)) AS \"source\" ORDER BY \"source\".\"createdAt\" DESC LIMIT 2000",
Jan 11 20:49:52:params
Jan 11 20:49:52("connection"
Jan 11 20:49:52"connection"
Jan 11 20:49:52"downlink"
Jan 11 20:49:52"connection"
Jan 11 20:49:52"downlinkMax"
Jan 11 20:49:52"connection"
Jan 11 20:49:52"effectiveType"
Jan 11 20:49:52"connection"
Jan 11 20:49:52"rtt"
Jan 11 20:49:52"connection"
Jan 11 20:49:52"type"
Jan 11 20:49:52"displayMode"
Jan 11 20:49:52"getInstalledRelatedApps"
Jan 11 20:49:52"languages"
Jan 11 20:49:52"onLine"
Jan 11 20:49:52"reverseGeo"
Jan 11 20:49:52"city"
Jan 11 20:49:52"geoname_id"
Jan 11 20:49:52"reverseGeo"
Jan 11 20:49:52"city"
Jan 11 20:49:52"names"
Jan 11 20:49:52"de"
Jan 11 20:49:52"reverseGeo"
Jan 11 20:49:52"city"
Jan 11 20:49:52"names"
Jan 11 20:49:52"en"
Jan 11 20:49:52"reverseGeo"
Jan 11 20:49:52"city"
Jan 11 20:49:52"names"
Jan 11 20:49:52"es"
Jan 11 20:49:52"reverseGeo"
Jan 11 20:49:52"continent"
Jan 11 20:49:52"names"
Jan 11 20:49:52"en"
Jan 11 20:49:52"reverseGeo"
Jan 11 20:49:52"continent"
Jan 11 20:49:52"names"
Jan 11 20:49:52"es"
Jan 11 20:49:52"reverseGeo"
Jan 11 20:49:52"continent"
Jan 11 20:49:52"names"
Jan 11 20:49:52"fr"
Jan 11 20:49:52"reverseGeo"
Jan 11 20:49:52"continent"
Jan 11 20:49:52"names"
Jan 11 20:49:52"ja"
Jan 11 20:49:52"reverseGeo"
Jan 11 20:49:52"continent"
Jan 11 20:49:52"names"
Jan 11 20:49:52"pt-BR"
Jan 11 20:49:52"reverseGeo"
Jan 11 20:49:52"continent"
Jan 11 20:49:52"names"
Jan 11 20:49:52"ru"
Jan 11 20:49:52"reverseGeo"
Jan 11 20:49:52"continent"
Jan 11 20:49:52"names"
Jan 11 20:49:52"zh-CN"
Jan 11 20:49:52"reverseGeo"
Jan 11 20:49:52"country"
Jan 11 20:49:52"geoname_id"
Jan 11 20:49:52"reverseGeo"
Jan 11 20:49:52"country"
Jan 11 20:49:52"iso_code"
Jan 11 20:49:52"reverseGeo"
Jan 11 20:49:52"country"
Jan 11 20:49:52"names"
Jan 11 20:49:52"reverseGeo"
Jan 11 20:49:52"country"
Jan 11 20:49:52"names"
Jan 11 20:49:52"de"
Jan 11 20:49:52"reverseGeo"
Jan 11 20:49:52"country"
Jan 11 20:49:52"names"
Jan 11 20:49:52"en"
Jan 11 20:49:52"reverseGeo"
Jan 11 20:49:52"country"
Jan 11 20:49:52"names"
Jan 11 20:49:52"es"
Jan 11 20:49:52"reverseGeo"
Jan 11 20:49:52"country"
Jan 11 20:49:52"names"
Jan 11 20:49:52"fr"
Jan 11 20:49:52"reverseGeo"
Jan 11 20:49:52"country"
Jan 11 20:49:52"names"
Jan 11 20:49:52"ja"
Jan 11 20:49:52"reverseGeo"
Jan 11 20:49:52"country"
Jan 11 20:49:52"names"
Jan 11 20:49:52"pt-BR"
Jan 11 20:49:52"reverseGeo"
Jan 11 20:49:52"country"
Jan 11 20:49:52"names"
Jan 11 20:49:52"ru"
Jan 11 20:49:52"reverseGeo"
Jan 11 20:49:52"country"
Jan 11 20:49:52"names"
Jan 11 20:49:52"zh-CN"
Jan 11 20:49:52"reverseGeo"
Jan 11 20:49:52:card-name "Logs (Live)",
Jan 11 20:49:52:visualization-settings
Jan 11 20:49:52{:table.pivot-column "device_meta → getInstalledRelatedApps",
Jan 11 20:49:52:table.cell-column "device_meta → connection → downlink"}},
Jan 11 20:49:52:database 2,
Jan 11 20:49:52:query
Jan 11 20:49:52{:source-table 5,
Jan 11 20:49:52:expressions
Jan 11 20:49:52{"CreatedAt (IST)" [:datetime-add [:field 66 {:base-type :type/DateTime, :temporal-unit :default}] 330 :minute]},
Jan 11 20:49:52:order-by [[:desc [:field 66 {:base-type :type/DateTime, :temporal-unit :default}]]],
Jan 11 20:49:52:fields
Jan 11 20:49:52[[:field 2425 {:base-type :type/Structured}]
Jan 11 20:49:52[:field 2711 {:base-type :type/Float}]
Jan 11 20:49:52[:field 2745 {:base-type :type/Integer}]
Jan 11 20:49:52[:field 2738 {:base-type :type/Text}]
Jan 11 20:49:52[:field 2742 {:base-type :type/Integer}]
Jan 11 20:49:52[:field 2718 {:base-type :type/Text}]
Jan 11 20:49:52[:field 2418 {:base-type :type/Text}]
Jan 11 20:49:52[:field 2424 {:base-type :type/Array}]
Jan 11 20:49:52[:field 2417 {:base-type :type/Array}]
Jan 11 20:49:52[:field 2421 {:base-type :type/Boolean}]
Jan 11 20:49:52[:field 2734 {:base-type :type/Integer}]
Jan 11 20:49:52[:field 2714 {:base-type :type/Text}]
Jan 11 20:49:52[:field 2774 {:base-type :type/Text}]
Jan 11 20:49:52[:field 2726 {:base-type :type/Text}]
Jan 11 20:49:52[:field 2752 {:base-type :type/Text}]
Jan 11 20:49:52[:field 2741 {:base-type :type/Text}]
Jan 11 20:49:52[:field 2736 {:base-type :type/Text}]
Jan 11 20:49:52[:field 2772 {:base-type :type/Text}]
Jan 11 20:49:52[:field 2735 {:base-type :type/Text}]
Jan 11 20:49:52[:field 2761 {:base-type :type/Text}]
Jan 11 20:49:52[:field 2746 {:base-type :type/Integer}]
Jan 11 20:49:52[:field 2724 {:base-type :type/Structured}]
Jan 11 20:49:52[:field 2743 {:base-type :type/Text}]
Jan 11 20:49:52[:field 2765 {:base-type :type/Text}]
Jan 11 20:49:52[:field 2719 {:base-type :type/Text}]
Jan 11 20:49:52[:field 2751 {:base-type :type/Text}]
Jan 11 20:49:52[:field 2770 {:base-type :type/Text}]
Jan 11 20:49:52[:field 2748 {:base-type :type/Text}]
Jan 11 20:49:52[:field 2747 {:base-type :type/Text}]
Jan 11 20:49:52[:field 2716 {:base-type :type/Text}]
Jan 11 20:49:52[:field 2728 {:base-type :type/Integer}]
Jan 11 20:49:52[:field 2733 {:base-type :type/Text}]
Jan 11 20:49:52:effective_type :type/BigInteger,
Jan 11 20:49:52:coercion_strategy nil,
Jan 11 20:49:52:semantic_type :type/PK,
Jan 11 20:49:52:database_type "bigserial",
Jan 11 20:49:52:name "id"}]]],
Jan 11 20:49:52:limit 2000,
Jan 11 20:49:52:metabase.query-processor.middleware.limit/original-limit nil},
Jan 11 20:49:52:async? true},
Jan 11 20:49:52:data {:rows [], :cols []}}
Jan 11 20:49:52

Luiggi · January 11, 2024, 9:37pm

Lots of json on that query and probably there’s a field that Metabase is thinking that is a bigint. Can you check running that query in a sql client to identify what line the query is failing in?

shrey · January 12, 2024, 4:36am

@Luiggi

When i run the SQL query directly, the execution fails in the very beginning itself, at the ? (placeholders ?) .

SQL Query:

SELECT source.substring55643 AS substring55643, ("source"."device_meta" #>> array [ ?, ? ] :: text []) :: bigint AS "device_meta → connection → rtt", "source"."substring55644" AS "substring55644", "source"."substring55645" AS "substring55645", "source"."substring55646" AS "substring55646", "source"."substring55647" AS "substring55647", "source"."substring55648" AS "substring55648", "source"."substring55649" AS "substring55649", "source"."substring55650" AS "substring55650", ("source"."device_meta" #>> array [ ? ] :: text []) :: boolean AS "device_meta → onLine", "source"."substring55651" AS "substring55651", "source"."substring55652" AS "substring55652", "source"."substring55653" AS "substring55653", "source"."substring55654" AS "substring55654", ("source"."device_meta" #>> array [ ?, ? ] :: text []) :: text AS "device_meta → userAgentData → brands", "source"."substring55655" AS "substring55655", "source"."substring55656" AS "substring55656", ("source"."device_meta" #>> array [ ?, ? ] :: text []) :: text AS "device_meta → reverseGeo → subdivisions", "source"."substring55657" AS "substring55657", ("source"."device_meta" #>> array [ ?, ? ] :: text []) :: boolean AS "device_meta → userAgentData → mobile", "source"."substring55658" AS "substring55658", ("source"."device_meta" #>> array [ ? ] :: text []) :: text AS "device_meta → languages", "source"."substring55659" AS "substring55659", ("source"."device_meta" #>> array [ ?, ?, ? ] :: text []) :: double precision AS "device_meta → reverseGeo → location → latitude", "source"."substring55660" AS "substring55660", "source"."substring55661" AS "substring55661", ("source"."device_meta" #>> array [ ?, ?, ? ] :: text []) :: bigint AS "device_meta → reverseGeo → registered_country _4b835e0b", "source"."substring55662" AS "substring55662", "source"."substring55663" AS "substring55663", "source"."substring55664" AS "substring55664", "source"."substring55665" AS "substring55665", "source"."substring55666" AS "substring55666", "source"."substring55667" AS "substring55667", "source"."substring55668" AS "substring55668", "source"."substring55669" AS "substring55669", ("source"."device_meta" #>> array [ ? ] :: text []) :: text AS "device_meta → getInstalledRelatedApps", "source"."substring55670" AS "substring55670", "source"."substring55671" AS "substring55671", "source"."substring55672" AS "substring55672", ("source"."device_meta" #>> array [ ?, ? ] :: text []) :: bigint AS "device_meta → connection → downlinkMax", "source"."substring55673" AS "substring55673", "source"."createdAt" AS "createdAt", ("source"."device_meta" #>> array [ ?, ?, ? ] :: text []) :: double precision AS "device_meta → reverseGeo → location → longitude", "source"."substring55674" AS "substring55674", "source"."substring55675" AS "substring55675", "source"."substring55676" AS "substring55676", "source"."substring55677" AS "substring55677", "source"."substring55678" AS "substring55678", ("source"."device_meta" #>> array [ ?, ?, ? ] :: text []) :: bigint AS "device_meta → reverseGeo → location → accuracy_radius", "source"."substring55679" AS "substring55679", "source"."substring55680" AS "substring55680", "source"."substring55681" AS "substring55681", "source"."substring55682" AS "substring55682", "source"."substring55683" AS "substring55683", "source"."substring55684" AS "substring55684", "source"."substring55685" AS "substring55685", ("source"."device_meta" #>> array [ ?, ?, ? ] :: text []) :: bigint AS "device_meta → reverseGeo → city → geoname_id", "source"."substring55686" AS "substring55686", "source"."substring55687" AS "substring55687", "source"."substring55688" AS "substring55688", "source"."substring55689" AS "substring55689", "source"."substring55690" AS "substring55690", "source"."substring55691" AS "substring55691", "source"."substring55692" AS "substring55692", "source"."substring55693" AS "substring55693", "source"."substring55694" AS "substring55694", "source"."substring55695" AS "substring55695", ("source"."device_meta" #>> array [ ?, ? ] :: text []) :: double precision AS "device_meta → connection → downlink", "source"."substring55696" AS "substring55696", "source"."substring55697" AS "substring55697", "source"."substring55698" AS "substring55698", "source"."substring55699" AS "substring55699", "source"."substring55700" AS "substring55700", "source"."substring55701" AS "substring55701", "source"."substring55702" AS "substring55702", "source"."substring55703" AS "substring55703", "source"."substring55704" AS "substring55704", "source"."substring55705" AS "substring55705", "source"."substring55706" AS "substring55706", ("source"."device_meta" #>> array [ ?, ?, ? ] :: text []) :: bigint AS "device_meta → reverseGeo → country → geoname_id", "source"."substring55707" AS "substring55707", "source"."substring55708" AS "substring55708", "source"."substring55709" AS "substring55709", ("source"."device_meta" #>> array [ ?, ?, ? ] :: text []) :: bigint AS "device_meta → reverseGeo → continent → geoname_id", "source"."substring55710" AS "substring55710", "source"."substring55711" AS "substring55711", "source"."substring55712" AS "substring55712", "source"."substring55713" AS "substring55713", "source"."substring55714" AS "substring55714", "source"."substring55715" AS "substring55715"FROM  (    SELECT      ("public"."logs"."device_meta" #>> array [ ?, ? ] :: text []      ) :: double precision AS "device_meta → connection → downlink", ("public"."logs"."device_meta" #>> array [ ?, ? ] :: text []      ) :: bigint AS "device_meta → connection → downlinkMax", ("public"."logs"."device_meta" #>> array [ ?, ? ] :: text []      ) :: text AS "device_meta → connection → effectiveType", ("public"."logs"."device_meta" #>> array [ ?, ? ] :: text []      ) :: bigint AS "device_meta → connection → rtt", ("public"."logs"."device_meta" #>> array [ ?, ? ] :: text []      ) :: text AS "device_meta → connection → type", ("public"."logs"."device_meta" #>> array [ ? ] :: text []) :: text AS "device_meta → displayMode", ("public"."logs"."device_meta" #>> array [ ? ] :: text []) :: text AS "device_meta → getInstalledRelatedApps", ("public"."logs"."device_meta" #>> array [ ? ] :: text []) :: text AS "device_meta → languages", ("public"."logs"."device_meta" #>> array [ ? ] :: text []) :: boolean AS "device_meta → onLine", ("public"."logs"."device_meta" #>> array [ ?, ?,? ] :: text []      ) :: bigint AS "device_meta → reverseGeo → city → geoname_id", ("public"."logs"."device_meta" #>> array [ ?, ?,?,? ] :: text []      ) :: text AS "device_meta → reverseGeo → city → names → de", ("public"."logs"."device_meta" #>> array [ ?, ?,?,? ] :: text []      ) :: text AS "device_meta → reverseGeo → city → names → en", ("public"."logs"."device_meta" #>> array [ ?, ?,?,? ] :: text []      ) :: text AS "device_meta → reverseGeo → city → names → es", ("public"."logs"."device_meta" #>> array [ ?, ?,?,? ] :: text []      ) :: text AS "device_meta → reverseGeo → city → names → fr", ("public"."logs"."device_meta" #>> array [ ?, ?,?,? ] :: text []      ) :: text AS "device_meta → reverseGeo → city → names → ja", ("public"."logs"."device_meta" #>> array [ ?, ?,?,? ] :: text []      ) :: text AS "device_meta → reverseGeo → city → names → pt-BR", ("public"."logs"."device_meta" #>> array [ ?, ?,?,? ] :: text []      ) :: text AS "device_meta → reverseGeo → city → names → ru", ("public"."logs"."device_meta" #>> array [ ?, ?,?,? ] :: text []      ) :: text AS "device_meta → reverseGeo → city → names → zh-CN", ("public"."logs"."device_meta" #>> array [ ?, ?,? ] :: text []      ) :: text AS "device_meta → reverseGeo → continent → code", ("public"."logs"."device_meta" #>> array [ ?, ?,? ] :: text []      ) :: bigint AS "device_meta → reverseGeo → continent → geoname_id", ("public"."logs"."device_meta" #>> array [ ?, ?,?,? ] :: text []      ) :: text AS "device_meta → reverseGeo → continent → names → de", ("public"."logs"."device_meta" #>> array [ ?, ?,?,? ] :: text []      ) :: text AS "device_meta → reverseGeo → continent → names → en", ("public"."logs"."device_meta" #>> array [ ?, ?,?,? ] :: text []      ) :: text AS "device_meta → reverseGeo → continent → names → es", ("public"."logs"."device_meta" #>> array [ ?, ?,?,? ] :: text []      ) :: text AS "device_meta → reverseGeo → continent → names → fr", ("public"."logs"."device_meta" #>> array [ ?, ?,?,? ] :: text []      ) :: text AS "device_meta → reverseGeo → continent → names → ja", ("public"."logs"."device_meta" #>> array [ ?, ?,?,? ] :: text []      ) :: text AS "device_meta → reverseGeo → continent → names → pt-BR", ("public"."logs"."device_meta" #>> array [ ?, ?,?,? ] :: text []      ) :: text AS "device_meta → reverseGeo → continent → names → ru", ("public"."logs"."device_meta" #>> array [ ?, ?,?,? ] :: text []      ) :: text AS "device_meta → reverseGeo → continent → names → zh-CN", ("public"."logs"."device_meta" #>> array [ ?, ?,? ] :: text []      ) :: bigint AS "device_meta → reverseGeo → country → geoname_id", ("public"."logs"."device_meta" #>> array [ ?, ?,? ] :: text []      ) :: text AS "device_meta → reverseGeo → country → iso_code", ("public"."logs"."device_meta" #>> array [ ?, ?,?,? ] :: text []      ) :: text AS "device_meta → reverseGeo → country → names → de", ("public"."logs"."device_meta" #>> array [ ?, ?,?,? ] :: text []      ) :: text AS "device_meta → reverseGeo → country → names → en", ("public"."logs"."device_meta" #>> array [ ?, ?,?,? ] :: text []      ) :: text AS "device_meta → reverseGeo → country → names → es", ("public"."logs"."device_meta" #>> array [ ?, ?,?,? ] :: text []      ) :: text AS "device_meta → reverseGeo → country → names → fr", ("public"."logs"."device_meta" #>> array [ ?, ?,?,? ] :: text []      ) :: text AS "device_meta → reverseGeo → country → names → ja", ("public"."logs"."device_meta" #>> array [ ?, ?,?,? ] :: text []      ) :: text AS "device_meta → reverseGeo → country → names → pt-BR", ("public"."logs"."device_meta" #>> array [ ?, ?,?,? ] :: text []      ) :: text AS "device_meta → reverseGeo → country → names → ru", ("public"."logs"."device_meta" #>> array [ ?, ?,?,? ] :: text []      ) :: text AS "device_meta → reverseGeo → country → names → zh-CN", ("public"."logs"."device_meta" #>> array [ ?, ?,? ] :: text []      ) :: bigint AS "device_meta → reverseGeo → location → accuracy_radius", ("public"."logs"."device_meta" #>> array [ ?, ?,? ] :: text []      ) :: double precision AS "device_meta → reverseGeo → location → latitude", ("public"."logs"."device_meta" #>> array [ ?, ?,? ] :: text []      ) :: double precision AS "device_meta → reverseGeo → location → longitude", ("public"."logs"."device_meta" #>> array [ ?, ?,? ] :: text []      ) :: text AS "device_meta → reverseGeo → location → time_zone", ("public"."logs"."device_meta" #>> array [ ?, ?,? ] :: text []      ) :: text AS "device_meta → reverseGeo → postal → code", ("public"."logs"."device_meta" #>> array [ ?, ?,? ] :: text []      ) :: bigint AS "device_meta → reverseGeo → registered_country _4b835e0b", ("public"."logs"."device_meta" #>> array [ ?, ?,? ] :: text []      ) :: text AS "device_meta → reverseGeo → registered_country _1c532f71", ("public"."logs"."device_meta" #>> array [ ?, ?,?,? ] :: text []      ) :: text AS "device_meta → reverseGeo → registered_country _03816fde", ("public"."logs"."device_meta" #>> array [ ?, ?,?,? ] :: text []      ) :: text AS "device_meta → reverseGeo → registered_country _8d488717", ("public"."logs"."device_meta" #>> array [ ?, ?,?,? ] :: text []      ) :: text AS "device_meta → reverseGeo → registered_country _ee4eebce", ("public"."logs"."device_meta" #>> array [ ?, ?,?,? ] :: text []      ) :: text AS "device_meta → reverseGeo → registered_country _b264889b", ("public"."logs"."device_meta" #>> array [ ?, ?,?,? ] :: text []      ) :: text AS "device_meta → reverseGeo → registered_country _9a6f8649", ("public"."logs"."device_meta" #>> array [ ?, ?,?,? ] :: text []      ) :: text AS "device_meta → reverseGeo → registered_country _0af6cca1", ("public"."logs"."device_meta" #>> array [ ?, ?,?,? ] :: text []      ) :: text AS "device_meta → reverseGeo → registered_country _02aeca6d", ("public"."logs"."device_meta" #>> array [ ?, ?,?,? ] :: text []      ) :: text AS "device_meta → reverseGeo → registered_country _57935129", ("public"."logs"."device_meta" #>> array [ ?, ? ] :: text []      ) :: text AS "device_meta → reverseGeo → subdivisions", ("public"."logs"."device_meta" #>> array [ ? ] :: text []) :: text AS "device_meta → software_version", ("public"."logs"."device_meta" #>> array [ ? ] :: text []) :: text AS "device_meta → userAgent", ("public"."logs"."device_meta" #>> array [ ?, ? ] :: text []      ) :: text AS "device_meta → userAgentData → brands", ("public"."logs"."device_meta" #>> array [ ?, ? ] :: text []      ) :: boolean AS "device_meta → userAgentData → mobile", ("public"."logs"."device_meta" #>> array [ ?, ? ] :: text []      ) :: text AS "device_meta → userAgentData → platform", ("public"."logs"."device_meta" #>> array [ ? ] :: text []) :: text AS "device_meta → uuid", ("public"."logs"."headers" #>> array [ ? ] :: text []) :: text AS "headers → accept", ("public"."logs"."headers" #>> array [ ? ] :: text []) :: text AS "headers → accept-encoding", ("public"."logs"."headers" #>> array [ ? ] :: text []) :: text AS "headers → accept-language", ("public"."logs"."headers" #>> array [ ? ] :: text []) :: text AS "headers → connection", ("public"."logs"."headers" #>> array [ ? ] :: text []) :: text AS "headers → dnt", ("public"."logs"."headers" #>> array [ ? ] :: text []) :: text AS "headers → host", ("public"."logs"."headers" #>> array [ ? ] :: text []) :: text AS "headers → if-none-match", ("public"."logs"."headers" #>> array [ ? ] :: text []) :: text AS "headers → origin", ("public"."logs"."headers" #>> array [ ? ] :: text []) :: text AS "headers → referer", ("public"."logs"."headers" #>> array [ ? ] :: text []) :: text AS "headers → save-data", ("public"."logs"."headers" #>> array [ ? ] :: text []) :: text AS "headers → sec-ch-ua", ("public"."logs"."headers" #>> array [ ? ] :: text []) :: text AS "headers → sec-ch-ua-mobile", ("public"."logs"."headers" #>> array [ ? ] :: text []) :: text AS "headers → sec-ch-ua-platform", ("public"."logs"."headers" #>> array [ ? ] :: text []) :: text AS "headers → sec-fetch-dest", ("public"."logs"."headers" #>> array [ ? ] :: text []) :: text AS "headers → sec-fetch-mode", ("public"."logs"."headers" #>> array [ ? ] :: text []) :: text AS "headers → sec-fetch-site", ("public"."logs"."headers" #>> array [ ? ] :: text []) :: text AS "headers → sec-gpc", ("public"."logs"."headers" #>> array [ ? ] :: text []) :: text AS "headers → te", ("public"."logs"."headers" #>> array [ ? ] :: text []) :: text AS "headers → user-agent", ("public"."logs"."headers" #>> array [ ? ] :: text []) :: text AS "headers → x-forwarded-for", ("public"."logs"."headers" #>> array [ ? ] :: text []) :: text AS "headers → x-forwarded-host", ("public"."logs"."headers" #>> array [ ? ] :: text []) :: text AS "headers → x-forwarded-port", ("public"."logs"."headers" #>> array [ ? ] :: text []) :: text AS "headers → x-forwarded-proto", ("public"."logs"."headers" #>> array [ ? ] :: text []) :: text AS "headers → x-forwarded-server", ("public"."logs"."headers" #>> array [ ? ] :: text []) :: text AS "headers → x-real-ip", "public"."logs"."createdAt" AS "createdAt", "public"."logs"."headers" AS "headers", "public"."logs"."query" AS "query", "public"."logs"."network_type" AS "network_type", "public"."logs"."software_version" AS "software_version", "public"."logs"."device_meta" AS "device_meta", "public"."logs"."source" AS "source", SUBSTRING( ("public"."logs"."device_meta" #>> array [ ?,   ?,  ?,  ? ] :: text [] ) :: text, 1, 1234 ) AS "substring55710", SUBSTRING( ("public"."logs"."device_meta" #>> array [ ?,   ?,?,? ] :: text [] ) :: text, 1, 1234 ) AS "substring55705", SUBSTRING( ("public"."logs"."device_meta" #>> array [ ?,   ? ] :: text [] ) :: text, 1, 1234 ) AS "substring55692", SUBSTRING( ("public"."logs"."headers" #>> array [ ? ] :: text []) :: text, 1, 1234 ) AS "substring55667", SUBSTRING( ("public"."logs"."headers" #>> array [ ? ] :: text []) :: text, 1, 1234 ) AS "substring55647", SUBSTRING( ("public"."logs"."device_meta" #>> array [ ?,   ?,? ] :: text [] ) :: text, 1, 1234 ) AS "substring55680", SUBSTRING( ("public"."logs"."device_meta" #>> array [ ?,   ?,?,? ] :: text [] ) :: text, 1, 1234 ) AS "substring55707", SUBSTRING( ("public"."logs"."headers" #>> array [ ? ] :: text []) :: text, 1, 1234 ) AS "substring55682", SUBSTRING( ("public"."logs"."headers" #>> array [ ? ] :: text []) :: text, 1, 1234 ) AS "substring55665", SUBSTRING( ("public"."logs"."device_meta" #>> array [ ?,   ?,?,? ] :: text [] ) :: text, 1, 1234 ) AS "substring55645", SUBSTRING( ("public"."logs"."headers" #>> array [ ? ] :: text []) :: text, 1, 1234 ) AS "substring55648", SUBSTRING( ("public"."logs"."device_meta" #>> array [ ?,   ?,? ] :: text [] ) :: text, 1, 1234 ) AS "substring55651", SUBSTRING( ("public"."logs"."device_meta" #>> array [ ?,   ?,?,? ] :: text [] ) :: text, 1, 1234 ) AS "substring55709", SUBSTRING("public"."logs"."software_version", 1, 1234 ) AS "substring55656", SUBSTRING( ("public"."logs"."device_meta" #>> array [ ?,   ?,?,? ] :: text [] ) :: text, 1, 1234 ) AS "substring55654", SUBSTRING( ("public"."logs"."device_meta" #>> array [ ? ] :: text []) :: text, 1, 1234 ) AS "substring55661", SUBSTRING( ("public"."logs"."device_meta" #>> array [ ?,   ?,? ] :: text [] ) :: text, 1, 1234 ) AS "substring55664", SUBSTRING( ("public"."logs"."headers" #>> array [ ? ] :: text []) :: text, 1, 1234 ) AS "substring55691", SUBSTRING( ("public"."logs"."headers" #>> array [ ? ] :: text []) :: text, 1, 1234 ) AS "substring55646", SUBSTRING( ("public"."logs"."device_meta" #>> array [ ? ] :: text []) :: text, 1, 1234 ) AS "substring55658", SUBSTRING( ("public"."logs"."device_meta" #>> array [ ?,   ?,?,? ] :: text [] ) :: text, 1, 1234 ) AS "substring55712", SUBSTRING( ("public"."logs"."headers" #>> array [ ? ] :: text []) :: text, 1, 1234 ) AS "substring55708", SUBSTRING( ("public"."logs"."device_meta" #>> array [ ?,   ?,?,? ] :: text [] ) :: text, 1, 1234 ) AS "substring55700", SUBSTRING( ("public"."logs"."headers" #>> array [ ? ] :: text []) :: text, 1, 1234 ) AS "substring55676", SUBSTRING( ("public"."logs"."device_meta" #>> array [ ?,   ?,?,? ] :: text [] ) :: text, 1, 1234 ) AS "substring55649", SUBSTRING("public"."logs"."source", 1, 1234 ) AS "substring55714", SUBSTRING("public"."logs"."query", 1, 1234 ) AS "substring55685", SUBSTRING( ("public"."logs"."headers" #>> array [ ? ] :: text []) :: text, 1, 1234 ) AS "substring55660", SUBSTRING( ("public"."logs"."device_meta" #>> array [ ?,   ?,?,? ] :: text [] ) :: text, 1, 1234 ) AS "substring55686", SUBSTRING( ("public"."logs"."device_meta" #>> array [ ?,   ?,?,? ] :: text [] ) :: text, 1, 1234 ) AS "substring55673", SUBSTRING( ("public"."logs"."device_meta" #>> array [ ?,   ?,?,? ] :: text [] ) :: text, 1, 1234 ) AS "substring55671", SUBSTRING( ("public"."logs"."device_meta" #>> array [ ?,   ?,?,? ] :: text [] ) :: text, 1, 1234 ) AS "substring55701", SUBSTRING( ("public"."logs"."device_meta" #>> array [ ?,   ?,?,? ] :: text [] ) :: text, 1, 1234 ) AS "substring55706", SUBSTRING( ("public"."logs"."device_meta" #>> array [ ?,   ?,?,? ] :: text [] ) :: text, 1, 1234 ) AS "substring55694", SUBSTRING( ("public"."logs"."headers" #>> array [ ? ] :: text []) :: text, 1, 1234 ) AS "substring55703", SUBSTRING("public"."logs"."network_type", 1, 1234 ) AS "substring55677", SUBSTRING( ("public"."logs"."headers" #>> array [ ? ] :: text []) :: text, 1, 1234 ) AS "substring55688", SUBSTRING( ("public"."logs"."device_meta" #>> array [ ?,   ?,?,? ] :: text [] ) :: text, 1, 1234 ) AS "substring55670", SUBSTRING( ("public"."logs"."device_meta" #>> array [ ?,   ?,?,? ] :: text [] ) :: text, 1, 1234 ) AS "substring55678", SUBSTRING( ("public"."logs"."device_meta" #>> array [ ?,   ?,?,? ] :: text [] ) :: text, 1, 1234 ) AS "substring55693", SUBSTRING( ("public"."logs"."device_meta" #>> array [ ?,   ?,?,? ] :: text [] ) :: text, 1, 1234 ) AS "substring55653", SUBSTRING( ("public"."logs"."headers" #>> array [ ? ] :: text []) :: text, 1, 1234 ) AS "substring55683", SUBSTRING( ("public"."logs"."device_meta" #>> array [ ? ] :: text []) :: text, 1, 1234 ) AS "substring55695", SUBSTRING( ("public"."logs"."device_meta" #>> array [ ?,   ? ] :: text [] ) :: text, 1, 1234 ) AS "substring55657", SUBSTRING( ("public"."logs"."device_meta" #>> array [ ?,   ?,?,? ] :: text [] ) :: text, 1, 1234 ) AS "substring55704", SUBSTRING( ("public"."logs"."device_meta" #>> array [ ?,   ?,?,? ] :: text [] ) :: text, 1, 1234 ) AS "substring55679", SUBSTRING( ("public"."logs"."device_meta" #>> array [ ?,   ?,?,? ] :: text [] ) :: text, 1, 1234 ) AS "substring55650", SUBSTRING( ("public"."logs"."headers" #>> array [ ? ] :: text []) :: text, 1, 1234 ) AS "substring55697", SUBSTRING( ("public"."logs"."headers" #>> array [ ? ] :: text []) :: text, 1, 1234 ) AS "substring55644", SUBSTRING( ("public"."logs"."device_meta" #>> array [ ?,   ? ] :: text [] ) :: text, 1, 1234 ) AS "substring55675", SUBSTRING( ("public"."logs"."headers" #>> array [ ? ] :: text []) :: text, 1, 1234 ) AS "substring55702", SUBSTRING( ("public"."logs"."headers" #>> array [ ? ] :: text []) :: text, 1, 1234 ) AS "substring55689", SUBSTRING( ("public"."logs"."device_meta" #>> array [ ?,   ?,?,? ] :: text [] ) :: text, 1, 1234 ) AS "substring55672", SUBSTRING( ("public"."logs"."device_meta" #>> array [ ? ] :: text []) :: text, 1, 1234 ) AS "substring55659", SUBSTRING( ("public"."logs"."device_meta" #>> array [ ?,   ?,?,? ] :: text [] ) :: text, 1, 1234 ) AS "substring55711", SUBSTRING( ("public"."logs"."device_meta" #>> array [ ?,   ?,? ] :: text [] ) :: text, 1, 1234 ) AS "substring55674", SUBSTRING( ("public"."logs"."device_meta" #>> array [ ?,   ?,?,? ] :: text [] ) :: text, 1, 1234 ) AS "substring55662", SUBSTRING( ("public"."logs"."headers" #>> array [ ? ] :: text []) :: text, 1, 1234 ) AS "substring55699", SUBSTRING( ("public"."logs"."headers" #>> array [ ? ] :: text []) :: text, 1, 1234 ) AS "substring55684", SUBSTRING( ("public"."logs"."headers" #>> array [ ? ] :: text []) :: text, 1, 1234 ) AS "substring55690", SUBSTRING( ("public"."logs"."device_meta" #>> array [ ?,   ?,? ] :: text [] ) :: text, 1, 1234 ) AS "substring55663", SUBSTRING( ("public"."logs"."device_meta" #>> array [ ?,   ?,?,? ] :: text [] ) :: text, 1, 1234 ) AS "substring55669", SUBSTRING( ("public"."logs"."headers" #>> array [ ? ] :: text []) :: text, 1, 1234 ) AS "substring55696", SUBSTRING( ("public"."logs"."headers" #>> array [ ? ] :: text []) :: text, 1, 1234 ) AS "substring55698", SUBSTRING( ("public"."logs"."device_meta" #>> array [ ?,   ?,?,? ] :: text [] ) :: text, 1, 1234 ) AS "substring55652", SUBSTRING( ("public"."logs"."device_meta" #>> array [ ?,   ?,?,? ] :: text [] ) :: text, 1, 1234 ) AS "substring55666", SUBSTRING( ("public"."logs"."headers" #>> array [ ? ] :: text []) :: text, 1, 1234 ) AS "substring55643", SUBSTRING( ("public"."logs"."headers" #>> array [ ? ] :: text []) :: text, 1, 1234 ) AS "substring55687", SUBSTRING( ("public"."logs"."device_meta" #>> array [ ?,   ?,?,? ] :: text [] ) :: text, 1, 1234 ) AS "substring55655", SUBSTRING( ("public"."logs"."device_meta" #>> array [ ?,   ?,?,? ] :: text [] ) :: text, 1, 1234 ) AS "substring55713", SUBSTRING( ("public"."logs"."device_meta" #>> array [ ?,   ?,?,? ] :: text [] ) :: text, 1, 1234 ) AS "substring55668", SUBSTRING( ("public"."logs"."device_meta" #>> array [ ?,   ?,?,? ] :: text [] ) :: text, 1, 1234 ) AS "substring55681", SUBSTRING( ("public"."logs"."headers" #>> array [ ? ] :: text []) :: text, 1, 1234 ) AS "substring55715" FROM "public"."logs" ) AS "source" LIMIT 10000;

Error:

SQL Error [42601]: ERROR: syntax error at or near ","
  Position: 86

For reference, this is the string around that ",":

array [ ?, ? ]

shrey · January 17, 2024, 4:26pm

@Luiggi
@staff

?

Luiggi · January 18, 2024, 8:03pm

I would suggest you try to run and review that SQL on an external SQL client, I believe that the SQL is badly formed ( e.g. question marks). Try to come up with a SQL that works

shrey · January 19, 2024, 1:26am

@Luiggi

Why would i do that?

This 'malformed' SQL query is obtained from the logs, implying: something's wrong in the execution inside Metabase.

That's exactly my point. Why is the query badly formed?

shrey · January 22, 2024, 2:57am

@Luiggi
?

shrey · January 25, 2024, 1:57am

It's been 2 weeks since i first reported this issue!

Is this the only support channel?

shrey · February 6, 2024, 3:06am

@staff
?

smonaghan000 · February 22, 2024, 4:28pm

Continuing the discussion from Invalid input syntax error:

I am also experiencing a similar behavior with nested JSON fields and bigint casts. A few details.

Metabase v0.48.6
psql (14.10 (Ubuntu 14.10-0ubuntu0.22.04.1))
openjdk version "18.0.2-ea" 2022-07-19
OpenJDK Runtime Environment (build 18.0.2-ea+9-Ubuntu-222.04)
OpenJDK 64-Bit Server VM (build 18.0.2-ea+9-Ubuntu-222.04, mixed mode, sharing)

FWIW I've tried a couple searches through metabase github issues and this discourse, and this thread per @shrey was the closest match to what I am experiencing.

BLUF: Per @Luiggi's recommendation, I was able to correctly define a query which, rather than casting nested JSON as ::bigint, correctly casts them as ::decimal.

But the question remains, as the failing query is automatically generated and executed by metabase when simply browsing my data via the Metabase UI. Meaning, There appears to be an issue in how metabase has interpreted the schema of my nested JSON.

Q: What can I do to correct Metabase's apparent incorrect interpretation of my schema?

What I see on screen.

What I see in the metabase_field table for fields in question.

     display_name     |        base_type         |    semantic_type    |      effective_type      
----------------------+--------------------------+---------------------+--------------------------
 Extrinsics           | type/JSON                | type/SerializedJSON | type/JSON
 Extrinsics → Alt     | type/Number              |                     | type/Number
 Extrinsics → Phi     | type/Float               |                     | type/Float
 Extrinsics → Omega   | type/Float               |                     | type/Float
 Extrinsics → Kappa   | type/Float               |                     | type/Float
 Extrinsics → Lat     | type/Float               |                     | type/Float
 Extrinsics → Lon     | type/Float               |                     | type/Float
 Intrinsics           | type/JSON                | type/SerializedJSON | type/JSON
 Intrinsics → Cy      | type/Number              |                     | type/Number
 Intrinsics → P2      | type/Number              |                     | type/Number
 Intrinsics → K1      | type/Decimal             |                     | type/Integer
 Intrinsics → Fx      | type/Decimal             |                     | type/Integer
 Intrinsics → Fy      | type/Decimal             |                     | type/Integer
 Intrinsics → Columns | type/Decimal             | type/Category       | type/Integer
 Intrinsics → Cx      | type/Number              |                     | type/Number
 Intrinsics → C       | type/Float               |                     | type/Float
 Intrinsics → P4      | type/Float               |                     | type/Float
 Intrinsics → F       | type/Float               |                     | type/Float
 Intrinsics → P3      | type/Float               |                     | type/Float
 Intrinsics → K3      | type/Decimal             |                     | type/Integer
 Intrinsics → D       | type/Decimal             |                     | type/Integer
 Intrinsics → E       | type/Decimal             |                     | type/Integer
 Intrinsics → P1      | type/Decimal             |                     | type/Integer
 Intrinsics → Rows    | type/Decimal             | type/Category       | type/Integer
 Intrinsics → K2      | type/Decimal             |                     | type/Integer

And FWIW I tried manually changing all effective_type from type/Integer to type/Decimal to no avail.

What I see in logs

2024-02-21 08:51:14,510 ERROR middleware.catch-exceptions :: Error processing query: ERROR: invalid input syntax for type bigint: "2.169718801011349"
{:database_id 2,
 :started_at #t "2024-02-21T08:51:14.347543694-05:00[America/New_York]",
 :via
 [{:status :failed,
   :class clojure.lang.ExceptionInfo,
   :error "Error executing query: ERROR: invalid input syntax for type bigint: \"2.169718801011349\"",
   :stacktrace
   ["--> driver.sql_jdbc.execute$execute_reducible_query$fn__77840$fn__77841.invoke(execute.clj:698)"
    "driver.sql_jdbc.execute$execute_reducible_query$fn__77840.invoke(execute.clj:695)"
    "driver.sql_jdbc.execute$fn__77633$fn__77634.invoke(execute.clj:388)"
    "driver.sql_jdbc.execute$do_with_resolved_connection.invokeStatic(execute.clj:334)"
    "driver.sql_jdbc.execute$do_with_resolved_connection.invoke(execute.clj:317)"
    "driver.sql_jdbc.execute$fn__77633.invokeStatic(execute.clj:382)"
    "driver.sql_jdbc.execute$fn__77633.invoke(execute.clj:380)"
    "driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:689)"
    "driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:678)"
    "driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:686)"
    "driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:678)"
    "driver.sql_jdbc$fn__105608.invokeStatic(sql_jdbc.clj:82)"
    "driver.sql_jdbc$fn__105608.invoke(sql_jdbc.clj:80)"
    "query_processor.context$executef.invokeStatic(context.clj:60)"
    "query_processor.context$executef.invoke(context.clj:49)"
    "query_processor.context.default$default_runf.invokeStatic(default.clj:44)"
    "query_processor.context.default$default_runf.invoke(default.clj:42)"
    "query_processor.context$runf.invokeStatic(context.clj:46)"
    "query_processor.context$runf.invoke(context.clj:40)"
    "query_processor.reducible$identity_qp.invokeStatic(reducible.clj:39)"
    "query_processor.reducible$identity_qp.invoke(reducible.clj:36)"
    "query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___70834.invoke(cache.clj:229)"
    "query_processor.middleware.permissions$check_query_permissions$fn__65043.invoke(permissions.clj:140)"
    "query_processor.middleware.enterprise$check_download_permissions_middleware$fn__70655.invoke(enterprise.clj:51)"
    "query_processor.middleware.enterprise$maybe_apply_column_level_perms_check_middleware$fn__70665.invoke(enterprise.clj:64)"
    "query_processor.middleware.mbql_to_native$mbql__GT_native$fn__69902.invoke(mbql_to_native.clj:24)"
    "query_processor$fn__71968$combined_post_process__71973$combined_post_process_STAR___71974.invoke(query_processor.clj:262)"
    "query_processor$fn__71968$combined_pre_process__71969$combined_pre_process_STAR___71970.invoke(query_processor.clj:259)"
    "query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__65140.invoke(fetch_source_query.clj:303)"
    "query_processor.middleware.resolve_database_and_driver$resolve_driver_and_database_local_values$fn__70745$fn__70749.invoke(resolve_database_and_driver.clj:77)"
    "driver$do_with_driver.invokeStatic(driver.clj:94)"
    "driver$do_with_driver.invoke(driver.clj:89)"
    "query_processor.middleware.resolve_database_and_driver$resolve_driver_and_database_local_values$fn__70745.invoke(resolve_database_and_driver.clj:76)"
    "query_processor.middleware.store$initialize_store$fn__65532$fn__65533.invoke(store.clj:14)"
    "query_processor.store$do_with_metadata_provider.invokeStatic(store.clj:169)"
    "query_processor.store$do_with_metadata_provider.invoke(store.clj:150)"
    "query_processor.store$do_with_metadata_provider.invokeStatic(store.clj:158)"
    "query_processor.store$do_with_metadata_provider.invoke(store.clj:150)"
    "query_processor.middleware.store$initialize_store$fn__65532.invoke(store.clj:13)"
    "query_processor.middleware.resolve_database_and_driver$resolve_database$fn__70742.invoke(resolve_database_and_driver.clj:60)"
    "query_processor.middleware.normalize_query$normalize$fn__71047.invoke(normalize_query.clj:38)"
    "query_processor.middleware.enterprise$fn__70682$handle_audit_app_internal_queries__70683$fn__70685.invoke(enterprise.clj:96)"
    "query_processor.middleware.enterprise$handle_audit_app_internal_queries_middleware$fn__70693.invoke(enterprise.clj:103)"
    "query_processor.middleware.constraints$mark_needs_default_userland_constraints$fn__69617.invoke(constraints.clj:102)"
    "query_processor.middleware.process_userland_query$process_userland_query$fn__70978.invoke(process_userland_query.clj:156)"
    "query_processor.middleware.catch_exceptions$catch_exceptions$fn__71568.invoke(catch_exceptions.clj:171)"
    "query_processor.reducible$async_qp$qp_STAR___60713$thunk__60715.invoke(reducible.clj:126)"
    "query_processor.reducible$async_qp$qp_STAR___60713.invoke(reducible.clj:132)"
    "query_processor.reducible$sync_qp$qp_STAR___60725.doInvoke(reducible.clj:153)"
    "query_processor$process_userland_query.invokeStatic(query_processor.clj:402)"
    "query_processor$process_userland_query.doInvoke(query_processor.clj:398)"
    "query_processor$process_query_and_save_execution_BANG_.invokeStatic(query_processor.clj:416)"
    "query_processor$process_query_and_save_execution_BANG_.invoke(query_processor.clj:406)"
    "query_processor$process_query_and_save_with_max_results_constraints_BANG_.invokeStatic(query_processor.clj:431)"
    "query_processor$process_query_and_save_with_max_results_constraints_BANG_.invoke(query_processor.clj:421)"
    "api.dataset$run_query_async$fn__93366.invoke(dataset.clj:79)"
    "query_processor.streaming$streaming_response_STAR_$fn__51578$fn__51580.invoke(streaming.clj:168)"
    "query_processor.streaming$streaming_response_STAR_$fn__51578.invoke(streaming.clj:167)"
    "async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:69)"
    "async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:67)"
    "async.streaming_response$do_f_async$task__42901.invoke(streaming_response.clj:88)"],
   :error_type :invalid-query,
   :ex-data
   {:driver :postgres,
    :sql
:: userID: 1 queryType: MBQL queryHash: 9874682a930cd29c37fa2558429daf223e1fbe7fc43140b1073b272545a8c30e"
     "SELECT"
     "  ("
     "    \"public\".\"metadata\".\"extrinsics\" #>> array [ ? ] :: text [ ]"
     "  ) :: double precision AS \"extrinsics → alt\","
     "  ("
     "    \"public\".\"metadata\".\"extrinsics\" #>> array [ ? ] :: text [ ]"
     "  ) :: double precision AS \"extrinsics → kappa\","
     "  ("
     "    \"public\".\"metadata\".\"extrinsics\" #>> array [ ? ] :: text [ ]"
     "  ) :: double precision AS \"extrinsics → lat\","
     "  ("
     "    \"public\".\"metadata\".\"extrinsics\" #>> array [ ? ] :: text [ ]"
     "  ) :: double precision AS \"extrinsics → lon\","
     "  ("
     "    \"public\".\"metadata\".\"extrinsics\" #>> array [ ? ] :: text [ ]"
     "  ) :: double precision AS \"extrinsics → omega\","
     "  ("
     "    \"public\".\"metadata\".\"extrinsics\" #>> array [ ? ] :: text [ ]"
     "  ) :: double precision AS \"extrinsics → phi\","
     "  \"public\".\"metadata\".\"id\" AS \"id\","
     "  ("
     "    \"public\".\"metadata\".\"intrinsics\" #>> array [ ? ] :: text [ ]"
     "  ) :: double precision AS \"intrinsics → C\","
     "  ("
     "    \"public\".\"metadata\".\"intrinsics\" #>> array [ ? ] :: text [ ]"
     "  ) :: bigint AS \"intrinsics → columns\","
     "  ("
     "    \"public\".\"metadata\".\"intrinsics\" #>> array [ ? ] :: text [ ]"
     "  ) :: double precision AS \"intrinsics → cx\","
     "  ("
     "    \"public\".\"metadata\".\"intrinsics\" #>> array [ ? ] :: text [ ]"
     "  ) :: double precision AS \"intrinsics → cy\","
     "  ("
     "    \"public\".\"metadata\".\"intrinsics\" #>> array [ ? ] :: text [ ]"
     "  ) :: bigint AS \"intrinsics → D\","
     "  ("
     "    \"public\".\"metadata\".\"intrinsics\" #>> array [ ? ] :: text [ ]"
     "  ) :: bigint AS \"intrinsics → E\","
     "  ("
     "    \"public\".\"metadata\".\"intrinsics\" #>> array [ ? ] :: text [ ]"
     "  ) :: double precision AS \"intrinsics → F\","
     "  ("
     "    \"public\".\"metadata\".\"intrinsics\" #>> array [ ? ] :: text [ ]"
     "  ) :: bigint AS \"intrinsics → fx\","
     "  ("
     "    \"public\".\"metadata\".\"intrinsics\" #>> array [ ? ] :: text [ ]"
     "  ) :: bigint AS \"intrinsics → fy\","
     "  ("
     "    \"public\".\"metadata\".\"intrinsics\" #>> array [ ? ] :: text [ ]"
     "  ) :: bigint AS \"intrinsics → k1\","
     "  ("
     "    \"public\".\"metadata\".\"intrinsics\" #>> array [ ? ] :: text [ ]"
     "  ) :: bigint AS \"intrinsics → k2\","
     "  ("
     "    \"public\".\"metadata\".\"intrinsics\" #>> array [ ? ] :: text [ ]"
     "  ) :: bigint AS \"intrinsics → k3\","
     "  ("
     "    \"public\".\"metadata\".\"intrinsics\" #>> array [ ? ] :: text [ ]"
     "  ) :: bigint AS \"intrinsics → p1\","
     "  ("
     "    \"public\".\"metadata\".\"intrinsics\" #>> array [ ? ] :: text [ ]"
     "  ) :: double precision AS \"intrinsics → p2\","
     "  ("
     "    \"public\".\"metadata\".\"intrinsics\" #>> array [ ? ] :: text [ ]"
     "  ) :: double precision AS \"intrinsics → p3\","
     "  ("
     "    \"public\".\"metadata\".\"intrinsics\" #>> array [ ? ] :: text [ ]"
     "  ) :: double precision AS \"intrinsics → p4\","
     "  ("
     "    \"public\".\"metadata\".\"intrinsics\" #>> array [ ? ] :: text [ ]"
     "  ) :: bigint AS \"intrinsics → rows\","
     "  \"public\".\"metadata\".\"inserted\" AS \"inserted\","
     "  \"public\".\"metadata\".\"file\" AS \"file\","
     "  \"public\".\"metadata\".\"version\" AS \"version\","
     "  \"public\".\"metadata\".\"fname\" AS \"fname\","
     "  \"public\".\"metadata\".\"site\" AS \"site\","
     "  \"public\".\"metadata\".\"source\" AS \"source\","
     "  \"public\".\"metadata\".\"collection\" AS \"collection\","
     "  \"public\".\"metadata\".\"timestamp\" AS \"timestamp\","
     "  \"public\".\"metadata\".\"extrinsics\" AS \"extrinsics\","
     "  \"public\".\"metadata\".\"intrinsics\" AS \"intrinsics\","
     "  \"public\".\"metadata\".\"projection\" AS \"projection\","
     "  \"public\".\"metadata\".\"calibration\" AS \"calibration\","
     "  \"public\".\"metadata\".\"geolocation\" AS \"geolocation\","
     "  \"public\".\"metadata\".\"pii_status\" AS \"pii_status\","
     "  \"public\".\"metadata\".\"env_conditions\" AS \"env_conditions\","
     "  \"public\".\"metadata\".\"type\" AS \"type\","
     "  \"public\".\"metadata\".\"modes\" AS \"modes\","
     "  \"public\".\"metadata\".\"exterior\" AS \"exterior\","
     "  \"public\".\"metadata\".\"interior\" AS \"interior\","
     "  \"public\".\"metadata\".\"transient_occlusions\" AS \"transient_occlusions\","
     "  \"public\".\"metadata\".\"artifacts\" AS \"artifacts\","
     "  \"public\".\"metadata\".\"pii_detected\" AS \"pii_detected\","
     "  \"public\".\"metadata\".\"pii_removed\" AS \"pii_removed\","
     "  \"public\".\"metadata\".\"masks\" AS \"masks\","
     "  \"public\".\"metadata\".\"notes\" AS \"notes\""
     "FROM"
     "  \"public\".\"metadata\""
     "LIMIT"
     "  2000"],
    :params
    ("alt"
     "kappa"
     "lat"
     "lon"
     "omega"
     "phi"
     "C"
     "columns"
     "cx"
     "cy"
     "D"
     "E"
     "F"
     "fx"
     "fy"
     "k1"
     "k2"
     "k3"
     "p1"
     "p2"
     "p3"
     "p4"
     "rows"),
    :type :invalid-query}}],
 :action_id nil,
 :state "22P02",
 :error_type :invalid-query,
 :json_query
 {:database 2,
  :query {:source-table 9},
  :type "query",
  :parameters [],
  :middleware {:js-int-to-string? true, :add-default-userland-constraints? true}},
 :native
 {:query
  "SELECT (\"public\".\"metadata\".\"extrinsics\"#>> array[?]::text[])::double precision AS \"extrinsics → alt\", (\"public\".\"metadata\".\"extrinsics\"#>> array[?]::text[])::double precision AS \"extrinsics → kappa\", (\"public\".\"metadata\".\"extrinsics\"#>> array[?]::text[])::double precision AS \"extrinsics → lat\", (\"public\".\"metadata\".\"extrinsics\"#>> array[?]::text[])::double precision AS \"extrinsics → lon\", (\"public\".\"metadata\".\"extrinsics\"#>> array[?]::text[])::double precision AS \"extrinsics → omega\", (\"public\".\"metadata\".\"extrinsics\"#>> array[?]::text[])::double precision AS \"extrinsics → phi\", \"public\".\"metadata\".\"id\" AS \"id\", (\"public\".\"metadata\".\"intrinsics\"#>> array[?]::text[])::double precision AS \"intrinsics → C\", (\"public\".\"metadata\".\"intrinsics\"#>> array[?]::text[])::bigint AS \"intrinsics → columns\", (\"public\".\"metadata\".\"intrinsics\"#>> array[?]::text[])::double precision AS \"intrinsics → cx\", (\"public\".\"metadata\".\"intrinsics\"#>> array[?]::text[])::double precision AS \"intrinsics → cy\", (\"public\".\"metadata\".\"intrinsics\"#>> array[?]::text[])::bigint AS \"intrinsics → D\", (\"public\".\"metadata\".\"intrinsics\"#>> array[?]::text[])::bigint AS \"intrinsics → E\", (\"public\".\"metadata\".\"intrinsics\"#>> array[?]::text[])::double precision AS \"intrinsics → F\", (\"public\".\"metadata\".\"intrinsics\"#>> array[?]::text[])::bigint AS \"intrinsics → fx\", (\"public\".\"metadata\".\"intrinsics\"#>> array[?]::text[])::bigint AS \"intrinsics → fy\", (\"public\".\"metadata\".\"intrinsics\"#>> array[?]::text[])::bigint AS \"intrinsics → k1\", (\"public\".\"metadata\".\"intrinsics\"#>> array[?]::text[])::bigint AS \"intrinsics → k2\", (\"public\".\"metadata\".\"intrinsics\"#>> array[?]::text[])::bigint AS \"intrinsics → k3\", (\"public\".\"metadata\".\"intrinsics\"#>> array[?]::text[])::bigint AS \"intrinsics → p1\", (\"public\".\"metadata\".\"intrinsics\"#>> array[?]::text[])::double precision AS \"intrinsics → p2\", (\"public\".\"metadata\".\"intrinsics\"#>> array[?]::text[])::double precision AS \"intrinsics → p3\", (\"public\".\"metadata\".\"intrinsics\"#>> array[?]::text[])::double precision AS \"intrinsics → p4\", (\"public\".\"metadata\".\"intrinsics\"#>> array[?]::text[])::bigint AS \"intrinsics → rows\", \"public\".\"metadata\".\"inserted\" AS \"inserted\", \"public\".\"metadata\".\"file\" AS \"file\", \"public\".\"metadata\".\"version\" AS \"version\", \"public\".\"metadata\".\"fname\" AS \"fname\", \"public\".\"metadata\".\"site\" AS \"site\", \"public\".\"metadata\".\"source\" AS \"source\", \"public\".\"metadata\".\"collection\" AS \"collection\", \"public\".\"metadata\".\"timestamp\" AS \"timestamp\", \"public\".\"metadata\".\"extrinsics\" AS \"extrinsics\", \"public\".\"metadata\".\"intrinsics\" AS \"intrinsics\", \"public\".\"metadata\".\"projection\" AS \"projection\", \"public\".\"metadata\".\"calibration\" AS \"calibration\", \"public\".\"metadata\".\"geolocation\" AS \"geolocation\", \"public\".\"metadata\".\"pii_status\" AS \"pii_status\", \"public\".\"metadata\".\"env_conditions\" AS \"env_conditions\", \"public\".\"metadata\".\"type\" AS \"type\", \"public\".\"metadata\".\"modes\" AS \"modes\", \"public\".\"metadata\".\"exterior\" AS \"exterior\", \"public\".\"metadata\".\"interior\" AS \"interior\", \"public\".\"metadata\".\"transient_occlusions\" AS \"transient_occlusions\", \"public\".\"metadata\".\"artifacts\" AS \"artifacts\", \"public\".\"metadata\".\"pii_detected\" AS \"pii_detected\", \"public\".\"metadata\".\"pii_removed\" AS \"pii_removed\", \"public\".\"metadata\".\"masks\" AS \"masks\", \"public\".\"metadata\".\"notes\" AS \"notes\" FROM \"public\".\"metadata\" LIMIT 1048575",
  :params
  ("alt"
   "kappa"
   "lat"
   "lon"
   "omega"
   "phi"
   "C"
   "columns"
   "cx"
   "cy"
   "D"
   "E"
   "F"
   "fx"
   "fy"
   "k1"
   "k2"
   "k3"
   "p1"
   "p2"
   "p3"
   "p4"
   "rows")},
 :status :failed,
 :class org.postgresql.util.PSQLException,
 :stacktrace
 ["org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2713)"
  "org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2401)"
  "org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:368)"
  "org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:498)"
  "org.postgresql.jdbc.PgStatement.execute(PgStatement.java:415)"
  "org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:190)"
  "org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:134)"
  "com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:1471)"
  "--> driver.sql_jdbc.execute$fn__77757.invokeStatic(execute.clj:556)"
  "driver.sql_jdbc.execute$fn__77757.invoke(execute.clj:554)"
  "driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_.invokeStatic(execute.clj:569)"
  "driver.sql_jdbc.execute$execute_statement_or_prepared_statement_BANG_.invoke(execute.clj:565)"
  "driver.sql_jdbc.execute$execute_reducible_query$fn__77840$fn__77841.invoke(execute.clj:696)"
  "driver.sql_jdbc.execute$execute_reducible_query$fn__77840.invoke(execute.clj:695)"
  "driver.sql_jdbc.execute$fn__77633$fn__77634.invoke(execute.clj:388)"
  "driver.sql_jdbc.execute$do_with_resolved_connection.invokeStatic(execute.clj:334)"
  "driver.sql_jdbc.execute$do_with_resolved_connection.invoke(execute.clj:317)"
  "driver.sql_jdbc.execute$fn__77633.invokeStatic(execute.clj:382)"
  "driver.sql_jdbc.execute$fn__77633.invoke(execute.clj:380)"
  "driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:689)"
  "driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:678)"
  "driver.sql_jdbc.execute$execute_reducible_query.invokeStatic(execute.clj:686)"
  "driver.sql_jdbc.execute$execute_reducible_query.invoke(execute.clj:678)"
  "driver.sql_jdbc$fn__105608.invokeStatic(sql_jdbc.clj:82)"
  "driver.sql_jdbc$fn__105608.invoke(sql_jdbc.clj:80)"
  "query_processor.context$executef.invokeStatic(context.clj:60)"
  "query_processor.context$executef.invoke(context.clj:49)"
  "query_processor.context.default$default_runf.invokeStatic(default.clj:44)"
  "query_processor.context.default$default_runf.invoke(default.clj:42)"
  "query_processor.context$runf.invokeStatic(context.clj:46)"
  "query_processor.context$runf.invoke(context.clj:40)"
  "query_processor.reducible$identity_qp.invokeStatic(reducible.clj:39)"
  "query_processor.reducible$identity_qp.invoke(reducible.clj:36)"
  "query_processor.middleware.cache$maybe_return_cached_results$maybe_return_cached_results_STAR___70834.invoke(cache.clj:229)"
  "query_processor.middleware.permissions$check_query_permissions$fn__65043.invoke(permissions.clj:140)"
  "query_processor.middleware.enterprise$check_download_permissions_middleware$fn__70655.invoke(enterprise.clj:51)"
  "query_processor.middleware.enterprise$maybe_apply_column_level_perms_check_middleware$fn__70665.invoke(enterprise.clj:64)"
  "query_processor.middleware.mbql_to_native$mbql__GT_native$fn__69902.invoke(mbql_to_native.clj:24)"
  "query_processor$fn__71968$combined_post_process__71973$combined_post_process_STAR___71974.invoke(query_processor.clj:262)"
  "query_processor$fn__71968$combined_pre_process__71969$combined_pre_process_STAR___71970.invoke(query_processor.clj:259)"
  "query_processor.middleware.fetch_source_query$resolve_card_id_source_tables$fn__65140.invoke(fetch_source_query.clj:303)"
  "query_processor.middleware.resolve_database_and_driver$resolve_driver_and_database_local_values$fn__70745$fn__70749.invoke(resolve_database_and_driver.clj:77)"
  "driver$do_with_driver.invokeStatic(driver.clj:94)"
  "driver$do_with_driver.invoke(driver.clj:89)"
  "query_processor.middleware.resolve_database_and_driver$resolve_driver_and_database_local_values$fn__70745.invoke(resolve_database_and_driver.clj:76)"
  "query_processor.middleware.store$initialize_store$fn__65532$fn__65533.invoke(store.clj:14)"
  "query_processor.store$do_with_metadata_provider.invokeStatic(store.clj:169)"
  "query_processor.store$do_with_metadata_provider.invoke(store.clj:150)"
  "query_processor.store$do_with_metadata_provider.invokeStatic(store.clj:158)"
  "query_processor.store$do_with_metadata_provider.invoke(store.clj:150)"
  "query_processor.middleware.store$initialize_store$fn__65532.invoke(store.clj:13)"
  "query_processor.middleware.resolve_database_and_driver$resolve_database$fn__70742.invoke(resolve_database_and_driver.clj:60)"
  "query_processor.middleware.normalize_query$normalize$fn__71047.invoke(normalize_query.clj:38)"
  "query_processor.middleware.enterprise$fn__70682$handle_audit_app_internal_queries__70683$fn__70685.invoke(enterprise.clj:96)"
  "query_processor.middleware.enterprise$handle_audit_app_internal_queries_middleware$fn__70693.invoke(enterprise.clj:103)"
  "query_processor.middleware.constraints$mark_needs_default_userland_constraints$fn__69617.invoke(constraints.clj:102)"
  "query_processor.middleware.process_userland_query$process_userland_query$fn__70978.invoke(process_userland_query.clj:156)"
  "query_processor.middleware.catch_exceptions$catch_exceptions$fn__71568.invoke(catch_exceptions.clj:171)"
  "query_processor.reducible$async_qp$qp_STAR___60713$thunk__60715.invoke(reducible.clj:126)"
  "query_processor.reducible$async_qp$qp_STAR___60713.invoke(reducible.clj:132)"
  "query_processor.reducible$sync_qp$qp_STAR___60725.doInvoke(reducible.clj:153)"
  "query_processor$process_userland_query.invokeStatic(query_processor.clj:402)"
  "query_processor$process_userland_query.doInvoke(query_processor.clj:398)"
  "query_processor$process_query_and_save_execution_BANG_.invokeStatic(query_processor.clj:416)"
  "query_processor$process_query_and_save_execution_BANG_.invoke(query_processor.clj:406)"
  "query_processor$process_query_and_save_with_max_results_constraints_BANG_.invokeStatic(query_processor.clj:431)"
  "query_processor$process_query_and_save_with_max_results_constraints_BANG_.invoke(query_processor.clj:421)"
  "api.dataset$run_query_async$fn__93366.invoke(dataset.clj:79)"
  "query_processor.streaming$streaming_response_STAR_$fn__51578$fn__51580.invoke(streaming.clj:168)"
  "query_processor.streaming$streaming_response_STAR_$fn__51578.invoke(streaming.clj:167)"
  "async.streaming_response$do_f_STAR_.invokeStatic(streaming_response.clj:69)"
  "async.streaming_response$do_f_STAR_.invoke(streaming_response.clj:67)"
  "async.streaming_response$do_f_async$task__42901.invoke(streaming_response.clj:88)"],
 :card_id nil,
 :context :ad-hoc,
 :error "ERROR: invalid input syntax for type bigint: \"2.169718801011349\"",
 :row_count 0,
 :running_time 0,
 :preprocessed
 {:database 2,
  :query
  {:source-table 9,
   :fields
   [[:field 86 nil]
    [:field 109 nil]
    [:field 110 nil]
    [:field 111 nil]
    [:field 101 nil]
    [:field 91 nil]
    [:field 76 nil]
    [:field 114 nil]
    [:field 81 nil]
    [:field 98 nil]
    [:field 72 nil]
    [:field 116 nil]
    [:field 118 nil]
    [:field 117 nil]
    [:field 93 nil]
    [:field 94 nil]
    [:field 84 nil]
    [:field 105 nil]
    [:field 106 nil]
    [:field 73 nil]
    [:field 85 nil]
    [:field 119 nil]
    [:field 115 nil]
    [:field 78 nil]
    [:field 79 {:temporal-unit :default}]
    [:field 103 nil]
    [:field 92 nil]
    [:field 75 nil]
    [:field 80 nil]
    [:field 108 nil]
    [:field 100 nil]
    [:field 112 nil]
    [:field 74 nil]
    [:field 90 nil]
    [:field 95 nil]
    [:field 96 nil]
    [:field 77 nil]
    [:field 83 nil]
    [:field 89 nil]
    [:field 99 nil]
    [:field 87 nil]
    [:field 113 nil]
    [:field 88 nil]
    [:field 97 nil]
    [:field 82 nil]
    [:field 104 nil]
    [:field 102 nil]
    [:field 107 nil]
    [:field 120 nil]],
   :limit 1048575,
   :metabase.query-processor.middleware.limit/original-limit nil},
  :type :query,
  :middleware {:js-int-to-string? true, :add-default-userland-constraints? true},
  :info {:executed-by 1, :context :ad-hoc}},
 :data {:rows [], :cols []}}

And per @Luiggi's recommendation I tried crafting some similar SQL to see if I could replicate the behavior - which I could:

my_database=> SELECT (extrinsics #>> array ['alt'] :: text [ ]) :: double precision AS extrinsics_alt,
 (extrinsics #>> array ['kappa'] :: text [ ]) :: double precision AS extrinsics_kappa,
 (extrinsics #>> array ['lat'] :: text [ ]) :: double precision AS extrinsics_lat,
 (extrinsics #>> array ['lon'] :: text [ ]) :: double precision AS extrinsics_lon,
 (extrinsics #>> array ['omega'] :: text [ ]) :: double precision AS extrinsics_omega,
 (extrinsics #>> array ['phi'] :: text [ ]) :: double precision AS extrinsics_phi,
 id AS id,
 (intrinsics #>> array ['C'] :: text [ ]) :: double precision AS intrinsics_C,
 (intrinsics #>> array ['columns'] :: text [ ]) :: bigint AS intrinsics_columns,
 (intrinsics #>> array ['cx'] :: text [ ]) :: double precision AS intrinsics_cx,
 (intrinsics #>> array ['cy'] :: text [ ]) :: double precision AS intrinsics_cy,
 (intrinsics #>> array ['D'] :: text [ ]) :: bigint AS intrinsics_D,
 (intrinsics #>> array ['E'] :: text [ ]) :: bigint AS intrinsics_E,
 (intrinsics #>> array ['F'] :: text [ ]) :: double precision AS intrinsics_F,
 (intrinsics #>> array ['fx'] :: text [ ]) :: bigint AS intrinsics_fx,
 (intrinsics #>> array ['fy'] :: text [ ]) :: bigint AS intrinsics_fy,
 (intrinsics #>> array ['k1'] :: text [ ]) :: bigint AS intrinsics_k1,
 (intrinsics #>> array ['k2'] :: text [ ]) :: bigint AS intrinsics_k2,
 (intrinsics #>> array ['k3'] :: text [ ]) :: bigint AS intrinsics_k3,
 (intrinsics #>> array ['p1'] :: text [ ]) :: bigint AS intrinsics_p1,
 (intrinsics #>> array ['p2'] :: text [ ]) :: double precision AS intrinsics_p2,
 (intrinsics #>> array ['p3'] :: text [ ]) :: double precision AS intrinsics_p3,
 (intrinsics #>> array ['p4'] :: text [ ]) :: double precision AS intrinsics_p4,
 (intrinsics #>> array ['rows'] :: text [ ]) :: bigint AS intrinsics_rows,
 inserted AS inserted,
 file AS file,
 version AS version,
 fname AS fname,
 site AS site,
 source AS source,
 collection AS collection,
 timestamp AS timestamp,
 extrinsics AS extrinsics,
 intrinsics AS intrinsics,
 projection AS projection,
 calibration AS calibration,
 geolocation AS geolocation,
 pii_status AS pii_status,
 env_conditions AS env_conditions,
 type AS type,
 modes AS modes,
 exterior AS exterior,
 interior AS interior,
 transient_occlusions AS transient_occlusions,
 artifacts AS artifacts,
 pii_detected AS pii_detected,
 pii_removed AS pii_removed,
 masks AS masks,
 notes AS notes FROM my_table LIMIT 2000;

ERROR:  invalid input syntax for type bigint: "2.169718801011349"

And lastly the manually corrected SQL, casting the nested fields as :: decimal not :: bigint

my_database=> SELECT (extrinsics #>> array ['alt'] :: text [ ]) :: double precision AS extrinsics_alt,
 (extrinsics #>> array ['kappa'] :: text [ ]) :: double precision AS extrinsics_kappa,
 (extrinsics #>> array ['lat'] :: text [ ]) :: double precision AS extrinsics_lat,
 (extrinsics #>> array ['lon'] :: text [ ]) :: double precision AS extrinsics_lon,
 (extrinsics #>> array ['omega'] :: text [ ]) :: double precision AS extrinsics_omega,
 (extrinsics #>> array ['phi'] :: text [ ]) :: double precision AS extrinsics_phi,
 id AS id,
 (intrinsics #>> array ['C'] :: text [ ]) :: double precision AS intrinsics_C,
 (intrinsics #>> array ['columns'] :: text [ ]) :: decimal AS intrinsics_columns,
 (intrinsics #>> array ['cx'] :: text [ ]) :: double precision AS intrinsics_cx,
 (intrinsics #>> array ['cy'] :: text [ ]) :: double precision AS intrinsics_cy,
 (intrinsics #>> array ['D'] :: text [ ]) :: decimal AS intrinsics_D,
 (intrinsics #>> array ['E'] :: text [ ]) :: decimal AS intrinsics_E,
 (intrinsics #>> array ['F'] :: text [ ]) :: double precision AS intrinsics_F,
 (intrinsics #>> array ['fx'] :: text [ ]) :: decimal AS intrinsics_fx,
 (intrinsics #>> array ['fy'] :: text [ ]) :: decimal AS intrinsics_fy,
 (intrinsics #>> array ['k1'] :: text [ ]) :: decimal AS intrinsics_k1,
 (intrinsics #>> array ['k2'] :: text [ ]) :: decimal AS intrinsics_k2,
 (intrinsics #>> array ['k3'] :: text [ ]) :: decimal AS intrinsics_k3,
 (intrinsics #>> array ['p1'] :: text [ ]) :: decimal AS intrinsics_p1,
 (intrinsics #>> array ['p2'] :: text [ ]) :: double precision AS intrinsics_p2,
 (intrinsics #>> array ['p3'] :: text [ ]) :: double precision AS intrinsics_p3,
 (intrinsics #>> array ['p4'] :: text [ ]) :: double precision AS intrinsics_p4,
 (intrinsics #>> array ['rows'] :: text [ ]) :: decimal AS intrinsics_rows,
 inserted AS inserted,
 file AS file,
 version AS version,
 fname AS fname,
 site AS site,
 source AS source,
 collection AS collection,
 timestamp AS timestamp,
 extrinsics AS extrinsics,
 intrinsics AS intrinsics,
 projection AS projection,
 calibration AS calibration,
 geolocation AS geolocation,
 pii_status AS pii_status,
 env_conditions AS env_conditions,
 type AS type,
 modes AS modes,
 exterior AS exterior,
 interior AS interior,
 transient_occlusions AS transient_occlusions,
 artifacts AS artifacts,
 pii_detected AS pii_detected,
 pii_removed AS pii_removed,
 masks AS masks,
 notes AS notes FROM my_table LIMIT 2000;

... 2000 rows returned

Luiggi · February 27, 2024, 1:26am

outstanding debugging @smonaghan000, thanks for this, it's super super useful. With this amount of information we can do our jobs easier (remember @shrey that the support level in this forum is simply best effort).

have you tried to change all the fields effective types to decimal?

the only workaround for this is simply to explode those jsons into actual columns and force Metabase to see that as a table rather than as a json, till we can find a way to understand better those structures

shrey · February 27, 2024, 3:47am

While it's appreciable that an affected user had the time and expertise to go through the in-depth diagnosis themselves (which shouldn't really be required in the first place), it doesn't excuse you (@Luiggi) for not acting in a competent & decent manner in providing 'best effort' (being the maintainer of the project), when providing 'support' for a core-issue.