2024-08-29 22:05:13.804 IST [629116] LOG: received fast shutdown request
2024-08-29 22:05:13.810 IST [629116] LOG: aborting any active transactions
2024-08-29 22:05:13.813 IST [629116] LOG: background worker "logical replication launcher" (PID 629139) exited with exit code 1
2024-08-29 22:05:13.850 IST [629124] LOG: shutting down
2024-08-29 22:05:13.856 IST [629124] LOG: checkpoint starting: shutdown immediate
2024-08-29 22:05:13.879 IST [629124] LOG: checkpoint complete: wrote 0 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.001 s, sync=0.001 s, total=0.029 s; sync files=0, longest=0.000 s, average=0.000 s; distance=0 kB, estimate=4350 kB; lsn=0/91BE9940, redo lsn=0/91BE9940
2024-08-29 22:05:13.889 IST [629116] LOG: database system is shut down
2024-08-29 22:05:20.348 IST [754139] WARNING: pga:: extension is being initialized
2024-08-29 22:05:20.362 IST [754139] LOG: starting PostgreSQL 16.4 (Ubuntu 16.4-1.pgdg22.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 11.4.0-1ubuntu1~22.04) 11.4.0, 64-bit
2024-08-29 22:05:20.362 IST [754139] LOG: listening on IPv4 address "0.0.0.0", port 28816
2024-08-29 22:05:20.362 IST [754139] LOG: listening on IPv6 address "::", port 28816
2024-08-29 22:05:20.372 IST [754139] LOG: listening on Unix socket "/home/popoyi/.pgrx/.s.PGSQL.28816"
2024-08-29 22:05:20.387 IST [754142] LOG: database system was shut down at 2024-08-29 22:05:13 IST
2024-08-29 22:05:20.399 IST [754145] LOG: PARADEDB_TELEMETRY var not set at compile time for pg_search
2024-08-29 22:05:20.399 IST [754146] LOG: starting pg_search shutdown worker at PID 754146
2024-08-29 22:05:20.400 IST [754139] LOG: database system is ready to accept connections
2024-08-29 22:05:20.400 IST [754147] LOG: starting pg_search insert worker at PID 754147
2024-08-29 22:05:52.051 IST [757643] LOG: statement:
lock table pg_catalog.pg_namespace in share row exclusive mode;
create schema if not exists _sqlx_test;
create table if not exists _sqlx_test.databases (
db_name text primary key,
test_path text not null,
created_at timestamptz not null default now()
);
create index if not exists databases_created_at
on _sqlx_test.databases(created_at);
create sequence if not exists _sqlx_test.database_ids;
2024-08-29 22:05:52.051 IST [757643] NOTICE: schema "_sqlx_test" already exists, skipping
2024-08-29 22:05:52.051 IST [757643] NOTICE: relation "databases" already exists, skipping
2024-08-29 22:05:52.052 IST [757643] NOTICE: relation "databases_created_at" already exists, skipping
2024-08-29 22:05:52.052 IST [757643] NOTICE: relation "database_ids" already exists, skipping
2024-08-29 22:05:52.053 IST [757643] LOG: execute sqlx_s_1: select db_name from _sqlx_test.databases where created_at < (to_timestamp($1) at time zone 'UTC')
2024-08-29 22:05:52.053 IST [757643] DETAIL: parameters: $1 = '1724949350'
2024-08-29 22:05:52.053 IST [757643] WARNING: pga:: *** executor_run() X ***
2024-08-29 22:05:52.054 IST [757643] WARNING: pga:: *** ExtensionHook::executor_run() X ***
2024-08-29 22:05:52.054 IST [757643] WARNING: pga:: *** get_current_query() X ***
2024-08-29 22:05:52.054 IST [757643] WARNING: pga:: *** get_current_query() "select db_name from _sqlx_test.databases where created_at < (to_timestamp($1) at time zone 'UTC')" ***
2024-08-29 22:05:52.054 IST [757643] WARNING: pga:: *** get_query_relations() X ***
2024-08-29 22:05:52.054 IST [757643] WARNING: pga:: *** get_query_relations() 1 ***
2024-08-29 22:05:52.054 IST [757643] WARNING: query_relations.is_empty() :: false
2024-08-29 22:05:52.054 IST [757643] WARNING: pga:: *** ExtensionHook::executor_run() Y Stg-01 ***
2024-08-29 22:05:52.054 IST [757643] WARNING: pga:: *** executor_run() Y ***
2024-08-29 22:05:52.055 IST [757643] LOG: statement: drop database if exists "_sqlx_test_627";
2024-08-29 22:05:52.058 IST [754140] LOG: checkpoint starting: immediate force wait
2024-08-29 22:05:52.092 IST [754140] LOG: checkpoint complete: wrote 5 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.011 s, sync=0.007 s, total=0.034 s; sync files=4, longest=0.003 s, average=0.002 s; distance=5 kB, estimate=5 kB; lsn=0/91BEB0E8, redo lsn=0/91BEB0B0
2024-08-29 22:05:52.106 IST [757643] LOG: execute sqlx_s_2: delete from _sqlx_test.databases where db_name = any($1::text[])
2024-08-29 22:05:52.106 IST [757643] DETAIL: parameters: $1 = '{_sqlx_test_627}'
2024-08-29 22:05:52.106 IST [757643] WARNING: pga:: *** executor_run() X ***
2024-08-29 22:05:52.106 IST [757643] WARNING: pga:: *** ExtensionHook::executor_run() X ***
2024-08-29 22:05:52.106 IST [757643] WARNING: pga:: *** get_current_query() X ***
2024-08-29 22:05:52.106 IST [757643] WARNING: pga:: *** get_current_query() "delete from _sqlx_test.databases where db_name = any($1::text[])" ***
2024-08-29 22:05:52.106 IST [757643] WARNING: pga:: *** get_query_relations() X ***
2024-08-29 22:05:52.106 IST [757643] WARNING: pga:: *** get_query_relations() 1 ***
2024-08-29 22:05:52.106 IST [757643] WARNING: query_relations.is_empty() :: false
2024-08-29 22:05:52.107 IST [757643] WARNING: pga:: *** ExtensionHook::executor_run() Y Stg-01 ***
2024-08-29 22:05:52.107 IST [757643] WARNING: pga:: *** executor_run() Y ***
2024-08-29 22:05:52.108 IST [757643] LOG: execute sqlx_s_3:
insert into _sqlx_test.databases(db_name, test_path)
select '_sqlx_test_' || nextval('_sqlx_test.database_ids'), $1
returning db_name
2024-08-29 22:05:52.108 IST [757643] DETAIL: parameters: $1 = '1724949352040486'
2024-08-29 22:05:52.108 IST [757643] WARNING: pga:: *** executor_run() X ***
2024-08-29 22:05:52.108 IST [757643] WARNING: pga:: *** ExtensionHook::executor_run() X ***
2024-08-29 22:05:52.108 IST [757643] WARNING: pga:: *** get_current_query() X ***
2024-08-29 22:05:52.108 IST [757643] WARNING: pga:: *** get_current_query() "\n insert into _sqlx_test.databases(db_name, test_path)\n select '_sqlx_test_' || nextval('_sqlx_test.database_ids'), $1\n returning db_name\n " ***
2024-08-29 22:05:52.108 IST [757643] WARNING: pga:: *** get_query_relations() X ***
2024-08-29 22:05:52.108 IST [757643] WARNING: pga:: *** get_query_relations() 1 ***
2024-08-29 22:05:52.108 IST [757643] WARNING: query_relations.is_empty() :: false
2024-08-29 22:05:52.108 IST [757643] WARNING: pga:: *** ExtensionHook::executor_run() Y Stg-01 ***
2024-08-29 22:05:52.108 IST [757643] WARNING: pga:: *** executor_run() Y ***
2024-08-29 22:05:52.111 IST [757643] LOG: statement: create database "_sqlx_test_628"
2024-08-29 22:05:52.194 IST [757678] LOG: execute sqlx_s_1: CREATE EXTENSION pg_analytics;
2024-08-29 22:05:52.203 IST [757679] LOG: statement: drop database if exists "_sqlx_test_628";
2024-08-29 22:05:57.205 IST [757679] ERROR: database "_sqlx_test_628" is being accessed by other users
2024-08-29 22:05:57.205 IST [757679] DETAIL: There is 1 other session using the database.
2024-08-29 22:05:57.205 IST [757679] STATEMENT: drop database if exists "_sqlx_test_628";
2024-08-29 22:06:02.245 IST [757678] LOG: statement:
DROP TABLE IF EXISTS auto_sales_partitioned CASCADE;
2024-08-29 22:06:02.246 IST [757678] NOTICE: table "auto_sales_partitioned" does not exist, skipping
2024-08-29 22:06:02.246 IST [757678] LOG: statement:
DROP SERVER IF EXISTS auto_sales_server CASCADE;
2024-08-29 22:06:02.246 IST [757678] NOTICE: server "auto_sales_server" does not exist, skipping
2024-08-29 22:06:02.246 IST [757678] LOG: statement:
DROP FOREIGN DATA WRAPPER IF EXISTS parquet_wrapper CASCADE;
2024-08-29 22:06:02.246 IST [757678] NOTICE: foreign-data wrapper "parquet_wrapper" does not exist, skipping
2024-08-29 22:06:02.246 IST [757678] LOG: statement:
DROP USER MAPPING IF EXISTS FOR public SERVER auto_sales_server;
2024-08-29 22:06:02.246 IST [757678] NOTICE: server "auto_sales_server" does not exist, skipping
2024-08-29 22:06:02.246 IST [757678] LOG: statement: CREATE FOREIGN DATA WRAPPER parquet_wrapper
HANDLER parquet_fdw_handler
VALIDATOR parquet_fdw_validator
2024-08-29 22:06:02.252 IST [757678] LOG: statement: CREATE SERVER auto_sales_server
FOREIGN DATA WRAPPER parquet_wrapper
2024-08-29 22:06:02.255 IST [757678] LOG: statement: CREATE USER MAPPING FOR public
SERVER auto_sales_server
OPTIONS (
type 'S3',
region 'us-east-1',
endpoint 'localhost:32974',
use_ssl 'false',
url_style 'path'
)
2024-08-29 22:06:02.258 IST [757678] LOG: statement:
CREATE TABLE auto_sales_partitioned (
sale_id BIGINT,
sale_date DATE,
manufacturer TEXT,
model TEXT,
price DOUBLE PRECISION,
dealership_id INT,
customer_id INT,
year INT,
month INT
)
PARTITION BY LIST (year);
2024-08-29 22:06:02.261 IST [757678] LOG: statement:
CREATE TABLE auto_sales_y2020
PARTITION OF auto_sales_partitioned
FOR VALUES IN (2020)
PARTITION BY LIST (manufacturer);
2024-08-29 22:06:02.264 IST [757678] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2020_Toyota
PARTITION OF auto_sales_y2020
FOR VALUES IN ('Toyota')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2020/Toyota/*.parquet'
);
2024-08-29 22:06:02.265 IST [757678] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2020_toyota" ***
2024-08-29 22:06:02.270 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:32974', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:06:02.271 IST [757678] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2020_toyota", "public" ***
2024-08-29 22:06:02.290 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:06:02.290 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2020_toyota AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2020/Toyota/*.parquet')" ***
2024-08-29 22:06:02.305 IST [757678] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2020_Honda
PARTITION OF auto_sales_y2020
FOR VALUES IN ('Honda')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2020/Honda/*.parquet'
);
2024-08-29 22:06:02.306 IST [757678] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2020_honda" ***
2024-08-29 22:06:02.306 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:32974', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:06:02.306 IST [757678] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2020_honda", "public" ***
2024-08-29 22:06:02.310 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:06:02.310 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2020_honda AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2020/Honda/*.parquet')" ***
2024-08-29 22:06:02.324 IST [757678] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2020_Ford
PARTITION OF auto_sales_y2020
FOR VALUES IN ('Ford')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2020/Ford/*.parquet'
);
2024-08-29 22:06:02.324 IST [757678] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2020_ford" ***
2024-08-29 22:06:02.324 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:32974', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:06:02.324 IST [757678] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2020_ford", "public" ***
2024-08-29 22:06:02.328 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:06:02.328 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2020_ford AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2020/Ford/*.parquet')" ***
2024-08-29 22:06:02.343 IST [757678] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2020_Chevrolet
PARTITION OF auto_sales_y2020
FOR VALUES IN ('Chevrolet')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2020/Chevrolet/*.parquet'
);
2024-08-29 22:06:02.343 IST [757678] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2020_chevrolet" ***
2024-08-29 22:06:02.343 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:32974', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:06:02.343 IST [757678] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2020_chevrolet", "public" ***
2024-08-29 22:06:02.347 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:06:02.347 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2020_chevrolet AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2020/Chevrolet/*.parquet')" ***
2024-08-29 22:06:02.360 IST [757678] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2020_Nissan
PARTITION OF auto_sales_y2020
FOR VALUES IN ('Nissan')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2020/Nissan/*.parquet'
);
2024-08-29 22:06:02.360 IST [757678] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2020_nissan" ***
2024-08-29 22:06:02.361 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:32974', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:06:02.361 IST [757678] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2020_nissan", "public" ***
2024-08-29 22:06:02.364 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:06:02.364 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2020_nissan AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2020/Nissan/*.parquet')" ***
2024-08-29 22:06:02.377 IST [757678] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2020_BMW
PARTITION OF auto_sales_y2020
FOR VALUES IN ('BMW')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2020/BMW/*.parquet'
);
2024-08-29 22:06:02.377 IST [757678] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2020_bmw" ***
2024-08-29 22:06:02.377 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:32974', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:06:02.377 IST [757678] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2020_bmw", "public" ***
2024-08-29 22:06:02.381 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:06:02.381 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2020_bmw AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2020/BMW/*.parquet')" ***
2024-08-29 22:06:02.393 IST [757678] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2020_Mercedes
PARTITION OF auto_sales_y2020
FOR VALUES IN ('Mercedes')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2020/Mercedes/*.parquet'
);
2024-08-29 22:06:02.394 IST [757678] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2020_mercedes" ***
2024-08-29 22:06:02.394 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:32974', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:06:02.394 IST [757678] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2020_mercedes", "public" ***
2024-08-29 22:06:02.397 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:06:02.397 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2020_mercedes AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2020/Mercedes/*.parquet')" ***
2024-08-29 22:06:02.409 IST [757678] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2020_Audi
PARTITION OF auto_sales_y2020
FOR VALUES IN ('Audi')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2020/Audi/*.parquet'
);
2024-08-29 22:06:02.409 IST [757678] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2020_audi" ***
2024-08-29 22:06:02.409 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:32974', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:06:02.409 IST [757678] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2020_audi", "public" ***
2024-08-29 22:06:02.413 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:06:02.413 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2020_audi AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2020/Audi/*.parquet')" ***
2024-08-29 22:06:02.425 IST [757678] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2020_Hyundai
PARTITION OF auto_sales_y2020
FOR VALUES IN ('Hyundai')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2020/Hyundai/*.parquet'
);
2024-08-29 22:06:02.426 IST [757678] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2020_hyundai" ***
2024-08-29 22:06:02.426 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:32974', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:06:02.426 IST [757678] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2020_hyundai", "public" ***
2024-08-29 22:06:02.429 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:06:02.429 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2020_hyundai AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2020/Hyundai/*.parquet')" ***
2024-08-29 22:06:02.444 IST [757678] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2020_Kia
PARTITION OF auto_sales_y2020
FOR VALUES IN ('Kia')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2020/Kia/*.parquet'
);
2024-08-29 22:06:02.444 IST [757678] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2020_kia" ***
2024-08-29 22:06:02.445 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:32974', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:06:02.445 IST [757678] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2020_kia", "public" ***
2024-08-29 22:06:02.448 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:06:02.448 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2020_kia AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2020/Kia/*.parquet')" ***
2024-08-29 22:06:02.461 IST [757678] LOG: statement:
CREATE TABLE auto_sales_y2021
PARTITION OF auto_sales_partitioned
FOR VALUES IN (2021)
PARTITION BY LIST (manufacturer);
2024-08-29 22:06:02.464 IST [757678] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2021_Toyota
PARTITION OF auto_sales_y2021
FOR VALUES IN ('Toyota')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2021/Toyota/*.parquet'
);
2024-08-29 22:06:02.464 IST [757678] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2021_toyota" ***
2024-08-29 22:06:02.465 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:32974', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:06:02.465 IST [757678] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2021_toyota", "public" ***
2024-08-29 22:06:02.468 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:06:02.469 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2021_toyota AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2021/Toyota/*.parquet')" ***
2024-08-29 22:06:02.481 IST [757678] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2021_Honda
PARTITION OF auto_sales_y2021
FOR VALUES IN ('Honda')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2021/Honda/*.parquet'
);
2024-08-29 22:06:02.481 IST [757678] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2021_honda" ***
2024-08-29 22:06:02.481 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:32974', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:06:02.482 IST [757678] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2021_honda", "public" ***
2024-08-29 22:06:02.485 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:06:02.485 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2021_honda AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2021/Honda/*.parquet')" ***
2024-08-29 22:06:02.498 IST [757678] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2021_Ford
PARTITION OF auto_sales_y2021
FOR VALUES IN ('Ford')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2021/Ford/*.parquet'
);
2024-08-29 22:06:02.498 IST [757678] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2021_ford" ***
2024-08-29 22:06:02.498 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:32974', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:06:02.498 IST [757678] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2021_ford", "public" ***
2024-08-29 22:06:02.501 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:06:02.502 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2021_ford AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2021/Ford/*.parquet')" ***
2024-08-29 22:06:02.513 IST [757678] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2021_Chevrolet
PARTITION OF auto_sales_y2021
FOR VALUES IN ('Chevrolet')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2021/Chevrolet/*.parquet'
);
2024-08-29 22:06:02.514 IST [757678] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2021_chevrolet" ***
2024-08-29 22:06:02.514 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:32974', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:06:02.514 IST [757678] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2021_chevrolet", "public" ***
2024-08-29 22:06:02.517 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:06:02.517 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2021_chevrolet AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2021/Chevrolet/*.parquet')" ***
2024-08-29 22:06:02.530 IST [757678] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2021_Nissan
PARTITION OF auto_sales_y2021
FOR VALUES IN ('Nissan')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2021/Nissan/*.parquet'
);
2024-08-29 22:06:02.531 IST [757678] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2021_nissan" ***
2024-08-29 22:06:02.531 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:32974', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:06:02.531 IST [757678] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2021_nissan", "public" ***
2024-08-29 22:06:02.534 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:06:02.534 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2021_nissan AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2021/Nissan/*.parquet')" ***
2024-08-29 22:06:02.549 IST [757678] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2021_BMW
PARTITION OF auto_sales_y2021
FOR VALUES IN ('BMW')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2021/BMW/*.parquet'
);
2024-08-29 22:06:02.549 IST [757678] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2021_bmw" ***
2024-08-29 22:06:02.549 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:32974', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:06:02.549 IST [757678] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2021_bmw", "public" ***
2024-08-29 22:06:02.553 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:06:02.553 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2021_bmw AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2021/BMW/*.parquet')" ***
2024-08-29 22:06:02.566 IST [757678] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2021_Mercedes
PARTITION OF auto_sales_y2021
FOR VALUES IN ('Mercedes')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2021/Mercedes/*.parquet'
);
2024-08-29 22:06:02.567 IST [757678] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2021_mercedes" ***
2024-08-29 22:06:02.567 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:32974', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:06:02.567 IST [757678] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2021_mercedes", "public" ***
2024-08-29 22:06:02.570 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:06:02.570 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2021_mercedes AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2021/Mercedes/*.parquet')" ***
2024-08-29 22:06:02.582 IST [757678] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2021_Audi
PARTITION OF auto_sales_y2021
FOR VALUES IN ('Audi')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2021/Audi/*.parquet'
);
2024-08-29 22:06:02.583 IST [757678] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2021_audi" ***
2024-08-29 22:06:02.583 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:32974', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:06:02.583 IST [757678] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2021_audi", "public" ***
2024-08-29 22:06:02.586 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:06:02.586 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2021_audi AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2021/Audi/*.parquet')" ***
2024-08-29 22:06:02.598 IST [757678] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2021_Hyundai
PARTITION OF auto_sales_y2021
FOR VALUES IN ('Hyundai')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2021/Hyundai/*.parquet'
);
2024-08-29 22:06:02.599 IST [757678] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2021_hyundai" ***
2024-08-29 22:06:02.599 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:32974', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:06:02.599 IST [757678] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2021_hyundai", "public" ***
2024-08-29 22:06:02.602 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:06:02.602 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2021_hyundai AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2021/Hyundai/*.parquet')" ***
2024-08-29 22:06:02.615 IST [757678] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2021_Kia
PARTITION OF auto_sales_y2021
FOR VALUES IN ('Kia')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2021/Kia/*.parquet'
);
2024-08-29 22:06:02.615 IST [757678] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2021_kia" ***
2024-08-29 22:06:02.615 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:32974', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:06:02.615 IST [757678] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2021_kia", "public" ***
2024-08-29 22:06:02.619 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:06:02.619 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2021_kia AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2021/Kia/*.parquet')" ***
2024-08-29 22:06:02.634 IST [757678] LOG: statement:
CREATE TABLE auto_sales_y2022
PARTITION OF auto_sales_partitioned
FOR VALUES IN (2022)
PARTITION BY LIST (manufacturer);
2024-08-29 22:06:02.637 IST [757678] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2022_Toyota
PARTITION OF auto_sales_y2022
FOR VALUES IN ('Toyota')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2022/Toyota/*.parquet'
);
2024-08-29 22:06:02.638 IST [757678] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2022_toyota" ***
2024-08-29 22:06:02.638 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:32974', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:06:02.638 IST [757678] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2022_toyota", "public" ***
2024-08-29 22:06:02.641 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:06:02.641 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2022_toyota AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2022/Toyota/*.parquet')" ***
2024-08-29 22:06:02.656 IST [757678] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2022_Honda
PARTITION OF auto_sales_y2022
FOR VALUES IN ('Honda')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2022/Honda/*.parquet'
);
2024-08-29 22:06:02.657 IST [757678] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2022_honda" ***
2024-08-29 22:06:02.657 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:32974', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:06:02.657 IST [757678] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2022_honda", "public" ***
2024-08-29 22:06:02.661 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:06:02.661 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2022_honda AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2022/Honda/*.parquet')" ***
2024-08-29 22:06:02.676 IST [757678] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2022_Ford
PARTITION OF auto_sales_y2022
FOR VALUES IN ('Ford')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2022/Ford/*.parquet'
);
2024-08-29 22:06:02.677 IST [757678] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2022_ford" ***
2024-08-29 22:06:02.677 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:32974', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:06:02.678 IST [757678] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2022_ford", "public" ***
2024-08-29 22:06:02.681 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:06:02.682 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2022_ford AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2022/Ford/*.parquet')" ***
2024-08-29 22:06:02.697 IST [757678] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2022_Chevrolet
PARTITION OF auto_sales_y2022
FOR VALUES IN ('Chevrolet')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2022/Chevrolet/*.parquet'
);
2024-08-29 22:06:02.698 IST [757678] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2022_chevrolet" ***
2024-08-29 22:06:02.699 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:32974', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:06:02.699 IST [757678] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2022_chevrolet", "public" ***
2024-08-29 22:06:02.704 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:06:02.704 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2022_chevrolet AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2022/Chevrolet/*.parquet')" ***
2024-08-29 22:06:02.720 IST [757678] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2022_Nissan
PARTITION OF auto_sales_y2022
FOR VALUES IN ('Nissan')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2022/Nissan/*.parquet'
);
2024-08-29 22:06:02.721 IST [757678] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2022_nissan" ***
2024-08-29 22:06:02.721 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:32974', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:06:02.721 IST [757678] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2022_nissan", "public" ***
2024-08-29 22:06:02.725 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:06:02.726 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2022_nissan AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2022/Nissan/*.parquet')" ***
2024-08-29 22:06:02.742 IST [757678] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2022_BMW
PARTITION OF auto_sales_y2022
FOR VALUES IN ('BMW')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2022/BMW/*.parquet'
);
2024-08-29 22:06:02.743 IST [757678] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2022_bmw" ***
2024-08-29 22:06:02.743 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:32974', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:06:02.744 IST [757678] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2022_bmw", "public" ***
2024-08-29 22:06:02.748 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:06:02.749 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2022_bmw AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2022/BMW/*.parquet')" ***
2024-08-29 22:06:02.762 IST [757678] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2022_Mercedes
PARTITION OF auto_sales_y2022
FOR VALUES IN ('Mercedes')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2022/Mercedes/*.parquet'
);
2024-08-29 22:06:02.763 IST [757678] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2022_mercedes" ***
2024-08-29 22:06:02.763 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:32974', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:06:02.764 IST [757678] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2022_mercedes", "public" ***
2024-08-29 22:06:02.767 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:06:02.768 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2022_mercedes AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2022/Mercedes/*.parquet')" ***
2024-08-29 22:06:02.780 IST [757678] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2022_Audi
PARTITION OF auto_sales_y2022
FOR VALUES IN ('Audi')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2022/Audi/*.parquet'
);
2024-08-29 22:06:02.781 IST [757678] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2022_audi" ***
2024-08-29 22:06:02.782 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:32974', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:06:02.782 IST [757678] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2022_audi", "public" ***
2024-08-29 22:06:02.789 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:06:02.789 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2022_audi AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2022/Audi/*.parquet')" ***
2024-08-29 22:06:02.807 IST [757678] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2022_Hyundai
PARTITION OF auto_sales_y2022
FOR VALUES IN ('Hyundai')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2022/Hyundai/*.parquet'
);
2024-08-29 22:06:02.808 IST [757678] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2022_hyundai" ***
2024-08-29 22:06:02.808 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:32974', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:06:02.809 IST [757678] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2022_hyundai", "public" ***
2024-08-29 22:06:02.813 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:06:02.814 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2022_hyundai AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2022/Hyundai/*.parquet')" ***
2024-08-29 22:06:02.832 IST [757678] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2022_Kia
PARTITION OF auto_sales_y2022
FOR VALUES IN ('Kia')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2022/Kia/*.parquet'
);
2024-08-29 22:06:02.832 IST [757678] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2022_kia" ***
2024-08-29 22:06:02.832 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:32974', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:06:02.833 IST [757678] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2022_kia", "public" ***
2024-08-29 22:06:02.838 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:06:02.838 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2022_kia AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2022/Kia/*.parquet')" ***
2024-08-29 22:06:02.853 IST [757678] LOG: statement:
CREATE TABLE auto_sales_y2023
PARTITION OF auto_sales_partitioned
FOR VALUES IN (2023)
PARTITION BY LIST (manufacturer);
2024-08-29 22:06:02.856 IST [757678] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2023_Toyota
PARTITION OF auto_sales_y2023
FOR VALUES IN ('Toyota')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2023/Toyota/*.parquet'
);
2024-08-29 22:06:02.856 IST [757678] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2023_toyota" ***
2024-08-29 22:06:02.857 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:32974', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:06:02.857 IST [757678] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2023_toyota", "public" ***
2024-08-29 22:06:02.860 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:06:02.861 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2023_toyota AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2023/Toyota/*.parquet')" ***
2024-08-29 22:06:02.875 IST [757678] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2023_Honda
PARTITION OF auto_sales_y2023
FOR VALUES IN ('Honda')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2023/Honda/*.parquet'
);
2024-08-29 22:06:02.876 IST [757678] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2023_honda" ***
2024-08-29 22:06:02.876 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:32974', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:06:02.876 IST [757678] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2023_honda", "public" ***
2024-08-29 22:06:02.880 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:06:02.880 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2023_honda AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2023/Honda/*.parquet')" ***
2024-08-29 22:06:02.896 IST [757678] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2023_Ford
PARTITION OF auto_sales_y2023
FOR VALUES IN ('Ford')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2023/Ford/*.parquet'
);
2024-08-29 22:06:02.897 IST [757678] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2023_ford" ***
2024-08-29 22:06:02.897 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:32974', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:06:02.897 IST [757678] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2023_ford", "public" ***
2024-08-29 22:06:02.903 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:06:02.904 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2023_ford AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2023/Ford/*.parquet')" ***
2024-08-29 22:06:02.919 IST [757678] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2023_Chevrolet
PARTITION OF auto_sales_y2023
FOR VALUES IN ('Chevrolet')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2023/Chevrolet/*.parquet'
);
2024-08-29 22:06:02.919 IST [757678] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2023_chevrolet" ***
2024-08-29 22:06:02.919 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:32974', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:06:02.919 IST [757678] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2023_chevrolet", "public" ***
2024-08-29 22:06:02.923 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:06:02.923 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2023_chevrolet AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2023/Chevrolet/*.parquet')" ***
2024-08-29 22:06:02.936 IST [757678] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2023_Nissan
PARTITION OF auto_sales_y2023
FOR VALUES IN ('Nissan')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2023/Nissan/*.parquet'
);
2024-08-29 22:06:02.936 IST [757678] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2023_nissan" ***
2024-08-29 22:06:02.936 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:32974', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:06:02.937 IST [757678] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2023_nissan", "public" ***
2024-08-29 22:06:02.942 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:06:02.942 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2023_nissan AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2023/Nissan/*.parquet')" ***
2024-08-29 22:06:02.956 IST [757678] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2023_BMW
PARTITION OF auto_sales_y2023
FOR VALUES IN ('BMW')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2023/BMW/*.parquet'
);
2024-08-29 22:06:02.956 IST [757678] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2023_bmw" ***
2024-08-29 22:06:02.956 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:32974', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:06:02.956 IST [757678] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2023_bmw", "public" ***
2024-08-29 22:06:02.961 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:06:02.961 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2023_bmw AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2023/BMW/*.parquet')" ***
2024-08-29 22:06:02.976 IST [757678] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2023_Mercedes
PARTITION OF auto_sales_y2023
FOR VALUES IN ('Mercedes')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2023/Mercedes/*.parquet'
);
2024-08-29 22:06:02.977 IST [757678] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2023_mercedes" ***
2024-08-29 22:06:02.977 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:32974', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:06:02.977 IST [757678] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2023_mercedes", "public" ***
2024-08-29 22:06:02.981 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:06:02.981 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2023_mercedes AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2023/Mercedes/*.parquet')" ***
2024-08-29 22:06:02.994 IST [757678] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2023_Audi
PARTITION OF auto_sales_y2023
FOR VALUES IN ('Audi')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2023/Audi/*.parquet'
);
2024-08-29 22:06:02.994 IST [757678] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2023_audi" ***
2024-08-29 22:06:02.994 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:32974', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:06:02.995 IST [757678] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2023_audi", "public" ***
2024-08-29 22:06:02.998 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:06:02.998 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2023_audi AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2023/Audi/*.parquet')" ***
2024-08-29 22:06:03.011 IST [757678] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2023_Hyundai
PARTITION OF auto_sales_y2023
FOR VALUES IN ('Hyundai')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2023/Hyundai/*.parquet'
);
2024-08-29 22:06:03.011 IST [757678] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2023_hyundai" ***
2024-08-29 22:06:03.012 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:32974', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:06:03.012 IST [757678] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2023_hyundai", "public" ***
2024-08-29 22:06:03.016 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:06:03.016 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2023_hyundai AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2023/Hyundai/*.parquet')" ***
2024-08-29 22:06:03.029 IST [757678] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2023_Kia
PARTITION OF auto_sales_y2023
FOR VALUES IN ('Kia')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2023/Kia/*.parquet'
);
2024-08-29 22:06:03.030 IST [757678] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2023_kia" ***
2024-08-29 22:06:03.030 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:32974', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:06:03.030 IST [757678] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2023_kia", "public" ***
2024-08-29 22:06:03.034 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:06:03.034 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2023_kia AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2023/Kia/*.parquet')" ***
2024-08-29 22:06:03.049 IST [757678] LOG: statement:
CREATE TABLE auto_sales_y2024
PARTITION OF auto_sales_partitioned
FOR VALUES IN (2024)
PARTITION BY LIST (manufacturer);
2024-08-29 22:06:03.053 IST [757678] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2024_Toyota
PARTITION OF auto_sales_y2024
FOR VALUES IN ('Toyota')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2024/Toyota/*.parquet'
);
2024-08-29 22:06:03.053 IST [757678] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2024_toyota" ***
2024-08-29 22:06:03.053 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:32974', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:06:03.053 IST [757678] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2024_toyota", "public" ***
2024-08-29 22:06:03.057 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:06:03.057 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2024_toyota AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2024/Toyota/*.parquet')" ***
2024-08-29 22:06:03.071 IST [757678] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2024_Honda
PARTITION OF auto_sales_y2024
FOR VALUES IN ('Honda')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2024/Honda/*.parquet'
);
2024-08-29 22:06:03.071 IST [757678] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2024_honda" ***
2024-08-29 22:06:03.071 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:32974', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:06:03.071 IST [757678] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2024_honda", "public" ***
2024-08-29 22:06:03.075 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:06:03.075 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2024_honda AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2024/Honda/*.parquet')" ***
2024-08-29 22:06:03.089 IST [757678] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2024_Ford
PARTITION OF auto_sales_y2024
FOR VALUES IN ('Ford')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2024/Ford/*.parquet'
);
2024-08-29 22:06:03.089 IST [757678] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2024_ford" ***
2024-08-29 22:06:03.090 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:32974', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:06:03.090 IST [757678] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2024_ford", "public" ***
2024-08-29 22:06:03.094 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:06:03.094 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2024_ford AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2024/Ford/*.parquet')" ***
2024-08-29 22:06:03.108 IST [757678] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2024_Chevrolet
PARTITION OF auto_sales_y2024
FOR VALUES IN ('Chevrolet')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2024/Chevrolet/*.parquet'
);
2024-08-29 22:06:03.108 IST [757678] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2024_chevrolet" ***
2024-08-29 22:06:03.108 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:32974', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:06:03.108 IST [757678] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2024_chevrolet", "public" ***
2024-08-29 22:06:03.112 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:06:03.112 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2024_chevrolet AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2024/Chevrolet/*.parquet')" ***
2024-08-29 22:06:03.124 IST [757678] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2024_Nissan
PARTITION OF auto_sales_y2024
FOR VALUES IN ('Nissan')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2024/Nissan/*.parquet'
);
2024-08-29 22:06:03.125 IST [757678] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2024_nissan" ***
2024-08-29 22:06:03.125 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:32974', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:06:03.125 IST [757678] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2024_nissan", "public" ***
2024-08-29 22:06:03.129 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:06:03.130 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2024_nissan AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2024/Nissan/*.parquet')" ***
2024-08-29 22:06:03.141 IST [757678] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2024_BMW
PARTITION OF auto_sales_y2024
FOR VALUES IN ('BMW')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2024/BMW/*.parquet'
);
2024-08-29 22:06:03.141 IST [757678] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2024_bmw" ***
2024-08-29 22:06:03.142 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:32974', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:06:03.142 IST [757678] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2024_bmw", "public" ***
2024-08-29 22:06:03.145 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:06:03.145 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2024_bmw AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2024/BMW/*.parquet')" ***
2024-08-29 22:06:03.157 IST [757678] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2024_Mercedes
PARTITION OF auto_sales_y2024
FOR VALUES IN ('Mercedes')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2024/Mercedes/*.parquet'
);
2024-08-29 22:06:03.158 IST [757678] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2024_mercedes" ***
2024-08-29 22:06:03.158 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:32974', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:06:03.158 IST [757678] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2024_mercedes", "public" ***
2024-08-29 22:06:03.161 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:06:03.161 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2024_mercedes AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2024/Mercedes/*.parquet')" ***
2024-08-29 22:06:03.173 IST [757678] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2024_Audi
PARTITION OF auto_sales_y2024
FOR VALUES IN ('Audi')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2024/Audi/*.parquet'
);
2024-08-29 22:06:03.173 IST [757678] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2024_audi" ***
2024-08-29 22:06:03.174 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:32974', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:06:03.174 IST [757678] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2024_audi", "public" ***
2024-08-29 22:06:03.177 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:06:03.177 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2024_audi AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2024/Audi/*.parquet')" ***
2024-08-29 22:06:03.191 IST [757678] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2024_Hyundai
PARTITION OF auto_sales_y2024
FOR VALUES IN ('Hyundai')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2024/Hyundai/*.parquet'
);
2024-08-29 22:06:03.192 IST [757678] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2024_hyundai" ***
2024-08-29 22:06:03.193 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:32974', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:06:03.193 IST [757678] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2024_hyundai", "public" ***
2024-08-29 22:06:03.201 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:06:03.201 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2024_hyundai AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2024/Hyundai/*.parquet')" ***
2024-08-29 22:06:03.214 IST [757678] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2024_Kia
PARTITION OF auto_sales_y2024
FOR VALUES IN ('Kia')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2024/Kia/*.parquet'
);
2024-08-29 22:06:03.215 IST [757678] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2024_kia" ***
2024-08-29 22:06:03.215 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:32974', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:06:03.215 IST [757678] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2024_kia", "public" ***
2024-08-29 22:06:03.222 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:06:03.222 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2024_kia AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2024/Kia/*.parquet')" ***
2024-08-29 22:06:03.237 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:32974', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:06:03.237 IST [757678] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2024_toyota", "public" ***
2024-08-29 22:06:03.243 IST [757678] LOG: execute sqlx_s_2:
SELECT year, month, COUNT(*) as sales_count,
array_agg(sale_id) as sale_ids
FROM auto_sales_partitioned
WHERE manufacturer = 'Toyota' AND year = 2024
GROUP BY year, month
ORDER BY month;
2024-08-29 22:06:03.243 IST [757678] WARNING: pga:: *** executor_run() X ***
2024-08-29 22:06:03.243 IST [757678] WARNING: pga:: *** ExtensionHook::executor_run() X ***
2024-08-29 22:06:03.243 IST [757678] WARNING: pga:: *** get_current_query() X ***
2024-08-29 22:06:03.243 IST [757678] WARNING: pga:: *** get_current_query() "\n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_partitioned\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:06:03.243 IST [757678] WARNING: pga:: *** get_query_relations() X ***
2024-08-29 22:06:03.243 IST [757678] WARNING: pga:: *** get_query_relations() 3 ***
2024-08-29 22:06:03.243 IST [757678] WARNING: query_relations.is_empty() :: false
2024-08-29 22:06:03.244 IST [757678] WARNING: pga:: *** duckdb::execute() "SET search_path TO 'public'" ***
2024-08-29 22:06:03.245 IST [757678] WARNING: pga:: *** executor_run() X ***
2024-08-29 22:06:03.245 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209470"
2024-08-29 22:06:03.245 IST [757678] WARNING: pga:: *** ExtensionHook::executor_run() X ***
2024-08-29 22:06:03.245 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209470"
2024-08-29 22:06:03.245 IST [757678] WARNING: pga:: *** get_current_query() X ***
2024-08-29 22:06:03.245 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209470"
2024-08-29 22:06:03.245 IST [757678] WARNING: pga:: *** get_current_query() "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209470" ***
2024-08-29 22:06:03.245 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209470"
2024-08-29 22:06:03.245 IST [757678] WARNING: pga:: *** get_query_relations() X ***
2024-08-29 22:06:03.245 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209470"
2024-08-29 22:06:03.245 IST [757678] WARNING: pga:: *** get_query_relations() 1 ***
2024-08-29 22:06:03.245 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209470"
2024-08-29 22:06:03.245 IST [757678] WARNING: query_relations.is_empty() :: false
2024-08-29 22:06:03.245 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209470"
2024-08-29 22:06:03.245 IST [757678] WARNING: pga:: *** ExtensionHook::executor_run() Y Stg-01 ***
2024-08-29 22:06:03.245 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209470"
2024-08-29 22:06:03.245 IST [757678] WARNING: pga:: *** executor_run() Y ***
2024-08-29 22:06:03.245 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209470"
2024-08-29 22:06:03.245 IST [757678] WARNING: pga:: *** executor_run() X ***
2024-08-29 22:06:03.245 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209473"
2024-08-29 22:06:03.245 IST [757678] WARNING: pga:: *** ExtensionHook::executor_run() X ***
2024-08-29 22:06:03.245 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209473"
2024-08-29 22:06:03.245 IST [757678] WARNING: pga:: *** get_current_query() X ***
2024-08-29 22:06:03.245 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209473"
2024-08-29 22:06:03.245 IST [757678] WARNING: pga:: *** get_current_query() "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209473" ***
2024-08-29 22:06:03.245 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209473"
2024-08-29 22:06:03.245 IST [757678] WARNING: pga:: *** get_query_relations() X ***
2024-08-29 22:06:03.245 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209473"
2024-08-29 22:06:03.245 IST [757678] WARNING: pga:: *** get_query_relations() 1 ***
2024-08-29 22:06:03.245 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209473"
2024-08-29 22:06:03.245 IST [757678] WARNING: query_relations.is_empty() :: false
2024-08-29 22:06:03.245 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209473"
2024-08-29 22:06:03.245 IST [757678] WARNING: pga:: *** ExtensionHook::executor_run() Y Stg-01 ***
2024-08-29 22:06:03.245 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209473"
2024-08-29 22:06:03.245 IST [757678] WARNING: pga:: *** executor_run() Y ***
2024-08-29 22:06:03.245 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209473"
2024-08-29 22:06:03.246 IST [757678] WARNING: pga:: *** executor_run() X ***
2024-08-29 22:06:03.246 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209506"
2024-08-29 22:06:03.246 IST [757678] WARNING: pga:: *** ExtensionHook::executor_run() X ***
2024-08-29 22:06:03.246 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209506"
2024-08-29 22:06:03.246 IST [757678] WARNING: pga:: *** get_current_query() X ***
2024-08-29 22:06:03.246 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209506"
2024-08-29 22:06:03.246 IST [757678] WARNING: pga:: *** get_current_query() "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209506" ***
2024-08-29 22:06:03.246 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209506"
2024-08-29 22:06:03.246 IST [757678] WARNING: pga:: *** get_query_relations() X ***
2024-08-29 22:06:03.246 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209506"
2024-08-29 22:06:03.246 IST [757678] WARNING: pga:: *** get_query_relations() 1 ***
2024-08-29 22:06:03.246 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209506"
2024-08-29 22:06:03.246 IST [757678] WARNING: query_relations.is_empty() :: false
2024-08-29 22:06:03.246 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209506"
2024-08-29 22:06:03.246 IST [757678] WARNING: pga:: *** ExtensionHook::executor_run() Y Stg-01 ***
2024-08-29 22:06:03.246 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209506"
2024-08-29 22:06:03.246 IST [757678] WARNING: pga:: *** executor_run() Y ***
2024-08-29 22:06:03.246 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209506"
2024-08-29 22:06:03.246 IST [757678] WARNING: pga:: *** executor_run() X ***
2024-08-29 22:06:03.246 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209539"
2024-08-29 22:06:03.246 IST [757678] WARNING: pga:: *** ExtensionHook::executor_run() X ***
2024-08-29 22:06:03.246 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209539"
2024-08-29 22:06:03.246 IST [757678] WARNING: pga:: *** get_current_query() X ***
2024-08-29 22:06:03.246 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209539"
2024-08-29 22:06:03.246 IST [757678] WARNING: pga:: *** get_current_query() "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209539" ***
2024-08-29 22:06:03.246 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209539"
2024-08-29 22:06:03.246 IST [757678] WARNING: pga:: *** get_query_relations() X ***
2024-08-29 22:06:03.246 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209539"
2024-08-29 22:06:03.246 IST [757678] WARNING: pga:: *** get_query_relations() 1 ***
2024-08-29 22:06:03.246 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209539"
2024-08-29 22:06:03.246 IST [757678] WARNING: query_relations.is_empty() :: false
2024-08-29 22:06:03.246 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209539"
2024-08-29 22:06:03.246 IST [757678] WARNING: pga:: *** ExtensionHook::executor_run() Y Stg-01 ***
2024-08-29 22:06:03.246 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209539"
2024-08-29 22:06:03.246 IST [757678] WARNING: pga:: *** executor_run() Y ***
2024-08-29 22:06:03.246 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209539"
2024-08-29 22:06:03.246 IST [757678] WARNING: pga:: *** executor_run() X ***
2024-08-29 22:06:03.246 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209572"
2024-08-29 22:06:03.246 IST [757678] WARNING: pga:: *** ExtensionHook::executor_run() X ***
2024-08-29 22:06:03.246 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209572"
2024-08-29 22:06:03.246 IST [757678] WARNING: pga:: *** get_current_query() X ***
2024-08-29 22:06:03.246 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209572"
2024-08-29 22:06:03.246 IST [757678] WARNING: pga:: *** get_current_query() "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209572" ***
2024-08-29 22:06:03.246 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209572"
2024-08-29 22:06:03.246 IST [757678] WARNING: pga:: *** get_query_relations() X ***
2024-08-29 22:06:03.246 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209572"
2024-08-29 22:06:03.246 IST [757678] WARNING: pga:: *** get_query_relations() 1 ***
2024-08-29 22:06:03.246 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209572"
2024-08-29 22:06:03.246 IST [757678] WARNING: query_relations.is_empty() :: false
2024-08-29 22:06:03.246 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209572"
2024-08-29 22:06:03.246 IST [757678] WARNING: pga:: *** ExtensionHook::executor_run() Y Stg-01 ***
2024-08-29 22:06:03.246 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209572"
2024-08-29 22:06:03.246 IST [757678] WARNING: pga:: *** executor_run() Y ***
2024-08-29 22:06:03.246 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209572"
2024-08-29 22:06:03.246 IST [757678] WARNING: pga:: *** executor_run() X ***
2024-08-29 22:06:03.246 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209605"
2024-08-29 22:06:03.246 IST [757678] WARNING: pga:: *** ExtensionHook::executor_run() X ***
2024-08-29 22:06:03.246 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209605"
2024-08-29 22:06:03.246 IST [757678] WARNING: pga:: *** get_current_query() X ***
2024-08-29 22:06:03.246 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209605"
2024-08-29 22:06:03.246 IST [757678] WARNING: pga:: *** get_current_query() "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209605" ***
2024-08-29 22:06:03.246 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209605"
2024-08-29 22:06:03.246 IST [757678] WARNING: pga:: *** get_query_relations() X ***
2024-08-29 22:06:03.246 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209605"
2024-08-29 22:06:03.246 IST [757678] WARNING: pga:: *** get_query_relations() 1 ***
2024-08-29 22:06:03.246 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209605"
2024-08-29 22:06:03.246 IST [757678] WARNING: query_relations.is_empty() :: false
2024-08-29 22:06:03.246 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209605"
2024-08-29 22:06:03.247 IST [757678] WARNING: pga:: *** ExtensionHook::executor_run() Y Stg-01 ***
2024-08-29 22:06:03.247 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209605"
2024-08-29 22:06:03.247 IST [757678] WARNING: pga:: *** executor_run() Y ***
2024-08-29 22:06:03.247 IST [757678] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209605"
2024-08-29 22:06:03.247 IST [757678] WARNING: pga:: optimize_transformed_queries X
2024-08-29 22:06:03.247 IST [757678] WARNING: pga:: optimize_transformed_queries keys :: {
"toyota",
"2024",
}
2024-08-29 22:06:03.248 IST [757678] WARNING: pga:: optimize_transformed_queries
2024-08-29 22:06:03.248 IST [757678] WARNING: pga:: 0 => "\n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2024_toyota\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month"
2024-08-29 22:06:03.248 IST [757678] WARNING: pga:: transformed_queries :: 50
optimized_transformed_queries :: 1
2024-08-29 22:06:03.248 IST [757678] WARNING: pga:: *** duckdb::execute() "CREATE TEMPORARY TABLE temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd AS SELECT * FROM (\n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2020_toyota\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month) WHERE 1=0" ***
2024-08-29 22:06:03.258 IST [757678] WARNING: pga:: *** duckdb::execute() "INSERT INTO temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd \n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2020_toyota\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:06:03.274 IST [757678] WARNING: pga:: *** duckdb::execute() "INSERT INTO temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd \n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2020_honda\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:06:03.286 IST [757678] WARNING: pga:: *** duckdb::execute() "INSERT INTO temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd \n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2020_ford\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:06:03.298 IST [757678] WARNING: pga:: *** duckdb::execute() "INSERT INTO temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd \n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2020_chevrolet\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:06:03.306 IST [757678] WARNING: pga:: *** duckdb::execute() "INSERT INTO temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd \n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2020_nissan\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:06:03.315 IST [757678] WARNING: pga:: *** duckdb::execute() "INSERT INTO temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd \n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2020_bmw\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:06:03.323 IST [757678] WARNING: pga:: *** duckdb::execute() "INSERT INTO temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd \n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2020_mercedes\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:06:03.333 IST [757678] WARNING: pga:: *** duckdb::execute() "INSERT INTO temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd \n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2020_audi\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:06:03.342 IST [757678] WARNING: pga:: *** duckdb::execute() "INSERT INTO temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd \n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2020_hyundai\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:06:03.351 IST [757678] WARNING: pga:: *** duckdb::execute() "INSERT INTO temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd \n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2020_kia\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:06:03.360 IST [757678] WARNING: pga:: *** duckdb::execute() "INSERT INTO temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd \n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2021_toyota\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:06:03.369 IST [757678] WARNING: pga:: *** duckdb::execute() "INSERT INTO temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd \n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2021_honda\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:06:03.378 IST [757678] WARNING: pga:: *** duckdb::execute() "INSERT INTO temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd \n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2021_ford\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:06:03.386 IST [757678] WARNING: pga:: *** duckdb::execute() "INSERT INTO temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd \n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2021_chevrolet\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:06:03.395 IST [757678] WARNING: pga:: *** duckdb::execute() "INSERT INTO temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd \n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2021_nissan\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:06:03.403 IST [757678] WARNING: pga:: *** duckdb::execute() "INSERT INTO temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd \n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2021_bmw\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:06:03.412 IST [757678] WARNING: pga:: *** duckdb::execute() "INSERT INTO temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd \n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2021_mercedes\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:06:03.422 IST [757678] WARNING: pga:: *** duckdb::execute() "INSERT INTO temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd \n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2021_audi\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:06:03.431 IST [757678] WARNING: pga:: *** duckdb::execute() "INSERT INTO temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd \n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2021_hyundai\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:06:03.440 IST [757678] WARNING: pga:: *** duckdb::execute() "INSERT INTO temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd \n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2021_kia\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:06:03.448 IST [757678] WARNING: pga:: *** duckdb::execute() "INSERT INTO temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd \n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2022_toyota\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:06:03.456 IST [757678] WARNING: pga:: *** duckdb::execute() "INSERT INTO temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd \n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2022_honda\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:06:03.464 IST [757678] WARNING: pga:: *** duckdb::execute() "INSERT INTO temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd \n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2022_ford\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:06:03.473 IST [757678] WARNING: pga:: *** duckdb::execute() "INSERT INTO temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd \n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2022_chevrolet\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:06:03.482 IST [757678] WARNING: pga:: *** duckdb::execute() "INSERT INTO temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd \n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2022_nissan\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:06:03.492 IST [757678] WARNING: pga:: *** duckdb::execute() "INSERT INTO temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd \n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2022_bmw\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:06:03.502 IST [757678] WARNING: pga:: *** duckdb::execute() "INSERT INTO temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd \n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2022_mercedes\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:06:03.512 IST [757678] WARNING: pga:: *** duckdb::execute() "INSERT INTO temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd \n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2022_audi\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:06:03.522 IST [757678] WARNING: pga:: *** duckdb::execute() "INSERT INTO temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd \n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2022_hyundai\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:06:03.531 IST [757678] WARNING: pga:: *** duckdb::execute() "INSERT INTO temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd \n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2022_kia\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:06:03.540 IST [757678] WARNING: pga:: *** duckdb::execute() "INSERT INTO temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd \n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2023_toyota\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:06:03.548 IST [757678] WARNING: pga:: *** duckdb::execute() "INSERT INTO temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd \n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2023_honda\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:06:03.556 IST [757678] WARNING: pga:: *** duckdb::execute() "INSERT INTO temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd \n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2023_ford\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:06:03.565 IST [757678] WARNING: pga:: *** duckdb::execute() "INSERT INTO temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd \n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2023_chevrolet\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:06:03.576 IST [757678] WARNING: pga:: *** duckdb::execute() "INSERT INTO temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd \n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2023_nissan\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:06:03.586 IST [757678] WARNING: pga:: *** duckdb::execute() "INSERT INTO temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd \n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2023_bmw\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:06:03.595 IST [757678] WARNING: pga:: *** duckdb::execute() "INSERT INTO temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd \n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2023_mercedes\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:06:03.604 IST [757678] WARNING: pga:: *** duckdb::execute() "INSERT INTO temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd \n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2023_audi\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:06:03.613 IST [757678] WARNING: pga:: *** duckdb::execute() "INSERT INTO temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd \n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2023_hyundai\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:06:03.622 IST [757678] WARNING: pga:: *** duckdb::execute() "INSERT INTO temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd \n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2023_kia\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:06:03.632 IST [757678] WARNING: pga:: *** duckdb::execute() "INSERT INTO temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd \n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2024_toyota\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:06:03.648 IST [757678] WARNING: pga:: *** duckdb::execute() "INSERT INTO temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd \n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2024_honda\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:06:03.658 IST [757678] WARNING: pga:: *** duckdb::execute() "INSERT INTO temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd \n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2024_ford\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:06:03.667 IST [757678] WARNING: pga:: *** duckdb::execute() "INSERT INTO temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd \n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2024_chevrolet\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:06:03.677 IST [757678] WARNING: pga:: *** duckdb::execute() "INSERT INTO temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd \n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2024_nissan\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:06:03.687 IST [757678] WARNING: pga:: *** duckdb::execute() "INSERT INTO temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd \n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2024_bmw\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:06:03.695 IST [757678] WARNING: pga:: *** duckdb::execute() "INSERT INTO temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd \n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2024_mercedes\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:06:03.703 IST [757678] WARNING: pga:: *** duckdb::execute() "INSERT INTO temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd \n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2024_audi\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:06:03.712 IST [757678] WARNING: pga:: *** duckdb::execute() "INSERT INTO temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd \n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2024_hyundai\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:06:03.721 IST [757678] WARNING: pga:: *** duckdb::execute() "INSERT INTO temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd \n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2024_kia\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:06:03.740 IST [757678] WARNING: pga:: *** duckdb::create_arrow() "SELECT year, month, sales_count, sale_ids FROM temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd ORDER BY month" ***
2024-08-29 22:06:03.740 IST [757678] WARNING: pga:: *** duckdb::create_arrow() Y ***
2024-08-29 22:06:03.740 IST [757678] WARNING: pga:: *** ExtensionHook::write_batches_to_slots() X 1 ***
2024-08-29 22:06:03.740 IST [757678] WARNING: pga:: *** ExtensionHook::write_batches_to_slots() Y ***
2024-08-29 22:06:03.740 IST [757678] WARNING: pga:: *** duckdb::execute() "DROP TABLE IF EXISTS temp_result_cache_5eaa1c9c_05be_44b3_9716_89ac9a5152cd" ***
2024-08-29 22:06:03.741 IST [757678] WARNING: pga:: *** ExtensionHook::executor_run() Y ***
2024-08-29 22:06:03.741 IST [757678] WARNING: pga:: *** executor_run() Y ***
2024-08-29 22:06:36.899 IST [754139] LOG: received fast shutdown request
2024-08-29 22:06:36.906 IST [754139] LOG: aborting any active transactions
2024-08-29 22:06:36.910 IST [754139] LOG: background worker "logical replication launcher" (PID 754148) exited with exit code 1
2024-08-29 22:06:36.947 IST [754140] LOG: shutting down
2024-08-29 22:06:36.952 IST [754140] LOG: checkpoint starting: shutdown immediate
2024-08-29 22:06:37.041 IST [754140] LOG: checkpoint complete: wrote 984 buffers (6.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.033 s, sync=0.026 s, total=0.095 s; sync files=304, longest=0.010 s, average=0.001 s; distance=4833 kB, estimate=4833 kB; lsn=0/920A37F0, redo lsn=0/920A37F0
2024-08-29 22:06:37.052 IST [754139] LOG: database system is shut down
2024-08-29 22:07:13.179 IST [767186] WARNING: pga:: extension is being initialized
2024-08-29 22:07:13.192 IST [767186] LOG: starting PostgreSQL 16.4 (Ubuntu 16.4-1.pgdg22.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 11.4.0-1ubuntu1~22.04) 11.4.0, 64-bit
2024-08-29 22:07:13.192 IST [767186] LOG: listening on IPv4 address "0.0.0.0", port 28816
2024-08-29 22:07:13.192 IST [767186] LOG: listening on IPv6 address "::", port 28816
2024-08-29 22:07:13.203 IST [767186] LOG: listening on Unix socket "/home/popoyi/.pgrx/.s.PGSQL.28816"
2024-08-29 22:07:13.217 IST [767189] LOG: database system was shut down at 2024-08-29 22:06:37 IST
2024-08-29 22:07:13.229 IST [767192] LOG: PARADEDB_TELEMETRY var not set at compile time for pg_search
2024-08-29 22:07:13.229 IST [767193] LOG: starting pg_search shutdown worker at PID 767193
2024-08-29 22:07:13.229 IST [767186] LOG: database system is ready to accept connections
2024-08-29 22:07:13.230 IST [767194] LOG: starting pg_search insert worker at PID 767194
2024-08-29 22:07:21.615 IST [768087] LOG: statement:
lock table pg_catalog.pg_namespace in share row exclusive mode;
create schema if not exists _sqlx_test;
create table if not exists _sqlx_test.databases (
db_name text primary key,
test_path text not null,
created_at timestamptz not null default now()
);
create index if not exists databases_created_at
on _sqlx_test.databases(created_at);
create sequence if not exists _sqlx_test.database_ids;
2024-08-29 22:07:21.616 IST [768087] NOTICE: schema "_sqlx_test" already exists, skipping
2024-08-29 22:07:21.616 IST [768087] NOTICE: relation "databases" already exists, skipping
2024-08-29 22:07:21.616 IST [768087] NOTICE: relation "databases_created_at" already exists, skipping
2024-08-29 22:07:21.616 IST [768087] NOTICE: relation "database_ids" already exists, skipping
2024-08-29 22:07:21.617 IST [768087] LOG: execute sqlx_s_1: select db_name from _sqlx_test.databases where created_at < (to_timestamp($1) at time zone 'UTC')
2024-08-29 22:07:21.617 IST [768087] DETAIL: parameters: $1 = '1724949439'
2024-08-29 22:07:21.617 IST [768087] WARNING: pga:: *** executor_run() X ***
2024-08-29 22:07:21.618 IST [768087] WARNING: pga:: *** ExtensionHook::executor_run() X ***
2024-08-29 22:07:21.618 IST [768087] WARNING: pga:: *** get_current_query() X ***
2024-08-29 22:07:21.619 IST [768087] WARNING: pga:: *** get_current_query() "select db_name from _sqlx_test.databases where created_at < (to_timestamp($1) at time zone 'UTC')" ***
2024-08-29 22:07:21.619 IST [768087] WARNING: pga:: *** get_query_relations() X ***
2024-08-29 22:07:21.619 IST [768087] WARNING: pga:: *** get_query_relations() 1 ***
2024-08-29 22:07:21.619 IST [768087] WARNING: query_relations.is_empty() :: false
2024-08-29 22:07:21.619 IST [768087] WARNING: pga:: *** ExtensionHook::executor_run() Y Stg-01 ***
2024-08-29 22:07:21.619 IST [768087] WARNING: pga:: *** executor_run() Y ***
2024-08-29 22:07:21.619 IST [768087] LOG: statement: drop database if exists "_sqlx_test_628";
2024-08-29 22:07:21.622 IST [767187] LOG: checkpoint starting: immediate force wait
2024-08-29 22:07:21.669 IST [767187] LOG: checkpoint complete: wrote 5 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.013 s, sync=0.011 s, total=0.048 s; sync files=4, longest=0.005 s, average=0.003 s; distance=5 kB, estimate=5 kB; lsn=0/920A4FF0, redo lsn=0/920A4FB8
2024-08-29 22:07:21.690 IST [768087] LOG: execute sqlx_s_2: delete from _sqlx_test.databases where db_name = any($1::text[])
2024-08-29 22:07:21.690 IST [768087] DETAIL: parameters: $1 = '{_sqlx_test_628}'
2024-08-29 22:07:21.691 IST [768087] WARNING: pga:: *** executor_run() X ***
2024-08-29 22:07:21.691 IST [768087] WARNING: pga:: *** ExtensionHook::executor_run() X ***
2024-08-29 22:07:21.691 IST [768087] WARNING: pga:: *** get_current_query() X ***
2024-08-29 22:07:21.691 IST [768087] WARNING: pga:: *** get_current_query() "delete from _sqlx_test.databases where db_name = any($1::text[])" ***
2024-08-29 22:07:21.691 IST [768087] WARNING: pga:: *** get_query_relations() X ***
2024-08-29 22:07:21.691 IST [768087] WARNING: pga:: *** get_query_relations() 1 ***
2024-08-29 22:07:21.691 IST [768087] WARNING: query_relations.is_empty() :: false
2024-08-29 22:07:21.691 IST [768087] WARNING: pga:: *** ExtensionHook::executor_run() Y Stg-01 ***
2024-08-29 22:07:21.691 IST [768087] WARNING: pga:: *** executor_run() Y ***
2024-08-29 22:07:21.694 IST [768087] LOG: execute sqlx_s_3:
insert into _sqlx_test.databases(db_name, test_path)
select '_sqlx_test_' || nextval('_sqlx_test.database_ids'), $1
returning db_name
2024-08-29 22:07:21.694 IST [768087] DETAIL: parameters: $1 = '1724949441609608'
2024-08-29 22:07:21.694 IST [768087] WARNING: pga:: *** executor_run() X ***
2024-08-29 22:07:21.694 IST [768087] WARNING: pga:: *** ExtensionHook::executor_run() X ***
2024-08-29 22:07:21.694 IST [768087] WARNING: pga:: *** get_current_query() X ***
2024-08-29 22:07:21.694 IST [768087] WARNING: pga:: *** get_current_query() "\n insert into _sqlx_test.databases(db_name, test_path)\n select '_sqlx_test_' || nextval('_sqlx_test.database_ids'), $1\n returning db_name\n " ***
2024-08-29 22:07:21.694 IST [768087] WARNING: pga:: *** get_query_relations() X ***
2024-08-29 22:07:21.694 IST [768087] WARNING: pga:: *** get_query_relations() 1 ***
2024-08-29 22:07:21.694 IST [768087] WARNING: query_relations.is_empty() :: false
2024-08-29 22:07:21.695 IST [768087] WARNING: pga:: *** ExtensionHook::executor_run() Y Stg-01 ***
2024-08-29 22:07:21.695 IST [768087] WARNING: pga:: *** executor_run() Y ***
2024-08-29 22:07:21.697 IST [768087] LOG: statement: create database "_sqlx_test_629"
2024-08-29 22:07:21.768 IST [768134] LOG: execute sqlx_s_1: CREATE EXTENSION pg_analytics;
2024-08-29 22:07:21.778 IST [768136] LOG: statement: drop database if exists "_sqlx_test_629";
2024-08-29 22:07:26.781 IST [768136] ERROR: database "_sqlx_test_629" is being accessed by other users
2024-08-29 22:07:26.781 IST [768136] DETAIL: There is 1 other session using the database.
2024-08-29 22:07:26.781 IST [768136] STATEMENT: drop database if exists "_sqlx_test_629";
2024-08-29 22:07:32.221 IST [768134] LOG: statement:
DROP TABLE IF EXISTS auto_sales_partitioned CASCADE;
2024-08-29 22:07:32.222 IST [768134] NOTICE: table "auto_sales_partitioned" does not exist, skipping
2024-08-29 22:07:32.222 IST [768134] LOG: statement:
DROP SERVER IF EXISTS auto_sales_server CASCADE;
2024-08-29 22:07:32.222 IST [768134] NOTICE: server "auto_sales_server" does not exist, skipping
2024-08-29 22:07:32.222 IST [768134] LOG: statement:
DROP FOREIGN DATA WRAPPER IF EXISTS parquet_wrapper CASCADE;
2024-08-29 22:07:32.222 IST [768134] NOTICE: foreign-data wrapper "parquet_wrapper" does not exist, skipping
2024-08-29 22:07:32.222 IST [768134] LOG: statement:
DROP USER MAPPING IF EXISTS FOR public SERVER auto_sales_server;
2024-08-29 22:07:32.222 IST [768134] NOTICE: server "auto_sales_server" does not exist, skipping
2024-08-29 22:07:32.222 IST [768134] LOG: statement: CREATE FOREIGN DATA WRAPPER parquet_wrapper
HANDLER parquet_fdw_handler
VALIDATOR parquet_fdw_validator
2024-08-29 22:07:32.227 IST [768134] LOG: statement: CREATE SERVER auto_sales_server
FOREIGN DATA WRAPPER parquet_wrapper
2024-08-29 22:07:32.229 IST [768134] LOG: statement: CREATE USER MAPPING FOR public
SERVER auto_sales_server
OPTIONS (
type 'S3',
region 'us-east-1',
endpoint 'localhost:33026',
use_ssl 'false',
url_style 'path'
)
2024-08-29 22:07:32.231 IST [768134] LOG: statement:
CREATE TABLE auto_sales_partitioned (
sale_id BIGINT,
sale_date DATE,
manufacturer TEXT,
model TEXT,
price DOUBLE PRECISION,
dealership_id INT,
customer_id INT,
year INT,
month INT
)
PARTITION BY LIST (year);
2024-08-29 22:07:32.235 IST [768134] LOG: statement:
CREATE TABLE auto_sales_y2020
PARTITION OF auto_sales_partitioned
FOR VALUES IN (2020)
PARTITION BY LIST (manufacturer);
2024-08-29 22:07:32.239 IST [768134] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2020_Toyota
PARTITION OF auto_sales_y2020
FOR VALUES IN ('Toyota')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2020/Toyota/*.parquet'
);
2024-08-29 22:07:32.240 IST [768134] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2020_toyota" ***
2024-08-29 22:07:32.249 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:33026', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:07:32.250 IST [768134] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2020_toyota", "public" ***
2024-08-29 22:07:32.283 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:07:32.284 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2020_toyota AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2020/Toyota/*.parquet')" ***
2024-08-29 22:07:32.295 IST [768134] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2020_Honda
PARTITION OF auto_sales_y2020
FOR VALUES IN ('Honda')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2020/Honda/*.parquet'
);
2024-08-29 22:07:32.296 IST [768134] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2020_honda" ***
2024-08-29 22:07:32.296 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:33026', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:07:32.296 IST [768134] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2020_honda", "public" ***
2024-08-29 22:07:32.300 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:07:32.300 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2020_honda AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2020/Honda/*.parquet')" ***
2024-08-29 22:07:32.315 IST [768134] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2020_Ford
PARTITION OF auto_sales_y2020
FOR VALUES IN ('Ford')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2020/Ford/*.parquet'
);
2024-08-29 22:07:32.316 IST [768134] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2020_ford" ***
2024-08-29 22:07:32.316 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:33026', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:07:32.316 IST [768134] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2020_ford", "public" ***
2024-08-29 22:07:32.320 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:07:32.320 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2020_ford AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2020/Ford/*.parquet')" ***
2024-08-29 22:07:32.334 IST [768134] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2020_Chevrolet
PARTITION OF auto_sales_y2020
FOR VALUES IN ('Chevrolet')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2020/Chevrolet/*.parquet'
);
2024-08-29 22:07:32.334 IST [768134] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2020_chevrolet" ***
2024-08-29 22:07:32.334 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:33026', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:07:32.335 IST [768134] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2020_chevrolet", "public" ***
2024-08-29 22:07:32.338 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:07:32.338 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2020_chevrolet AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2020/Chevrolet/*.parquet')" ***
2024-08-29 22:07:32.350 IST [768134] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2020_Nissan
PARTITION OF auto_sales_y2020
FOR VALUES IN ('Nissan')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2020/Nissan/*.parquet'
);
2024-08-29 22:07:32.351 IST [768134] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2020_nissan" ***
2024-08-29 22:07:32.351 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:33026', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:07:32.351 IST [768134] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2020_nissan", "public" ***
2024-08-29 22:07:32.354 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:07:32.355 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2020_nissan AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2020/Nissan/*.parquet')" ***
2024-08-29 22:07:32.366 IST [768134] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2020_BMW
PARTITION OF auto_sales_y2020
FOR VALUES IN ('BMW')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2020/BMW/*.parquet'
);
2024-08-29 22:07:32.366 IST [768134] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2020_bmw" ***
2024-08-29 22:07:32.367 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:33026', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:07:32.367 IST [768134] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2020_bmw", "public" ***
2024-08-29 22:07:32.371 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:07:32.371 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2020_bmw AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2020/BMW/*.parquet')" ***
2024-08-29 22:07:32.383 IST [768134] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2020_Mercedes
PARTITION OF auto_sales_y2020
FOR VALUES IN ('Mercedes')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2020/Mercedes/*.parquet'
);
2024-08-29 22:07:32.383 IST [768134] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2020_mercedes" ***
2024-08-29 22:07:32.383 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:33026', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:07:32.384 IST [768134] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2020_mercedes", "public" ***
2024-08-29 22:07:32.387 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:07:32.387 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2020_mercedes AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2020/Mercedes/*.parquet')" ***
2024-08-29 22:07:32.400 IST [768134] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2020_Audi
PARTITION OF auto_sales_y2020
FOR VALUES IN ('Audi')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2020/Audi/*.parquet'
);
2024-08-29 22:07:32.400 IST [768134] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2020_audi" ***
2024-08-29 22:07:32.401 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:33026', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:07:32.401 IST [768134] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2020_audi", "public" ***
2024-08-29 22:07:32.404 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:07:32.404 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2020_audi AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2020/Audi/*.parquet')" ***
2024-08-29 22:07:32.418 IST [768134] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2020_Hyundai
PARTITION OF auto_sales_y2020
FOR VALUES IN ('Hyundai')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2020/Hyundai/*.parquet'
);
2024-08-29 22:07:32.418 IST [768134] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2020_hyundai" ***
2024-08-29 22:07:32.418 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:33026', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:07:32.419 IST [768134] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2020_hyundai", "public" ***
2024-08-29 22:07:32.422 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:07:32.422 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2020_hyundai AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2020/Hyundai/*.parquet')" ***
2024-08-29 22:07:32.434 IST [768134] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2020_Kia
PARTITION OF auto_sales_y2020
FOR VALUES IN ('Kia')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2020/Kia/*.parquet'
);
2024-08-29 22:07:32.434 IST [768134] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2020_kia" ***
2024-08-29 22:07:32.434 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:33026', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:07:32.434 IST [768134] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2020_kia", "public" ***
2024-08-29 22:07:32.438 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:07:32.438 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2020_kia AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2020/Kia/*.parquet')" ***
2024-08-29 22:07:32.449 IST [768134] LOG: statement:
CREATE TABLE auto_sales_y2021
PARTITION OF auto_sales_partitioned
FOR VALUES IN (2021)
PARTITION BY LIST (manufacturer);
2024-08-29 22:07:32.452 IST [768134] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2021_Toyota
PARTITION OF auto_sales_y2021
FOR VALUES IN ('Toyota')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2021/Toyota/*.parquet'
);
2024-08-29 22:07:32.452 IST [768134] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2021_toyota" ***
2024-08-29 22:07:32.453 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:33026', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:07:32.453 IST [768134] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2021_toyota", "public" ***
2024-08-29 22:07:32.457 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:07:32.457 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2021_toyota AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2021/Toyota/*.parquet')" ***
2024-08-29 22:07:32.470 IST [768134] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2021_Honda
PARTITION OF auto_sales_y2021
FOR VALUES IN ('Honda')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2021/Honda/*.parquet'
);
2024-08-29 22:07:32.471 IST [768134] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2021_honda" ***
2024-08-29 22:07:32.471 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:33026', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:07:32.471 IST [768134] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2021_honda", "public" ***
2024-08-29 22:07:32.476 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:07:32.476 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2021_honda AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2021/Honda/*.parquet')" ***
2024-08-29 22:07:32.494 IST [768134] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2021_Ford
PARTITION OF auto_sales_y2021
FOR VALUES IN ('Ford')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2021/Ford/*.parquet'
);
2024-08-29 22:07:32.495 IST [768134] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2021_ford" ***
2024-08-29 22:07:32.495 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:33026', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:07:32.495 IST [768134] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2021_ford", "public" ***
2024-08-29 22:07:32.499 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:07:32.499 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2021_ford AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2021/Ford/*.parquet')" ***
2024-08-29 22:07:32.514 IST [768134] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2021_Chevrolet
PARTITION OF auto_sales_y2021
FOR VALUES IN ('Chevrolet')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2021/Chevrolet/*.parquet'
);
2024-08-29 22:07:32.514 IST [768134] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2021_chevrolet" ***
2024-08-29 22:07:32.514 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:33026', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:07:32.515 IST [768134] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2021_chevrolet", "public" ***
2024-08-29 22:07:32.520 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:07:32.520 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2021_chevrolet AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2021/Chevrolet/*.parquet')" ***
2024-08-29 22:07:32.532 IST [768134] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2021_Nissan
PARTITION OF auto_sales_y2021
FOR VALUES IN ('Nissan')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2021/Nissan/*.parquet'
);
2024-08-29 22:07:32.532 IST [768134] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2021_nissan" ***
2024-08-29 22:07:32.532 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:33026', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:07:32.532 IST [768134] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2021_nissan", "public" ***
2024-08-29 22:07:32.536 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:07:32.536 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2021_nissan AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2021/Nissan/*.parquet')" ***
2024-08-29 22:07:32.549 IST [768134] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2021_BMW
PARTITION OF auto_sales_y2021
FOR VALUES IN ('BMW')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2021/BMW/*.parquet'
);
2024-08-29 22:07:32.549 IST [768134] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2021_bmw" ***
2024-08-29 22:07:32.550 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:33026', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:07:32.550 IST [768134] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2021_bmw", "public" ***
2024-08-29 22:07:32.555 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:07:32.555 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2021_bmw AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2021/BMW/*.parquet')" ***
2024-08-29 22:07:32.570 IST [768134] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2021_Mercedes
PARTITION OF auto_sales_y2021
FOR VALUES IN ('Mercedes')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2021/Mercedes/*.parquet'
);
2024-08-29 22:07:32.570 IST [768134] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2021_mercedes" ***
2024-08-29 22:07:32.570 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:33026', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:07:32.570 IST [768134] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2021_mercedes", "public" ***
2024-08-29 22:07:32.574 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:07:32.574 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2021_mercedes AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2021/Mercedes/*.parquet')" ***
2024-08-29 22:07:32.587 IST [768134] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2021_Audi
PARTITION OF auto_sales_y2021
FOR VALUES IN ('Audi')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2021/Audi/*.parquet'
);
2024-08-29 22:07:32.587 IST [768134] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2021_audi" ***
2024-08-29 22:07:32.588 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:33026', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:07:32.588 IST [768134] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2021_audi", "public" ***
2024-08-29 22:07:32.592 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:07:32.592 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2021_audi AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2021/Audi/*.parquet')" ***
2024-08-29 22:07:32.604 IST [768134] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2021_Hyundai
PARTITION OF auto_sales_y2021
FOR VALUES IN ('Hyundai')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2021/Hyundai/*.parquet'
);
2024-08-29 22:07:32.604 IST [768134] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2021_hyundai" ***
2024-08-29 22:07:32.604 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:33026', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:07:32.605 IST [768134] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2021_hyundai", "public" ***
2024-08-29 22:07:32.608 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:07:32.608 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2021_hyundai AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2021/Hyundai/*.parquet')" ***
2024-08-29 22:07:32.620 IST [768134] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2021_Kia
PARTITION OF auto_sales_y2021
FOR VALUES IN ('Kia')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2021/Kia/*.parquet'
);
2024-08-29 22:07:32.621 IST [768134] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2021_kia" ***
2024-08-29 22:07:32.621 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:33026', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:07:32.621 IST [768134] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2021_kia", "public" ***
2024-08-29 22:07:32.625 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:07:32.625 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2021_kia AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2021/Kia/*.parquet')" ***
2024-08-29 22:07:32.639 IST [768134] LOG: statement:
CREATE TABLE auto_sales_y2022
PARTITION OF auto_sales_partitioned
FOR VALUES IN (2022)
PARTITION BY LIST (manufacturer);
2024-08-29 22:07:32.640 IST [768134] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2022_Toyota
PARTITION OF auto_sales_y2022
FOR VALUES IN ('Toyota')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2022/Toyota/*.parquet'
);
2024-08-29 22:07:32.640 IST [768134] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2022_toyota" ***
2024-08-29 22:07:32.641 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:33026', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:07:32.641 IST [768134] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2022_toyota", "public" ***
2024-08-29 22:07:32.645 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:07:32.645 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2022_toyota AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2022/Toyota/*.parquet')" ***
2024-08-29 22:07:32.657 IST [768134] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2022_Honda
PARTITION OF auto_sales_y2022
FOR VALUES IN ('Honda')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2022/Honda/*.parquet'
);
2024-08-29 22:07:32.658 IST [768134] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2022_honda" ***
2024-08-29 22:07:32.658 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:33026', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:07:32.658 IST [768134] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2022_honda", "public" ***
2024-08-29 22:07:32.662 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:07:32.662 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2022_honda AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2022/Honda/*.parquet')" ***
2024-08-29 22:07:32.675 IST [768134] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2022_Ford
PARTITION OF auto_sales_y2022
FOR VALUES IN ('Ford')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2022/Ford/*.parquet'
);
2024-08-29 22:07:32.675 IST [768134] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2022_ford" ***
2024-08-29 22:07:32.676 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:33026', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:07:32.676 IST [768134] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2022_ford", "public" ***
2024-08-29 22:07:32.680 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:07:32.680 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2022_ford AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2022/Ford/*.parquet')" ***
2024-08-29 22:07:32.694 IST [768134] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2022_Chevrolet
PARTITION OF auto_sales_y2022
FOR VALUES IN ('Chevrolet')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2022/Chevrolet/*.parquet'
);
2024-08-29 22:07:32.695 IST [768134] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2022_chevrolet" ***
2024-08-29 22:07:32.695 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:33026', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:07:32.695 IST [768134] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2022_chevrolet", "public" ***
2024-08-29 22:07:32.700 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:07:32.700 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2022_chevrolet AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2022/Chevrolet/*.parquet')" ***
2024-08-29 22:07:32.713 IST [768134] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2022_Nissan
PARTITION OF auto_sales_y2022
FOR VALUES IN ('Nissan')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2022/Nissan/*.parquet'
);
2024-08-29 22:07:32.714 IST [768134] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2022_nissan" ***
2024-08-29 22:07:32.714 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:33026', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:07:32.714 IST [768134] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2022_nissan", "public" ***
2024-08-29 22:07:32.718 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:07:32.718 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2022_nissan AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2022/Nissan/*.parquet')" ***
2024-08-29 22:07:32.734 IST [768134] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2022_BMW
PARTITION OF auto_sales_y2022
FOR VALUES IN ('BMW')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2022/BMW/*.parquet'
);
2024-08-29 22:07:32.735 IST [768134] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2022_bmw" ***
2024-08-29 22:07:32.735 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:33026', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:07:32.735 IST [768134] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2022_bmw", "public" ***
2024-08-29 22:07:32.739 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:07:32.739 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2022_bmw AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2022/BMW/*.parquet')" ***
2024-08-29 22:07:32.753 IST [768134] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2022_Mercedes
PARTITION OF auto_sales_y2022
FOR VALUES IN ('Mercedes')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2022/Mercedes/*.parquet'
);
2024-08-29 22:07:32.754 IST [768134] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2022_mercedes" ***
2024-08-29 22:07:32.754 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:33026', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:07:32.754 IST [768134] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2022_mercedes", "public" ***
2024-08-29 22:07:32.758 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:07:32.759 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2022_mercedes AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2022/Mercedes/*.parquet')" ***
2024-08-29 22:07:32.771 IST [768134] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2022_Audi
PARTITION OF auto_sales_y2022
FOR VALUES IN ('Audi')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2022/Audi/*.parquet'
);
2024-08-29 22:07:32.771 IST [768134] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2022_audi" ***
2024-08-29 22:07:32.771 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:33026', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:07:32.772 IST [768134] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2022_audi", "public" ***
2024-08-29 22:07:32.775 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:07:32.776 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2022_audi AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2022/Audi/*.parquet')" ***
2024-08-29 22:07:32.789 IST [768134] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2022_Hyundai
PARTITION OF auto_sales_y2022
FOR VALUES IN ('Hyundai')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2022/Hyundai/*.parquet'
);
2024-08-29 22:07:32.790 IST [768134] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2022_hyundai" ***
2024-08-29 22:07:32.790 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:33026', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:07:32.790 IST [768134] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2022_hyundai", "public" ***
2024-08-29 22:07:32.795 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:07:32.795 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2022_hyundai AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2022/Hyundai/*.parquet')" ***
2024-08-29 22:07:32.809 IST [768134] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2022_Kia
PARTITION OF auto_sales_y2022
FOR VALUES IN ('Kia')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2022/Kia/*.parquet'
);
2024-08-29 22:07:32.810 IST [768134] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2022_kia" ***
2024-08-29 22:07:32.810 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:33026', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:07:32.810 IST [768134] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2022_kia", "public" ***
2024-08-29 22:07:32.814 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:07:32.815 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2022_kia AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2022/Kia/*.parquet')" ***
2024-08-29 22:07:32.827 IST [768134] LOG: statement:
CREATE TABLE auto_sales_y2023
PARTITION OF auto_sales_partitioned
FOR VALUES IN (2023)
PARTITION BY LIST (manufacturer);
2024-08-29 22:07:32.828 IST [768134] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2023_Toyota
PARTITION OF auto_sales_y2023
FOR VALUES IN ('Toyota')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2023/Toyota/*.parquet'
);
2024-08-29 22:07:32.828 IST [768134] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2023_toyota" ***
2024-08-29 22:07:32.829 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:33026', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:07:32.829 IST [768134] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2023_toyota", "public" ***
2024-08-29 22:07:32.832 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:07:32.832 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2023_toyota AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2023/Toyota/*.parquet')" ***
2024-08-29 22:07:32.844 IST [768134] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2023_Honda
PARTITION OF auto_sales_y2023
FOR VALUES IN ('Honda')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2023/Honda/*.parquet'
);
2024-08-29 22:07:32.845 IST [768134] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2023_honda" ***
2024-08-29 22:07:32.845 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:33026', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:07:32.845 IST [768134] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2023_honda", "public" ***
2024-08-29 22:07:32.849 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:07:32.849 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2023_honda AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2023/Honda/*.parquet')" ***
2024-08-29 22:07:32.862 IST [768134] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2023_Ford
PARTITION OF auto_sales_y2023
FOR VALUES IN ('Ford')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2023/Ford/*.parquet'
);
2024-08-29 22:07:32.863 IST [768134] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2023_ford" ***
2024-08-29 22:07:32.863 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:33026', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:07:32.863 IST [768134] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2023_ford", "public" ***
2024-08-29 22:07:32.868 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:07:32.868 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2023_ford AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2023/Ford/*.parquet')" ***
2024-08-29 22:07:32.883 IST [768134] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2023_Chevrolet
PARTITION OF auto_sales_y2023
FOR VALUES IN ('Chevrolet')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2023/Chevrolet/*.parquet'
);
2024-08-29 22:07:32.883 IST [768134] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2023_chevrolet" ***
2024-08-29 22:07:32.883 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:33026', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:07:32.884 IST [768134] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2023_chevrolet", "public" ***
2024-08-29 22:07:32.889 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:07:32.889 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2023_chevrolet AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2023/Chevrolet/*.parquet')" ***
2024-08-29 22:07:32.905 IST [768134] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2023_Nissan
PARTITION OF auto_sales_y2023
FOR VALUES IN ('Nissan')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2023/Nissan/*.parquet'
);
2024-08-29 22:07:32.905 IST [768134] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2023_nissan" ***
2024-08-29 22:07:32.905 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:33026', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:07:32.906 IST [768134] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2023_nissan", "public" ***
2024-08-29 22:07:32.909 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:07:32.910 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2023_nissan AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2023/Nissan/*.parquet')" ***
2024-08-29 22:07:32.921 IST [768134] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2023_BMW
PARTITION OF auto_sales_y2023
FOR VALUES IN ('BMW')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2023/BMW/*.parquet'
);
2024-08-29 22:07:32.921 IST [768134] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2023_bmw" ***
2024-08-29 22:07:32.921 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:33026', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:07:32.922 IST [768134] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2023_bmw", "public" ***
2024-08-29 22:07:32.925 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:07:32.925 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2023_bmw AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2023/BMW/*.parquet')" ***
2024-08-29 22:07:32.936 IST [768134] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2023_Mercedes
PARTITION OF auto_sales_y2023
FOR VALUES IN ('Mercedes')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2023/Mercedes/*.parquet'
);
2024-08-29 22:07:32.936 IST [768134] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2023_mercedes" ***
2024-08-29 22:07:32.936 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:33026', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:07:32.936 IST [768134] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2023_mercedes", "public" ***
2024-08-29 22:07:32.940 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:07:32.941 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2023_mercedes AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2023/Mercedes/*.parquet')" ***
2024-08-29 22:07:32.953 IST [768134] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2023_Audi
PARTITION OF auto_sales_y2023
FOR VALUES IN ('Audi')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2023/Audi/*.parquet'
);
2024-08-29 22:07:32.953 IST [768134] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2023_audi" ***
2024-08-29 22:07:32.953 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:33026', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:07:32.953 IST [768134] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2023_audi", "public" ***
2024-08-29 22:07:32.957 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:07:32.957 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2023_audi AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2023/Audi/*.parquet')" ***
2024-08-29 22:07:32.967 IST [768134] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2023_Hyundai
PARTITION OF auto_sales_y2023
FOR VALUES IN ('Hyundai')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2023/Hyundai/*.parquet'
);
2024-08-29 22:07:32.968 IST [768134] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2023_hyundai" ***
2024-08-29 22:07:32.968 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:33026', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:07:32.968 IST [768134] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2023_hyundai", "public" ***
2024-08-29 22:07:32.972 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:07:32.972 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2023_hyundai AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2023/Hyundai/*.parquet')" ***
2024-08-29 22:07:32.984 IST [768134] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2023_Kia
PARTITION OF auto_sales_y2023
FOR VALUES IN ('Kia')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2023/Kia/*.parquet'
);
2024-08-29 22:07:32.984 IST [768134] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2023_kia" ***
2024-08-29 22:07:32.984 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:33026', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:07:32.984 IST [768134] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2023_kia", "public" ***
2024-08-29 22:07:32.988 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:07:32.988 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2023_kia AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2023/Kia/*.parquet')" ***
2024-08-29 22:07:33.000 IST [768134] LOG: statement:
CREATE TABLE auto_sales_y2024
PARTITION OF auto_sales_partitioned
FOR VALUES IN (2024)
PARTITION BY LIST (manufacturer);
2024-08-29 22:07:33.001 IST [768134] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2024_Toyota
PARTITION OF auto_sales_y2024
FOR VALUES IN ('Toyota')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2024/Toyota/*.parquet'
);
2024-08-29 22:07:33.001 IST [768134] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2024_toyota" ***
2024-08-29 22:07:33.001 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:33026', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:07:33.002 IST [768134] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2024_toyota", "public" ***
2024-08-29 22:07:33.005 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:07:33.005 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2024_toyota AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2024/Toyota/*.parquet')" ***
2024-08-29 22:07:33.017 IST [768134] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2024_Honda
PARTITION OF auto_sales_y2024
FOR VALUES IN ('Honda')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2024/Honda/*.parquet'
);
2024-08-29 22:07:33.017 IST [768134] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2024_honda" ***
2024-08-29 22:07:33.018 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:33026', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:07:33.018 IST [768134] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2024_honda", "public" ***
2024-08-29 22:07:33.021 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:07:33.022 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2024_honda AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2024/Honda/*.parquet')" ***
2024-08-29 22:07:33.034 IST [768134] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2024_Ford
PARTITION OF auto_sales_y2024
FOR VALUES IN ('Ford')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2024/Ford/*.parquet'
);
2024-08-29 22:07:33.034 IST [768134] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2024_ford" ***
2024-08-29 22:07:33.035 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:33026', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:07:33.035 IST [768134] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2024_ford", "public" ***
2024-08-29 22:07:33.038 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:07:33.038 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2024_ford AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2024/Ford/*.parquet')" ***
2024-08-29 22:07:33.051 IST [768134] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2024_Chevrolet
PARTITION OF auto_sales_y2024
FOR VALUES IN ('Chevrolet')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2024/Chevrolet/*.parquet'
);
2024-08-29 22:07:33.051 IST [768134] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2024_chevrolet" ***
2024-08-29 22:07:33.051 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:33026', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:07:33.051 IST [768134] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2024_chevrolet", "public" ***
2024-08-29 22:07:33.055 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:07:33.055 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2024_chevrolet AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2024/Chevrolet/*.parquet')" ***
2024-08-29 22:07:33.065 IST [768134] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2024_Nissan
PARTITION OF auto_sales_y2024
FOR VALUES IN ('Nissan')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2024/Nissan/*.parquet'
);
2024-08-29 22:07:33.066 IST [768134] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2024_nissan" ***
2024-08-29 22:07:33.066 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:33026', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:07:33.066 IST [768134] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2024_nissan", "public" ***
2024-08-29 22:07:33.069 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:07:33.070 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2024_nissan AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2024/Nissan/*.parquet')" ***
2024-08-29 22:07:33.079 IST [768134] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2024_BMW
PARTITION OF auto_sales_y2024
FOR VALUES IN ('BMW')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2024/BMW/*.parquet'
);
2024-08-29 22:07:33.080 IST [768134] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2024_bmw" ***
2024-08-29 22:07:33.080 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:33026', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:07:33.080 IST [768134] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2024_bmw", "public" ***
2024-08-29 22:07:33.084 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:07:33.084 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2024_bmw AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2024/BMW/*.parquet')" ***
2024-08-29 22:07:33.094 IST [768134] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2024_Mercedes
PARTITION OF auto_sales_y2024
FOR VALUES IN ('Mercedes')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2024/Mercedes/*.parquet'
);
2024-08-29 22:07:33.094 IST [768134] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2024_mercedes" ***
2024-08-29 22:07:33.094 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:33026', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:07:33.094 IST [768134] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2024_mercedes", "public" ***
2024-08-29 22:07:33.098 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:07:33.098 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2024_mercedes AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2024/Mercedes/*.parquet')" ***
2024-08-29 22:07:33.108 IST [768134] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2024_Audi
PARTITION OF auto_sales_y2024
FOR VALUES IN ('Audi')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2024/Audi/*.parquet'
);
2024-08-29 22:07:33.109 IST [768134] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2024_audi" ***
2024-08-29 22:07:33.109 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:33026', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:07:33.109 IST [768134] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2024_audi", "public" ***
2024-08-29 22:07:33.113 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:07:33.113 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2024_audi AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2024/Audi/*.parquet')" ***
2024-08-29 22:07:33.123 IST [768134] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2024_Hyundai
PARTITION OF auto_sales_y2024
FOR VALUES IN ('Hyundai')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2024/Hyundai/*.parquet'
);
2024-08-29 22:07:33.123 IST [768134] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2024_hyundai" ***
2024-08-29 22:07:33.123 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:33026', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:07:33.124 IST [768134] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2024_hyundai", "public" ***
2024-08-29 22:07:33.127 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:07:33.127 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2024_hyundai AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2024/Hyundai/*.parquet')" ***
2024-08-29 22:07:33.137 IST [768134] LOG: statement:
CREATE FOREIGN TABLE auto_sales_y2024_Kia
PARTITION OF auto_sales_y2024
FOR VALUES IN ('Kia')
SERVER auto_sales_server
OPTIONS (
files 's3://demo-mlp-auto-sales/2024/Kia/*.parquet'
);
2024-08-29 22:07:33.137 IST [768134] WARNING: pga:: *** duckdb::execute() "DROP VIEW IF EXISTS public.auto_sales_y2024_kia" ***
2024-08-29 22:07:33.137 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:33026', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:07:33.137 IST [768134] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2024_kia", "public" ***
2024-08-29 22:07:33.141 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE SCHEMA IF NOT EXISTS public" ***
2024-08-29 22:07:33.141 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE VIEW IF NOT EXISTS public.auto_sales_y2024_kia AS SELECT * FROM read_parquet('s3://demo-mlp-auto-sales/2024/Kia/*.parquet')" ***
2024-08-29 22:07:33.154 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE OR REPLACE SECRET default_secret (TYPE S3, REGION 'us-east-1', ENDPOINT 'localhost:33026', URL_STYLE 'path', USE_SSL false)" ***
2024-08-29 22:07:33.154 IST [768134] WARNING: pga:: *** duckdb::view_exists() "auto_sales_y2024_toyota", "public" ***
2024-08-29 22:07:33.158 IST [768134] LOG: execute sqlx_s_2:
SELECT year, month, COUNT(*) as sales_count,
array_agg(sale_id) as sale_ids
FROM auto_sales_partitioned
WHERE manufacturer = 'Toyota' AND year = 2024
GROUP BY year, month
ORDER BY month;
2024-08-29 22:07:33.158 IST [768134] WARNING: pga:: *** executor_run() X ***
2024-08-29 22:07:33.158 IST [768134] WARNING: pga:: *** ExtensionHook::executor_run() X ***
2024-08-29 22:07:33.158 IST [768134] WARNING: pga:: *** get_current_query() X ***
2024-08-29 22:07:33.158 IST [768134] WARNING: pga:: *** get_current_query() "\n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_partitioned\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:07:33.158 IST [768134] WARNING: pga:: *** get_query_relations() X ***
2024-08-29 22:07:33.158 IST [768134] WARNING: pga:: *** get_query_relations() 3 ***
2024-08-29 22:07:33.158 IST [768134] WARNING: query_relations.is_empty() :: false
2024-08-29 22:07:33.160 IST [768134] WARNING: pga:: *** duckdb::execute() "SET search_path TO 'public'" ***
2024-08-29 22:07:33.160 IST [768134] WARNING: pga:: *** executor_run() X ***
2024-08-29 22:07:33.160 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209672"
2024-08-29 22:07:33.160 IST [768134] WARNING: pga:: *** ExtensionHook::executor_run() X ***
2024-08-29 22:07:33.160 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209672"
2024-08-29 22:07:33.160 IST [768134] WARNING: pga:: *** get_current_query() X ***
2024-08-29 22:07:33.160 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209672"
2024-08-29 22:07:33.160 IST [768134] WARNING: pga:: *** get_current_query() "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209672" ***
2024-08-29 22:07:33.160 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209672"
2024-08-29 22:07:33.160 IST [768134] WARNING: pga:: *** get_query_relations() X ***
2024-08-29 22:07:33.160 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209672"
2024-08-29 22:07:33.160 IST [768134] WARNING: pga:: *** get_query_relations() 1 ***
2024-08-29 22:07:33.160 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209672"
2024-08-29 22:07:33.160 IST [768134] WARNING: query_relations.is_empty() :: false
2024-08-29 22:07:33.160 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209672"
2024-08-29 22:07:33.160 IST [768134] WARNING: pga:: *** ExtensionHook::executor_run() Y Stg-01 ***
2024-08-29 22:07:33.160 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209672"
2024-08-29 22:07:33.160 IST [768134] WARNING: pga:: *** executor_run() Y ***
2024-08-29 22:07:33.160 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209672"
2024-08-29 22:07:33.161 IST [768134] WARNING: pga:: *** executor_run() X ***
2024-08-29 22:07:33.161 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209675"
2024-08-29 22:07:33.161 IST [768134] WARNING: pga:: *** ExtensionHook::executor_run() X ***
2024-08-29 22:07:33.161 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209675"
2024-08-29 22:07:33.161 IST [768134] WARNING: pga:: *** get_current_query() X ***
2024-08-29 22:07:33.161 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209675"
2024-08-29 22:07:33.161 IST [768134] WARNING: pga:: *** get_current_query() "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209675" ***
2024-08-29 22:07:33.161 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209675"
2024-08-29 22:07:33.161 IST [768134] WARNING: pga:: *** get_query_relations() X ***
2024-08-29 22:07:33.161 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209675"
2024-08-29 22:07:33.161 IST [768134] WARNING: pga:: *** get_query_relations() 1 ***
2024-08-29 22:07:33.161 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209675"
2024-08-29 22:07:33.161 IST [768134] WARNING: query_relations.is_empty() :: false
2024-08-29 22:07:33.161 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209675"
2024-08-29 22:07:33.161 IST [768134] WARNING: pga:: *** ExtensionHook::executor_run() Y Stg-01 ***
2024-08-29 22:07:33.161 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209675"
2024-08-29 22:07:33.161 IST [768134] WARNING: pga:: *** executor_run() Y ***
2024-08-29 22:07:33.161 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209675"
2024-08-29 22:07:33.161 IST [768134] WARNING: pga:: *** executor_run() X ***
2024-08-29 22:07:33.161 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209708"
2024-08-29 22:07:33.161 IST [768134] WARNING: pga:: *** ExtensionHook::executor_run() X ***
2024-08-29 22:07:33.161 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209708"
2024-08-29 22:07:33.161 IST [768134] WARNING: pga:: *** get_current_query() X ***
2024-08-29 22:07:33.161 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209708"
2024-08-29 22:07:33.161 IST [768134] WARNING: pga:: *** get_current_query() "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209708" ***
2024-08-29 22:07:33.161 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209708"
2024-08-29 22:07:33.161 IST [768134] WARNING: pga:: *** get_query_relations() X ***
2024-08-29 22:07:33.161 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209708"
2024-08-29 22:07:33.161 IST [768134] WARNING: pga:: *** get_query_relations() 1 ***
2024-08-29 22:07:33.161 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209708"
2024-08-29 22:07:33.161 IST [768134] WARNING: query_relations.is_empty() :: false
2024-08-29 22:07:33.161 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209708"
2024-08-29 22:07:33.161 IST [768134] WARNING: pga:: *** ExtensionHook::executor_run() Y Stg-01 ***
2024-08-29 22:07:33.161 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209708"
2024-08-29 22:07:33.161 IST [768134] WARNING: pga:: *** executor_run() Y ***
2024-08-29 22:07:33.161 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209708"
2024-08-29 22:07:33.161 IST [768134] WARNING: pga:: *** executor_run() X ***
2024-08-29 22:07:33.161 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209741"
2024-08-29 22:07:33.161 IST [768134] WARNING: pga:: *** ExtensionHook::executor_run() X ***
2024-08-29 22:07:33.161 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209741"
2024-08-29 22:07:33.161 IST [768134] WARNING: pga:: *** get_current_query() X ***
2024-08-29 22:07:33.161 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209741"
2024-08-29 22:07:33.161 IST [768134] WARNING: pga:: *** get_current_query() "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209741" ***
2024-08-29 22:07:33.161 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209741"
2024-08-29 22:07:33.161 IST [768134] WARNING: pga:: *** get_query_relations() X ***
2024-08-29 22:07:33.161 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209741"
2024-08-29 22:07:33.161 IST [768134] WARNING: pga:: *** get_query_relations() 1 ***
2024-08-29 22:07:33.161 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209741"
2024-08-29 22:07:33.161 IST [768134] WARNING: query_relations.is_empty() :: false
2024-08-29 22:07:33.161 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209741"
2024-08-29 22:07:33.161 IST [768134] WARNING: pga:: *** ExtensionHook::executor_run() Y Stg-01 ***
2024-08-29 22:07:33.161 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209741"
2024-08-29 22:07:33.161 IST [768134] WARNING: pga:: *** executor_run() Y ***
2024-08-29 22:07:33.161 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209741"
2024-08-29 22:07:33.161 IST [768134] WARNING: pga:: *** executor_run() X ***
2024-08-29 22:07:33.161 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209774"
2024-08-29 22:07:33.161 IST [768134] WARNING: pga:: *** ExtensionHook::executor_run() X ***
2024-08-29 22:07:33.161 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209774"
2024-08-29 22:07:33.161 IST [768134] WARNING: pga:: *** get_current_query() X ***
2024-08-29 22:07:33.161 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209774"
2024-08-29 22:07:33.161 IST [768134] WARNING: pga:: *** get_current_query() "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209774" ***
2024-08-29 22:07:33.161 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209774"
2024-08-29 22:07:33.161 IST [768134] WARNING: pga:: *** get_query_relations() X ***
2024-08-29 22:07:33.161 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209774"
2024-08-29 22:07:33.161 IST [768134] WARNING: pga:: *** get_query_relations() 1 ***
2024-08-29 22:07:33.161 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209774"
2024-08-29 22:07:33.161 IST [768134] WARNING: query_relations.is_empty() :: false
2024-08-29 22:07:33.161 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209774"
2024-08-29 22:07:33.161 IST [768134] WARNING: pga:: *** ExtensionHook::executor_run() Y Stg-01 ***
2024-08-29 22:07:33.161 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209774"
2024-08-29 22:07:33.161 IST [768134] WARNING: pga:: *** executor_run() Y ***
2024-08-29 22:07:33.161 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209774"
2024-08-29 22:07:33.161 IST [768134] WARNING: pga:: *** executor_run() X ***
2024-08-29 22:07:33.161 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209807"
2024-08-29 22:07:33.161 IST [768134] WARNING: pga:: *** ExtensionHook::executor_run() X ***
2024-08-29 22:07:33.161 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209807"
2024-08-29 22:07:33.161 IST [768134] WARNING: pga:: *** get_current_query() X ***
2024-08-29 22:07:33.161 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209807"
2024-08-29 22:07:33.161 IST [768134] WARNING: pga:: *** get_current_query() "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209807" ***
2024-08-29 22:07:33.161 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209807"
2024-08-29 22:07:33.161 IST [768134] WARNING: pga:: *** get_query_relations() X ***
2024-08-29 22:07:33.161 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209807"
2024-08-29 22:07:33.162 IST [768134] WARNING: pga:: *** get_query_relations() 1 ***
2024-08-29 22:07:33.162 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209807"
2024-08-29 22:07:33.162 IST [768134] WARNING: query_relations.is_empty() :: false
2024-08-29 22:07:33.162 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209807"
2024-08-29 22:07:33.162 IST [768134] WARNING: pga:: *** ExtensionHook::executor_run() Y Stg-01 ***
2024-08-29 22:07:33.162 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209807"
2024-08-29 22:07:33.162 IST [768134] WARNING: pga:: *** executor_run() Y ***
2024-08-29 22:07:33.162 IST [768134] CONTEXT: SQL statement "SELECT inhrelid FROM pg_inherits WHERE inhparent = 209807"
2024-08-29 22:07:33.162 IST [768134] WARNING: pga:: optimize_transformed_queries X
2024-08-29 22:07:33.162 IST [768134] WARNING: pga:: optimize_transformed_queries keys :: {
"toyota",
"2024",
}
2024-08-29 22:07:33.163 IST [768134] WARNING: pga:: optimize_transformed_queries
2024-08-29 22:07:33.163 IST [768134] WARNING: pga:: 0 => "\n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2024_toyota\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month"
2024-08-29 22:07:33.163 IST [768134] WARNING: pga:: transformed_queries :: 50
optimized_transformed_queries :: 1
2024-08-29 22:07:33.163 IST [768134] WARNING: pga:: *** duckdb::execute() "CREATE TEMPORARY TABLE temp_result_cache_a5bdff43_2fb6_4669_9aef_74e47f484307 AS SELECT * FROM (\n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2020_toyota\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month) WHERE 1=0" ***
2024-08-29 22:07:33.173 IST [768134] WARNING: pga:: *** duckdb::execute() "INSERT INTO temp_result_cache_a5bdff43_2fb6_4669_9aef_74e47f484307 \n SELECT year, month, COUNT(*) as sales_count, \n array_agg(sale_id) as sale_ids\n FROM auto_sales_y2024_toyota\n WHERE manufacturer = 'Toyota' AND year = 2024\n GROUP BY year, month\n ORDER BY month" ***
2024-08-29 22:07:33.197 IST [768134] WARNING: pga:: *** duckdb::create_arrow() "SELECT year, month, sales_count, sale_ids FROM temp_result_cache_a5bdff43_2fb6_4669_9aef_74e47f484307 ORDER BY month" ***
2024-08-29 22:07:33.198 IST [768134] WARNING: pga:: *** duckdb::create_arrow() Y ***
2024-08-29 22:07:33.198 IST [768134] WARNING: pga:: *** ExtensionHook::write_batches_to_slots() X 1 ***
2024-08-29 22:07:33.198 IST [768134] WARNING: pga:: *** ExtensionHook::write_batches_to_slots() Y ***
2024-08-29 22:07:33.198 IST [768134] WARNING: pga:: *** duckdb::execute() "DROP TABLE IF EXISTS temp_result_cache_a5bdff43_2fb6_4669_9aef_74e47f484307" ***
2024-08-29 22:07:33.198 IST [768134] WARNING: pga:: *** ExtensionHook::executor_run() Y ***
2024-08-29 22:07:33.198 IST [768134] WARNING: pga:: *** executor_run() Y ***
Last active
August 29, 2024 16:39
-
-
Save shamb0/cedb9683f50601e0d92e9adb5a5be25c to your computer and use it in GitHub Desktop.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment