You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
./duckdb /home/postgres/db
COPY (select generate_series as id, md5(random()::text) as info,
now()::timestamp+(generate_series||' second')::interval as crt_time
from generate_series(1,100)) TO '/home/postgres/t1.parquet' (FORMAT 'PARQUET');
COPY (select generate_series as cid, md5(random()::text) as info,
now()::timestamp+(generate_series||' second')::interval as crt_time
from generate_series(1,100)) TO '/home/postgres/t2.parquet' (FORMAT 'PARQUET');
COPY (select (floor(random()*100)+1)::int as gid, (floor(random()*100)+1)::int as cid,
(random()*10)::int as c1, (random()*100)::int as c2, (random()*1000)::int as c3,
(random()*10000)::int as c4, (random()*100000)::int as c5 from generate_series(1,1000000))
TO '/home/postgres/t3.parquet' (FORMAT 'PARQUET');
create view t1 as select * from read_parquet('/home/postgres/t1.parquet');
create view t2 as select * from read_parquet('/home/postgres/t2.parquet');
create view t3 as select * from read_parquet('/home/postgres/t3.parquet');
checkpoint;
postgres=# \set VERBOSITY verbose
postgres=# set client_min_messages =DEBUG3;
postgres=# create extension duckdb_fdw;
CREATE EXTENSION
postgres=# CREATE SERVER DuckDB_server FOREIGN DATA WRAPPER duckdb_fdw OPTIONS
postgres-# (database '/home/postgres/db');
CREATE SERVER
postgres=# IMPORT FOREIGN SCHEMA public FROM SERVER DuckDB_server INTO public;
DEBUG: 00000: duckdb_fdw : duckdb_fdw_handler
LOCATION: duckdb_fdw_handler, duckdb_fdw.c:428
DEBUG: 00000: duckdb_fdw : sqliteImportForeignSchema
LOCATION: sqliteImportForeignSchema, duckdb_fdw.c:2964
DEBUG: 00000: duckdb_fdw xact_callback 2
LOCATION: sqlitefdw_xact_callback, connection.c:394
ERROR: HV00L: SQL error during prepare: bad parameter or other API misuse SELECT current_catalog() as remote_catalog
LOCATION: sqlite_prepare_wrapper, duckdb_fdw.c:503
postgres=#
postgres=# create foreign table t1 (id int8, info text, crt_time timestamp) server duckdb_server OPTIONS (table 't1');
CREATE FOREIGN TABLE
postgres=# select * from t1;
DEBUG: 00000: PX Failed: param polar_enable_px is off
LOCATION: should_px_planner, planner.c:7859
DEBUG: 00000: duckdb_fdw : sqliteGetForeignRelSize
LOCATION: sqliteGetForeignRelSize, duckdb_fdw.c:524
DEBUG: 00000: duckdb_fdw : sqliteGetForeignPaths
LOCATION: sqliteGetForeignPaths, duckdb_fdw.c:871
DEBUG: 00000: duckdb_fdw : sqliteGetForeignUpperPaths
LOCATION: sqliteGetForeignUpperPaths, duckdb_fdw.c:3923
DEBUG: 00000: duckdb_fdw : sqliteGetForeignPlan
LOCATION: sqliteGetForeignPlan, duckdb_fdw.c:1111
DEBUG: 00000: duckdb_fdw : sqliteBeginForeignScan
LOCATION: sqliteBeginForeignScan, duckdb_fdw.c:1413
DEBUG: 00000: starting remote transaction on connection 0x55ee4b994518
LOCATION: sqlite_begin_remote_xact, connection.c:326
DEBUG: 00000: duckdb_fdw do_sql_command BEGIN 0x55ee4b994518
LOCATION: sqlite_do_sql_command, connection.c:285
DEBUG: 00000: duckdb_fdw xact_callback 2
LOCATION: sqlitefdw_xact_callback, connection.c:394
ERROR: HV000: SQLite failed to execute sql: BEGIN
LOCATION: sqlite_do_sql_command, connection.c:306
detail info: https://github.com/digoal/blog/blob/master/202401/20240126_03.md
The text was updated successfully, but these errors were encountered: