DUCKLAKE 实验

DuckDB v1.3.2 (Ossivalis) 0b83e5d2f6
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
D attach 'ducklake:D:/duckdb_cli/QhTestDuckLake001/QhTestDuckLake001.ducklake' as QhTestDuckLake001;
D
D use lake;
Catalog Error:
SET schema: No catalog + schema named "lake" found.
D use QhTestDuckLake001;
D create table QhTable001(name varchar,age integer)
路 ;
D insert into test values(
路
路
路 ；
路 ;
Parser Error:
syntax error at or near ";"

LINE 4: ；
        ^
D insert into test values(
路 ;
Parser Error:
syntax error at or near ";"

LINE 2: ;
        ^
D insert into test values('阙辉001',18)
路 ；
路 ;
Parser Error:
syntax error at or near "；"

LINE 1: insert into test values('阙辉001',18)
                                          ^
D insert into test values('阙辉001',18);
Catalog Error:
Table with name test does not exist!
Did you mean "sqlite_temp_master"?
D insert into  QhTable001 values('阙辉001',18);
D select * from QhTable001;
┌─────────┬───────┐
│  name   │  age  │
│ varchar │ int32 │
├─────────┼───────┤
│ 阙辉001 │  18   │
└─────────┴───────┘
D insert into  QhTable001 values('阙辉002',16);
D select * from QhTable001;
┌─────────┬───────┐
│  name   │  age  │
│ varchar │ int32 │
├─────────┼───────┤
│ 阙辉001 │    18 │
│ 阙辉002 │    16 │
└─────────┴───────┘
D update QhTable001 set age = 19 where name =
路 ;
Parser Error:
syntax error at or near ";"

LINE 2: ;
        ^
D update QhTable001 set age = 19 where name = '阙辉002';
D select * from QhTable001;
┌─────────┬───────┐
│  name   │  age  │
│ varchar │ int32 │
├─────────┼───────┤
│ 阙辉001 │    18 │
│ 阙辉002 │    19 │
└─────────┴───────┘
D from QhTestDuckLake001.snapshots();
┌─────────────┬────────────────────────────┬────────────────┬─────────────────────────────────────────────────────┐
│ snapshot_id │       snapshot_time        │ schema_version │                       changes                       │
│    int64    │  timestamp with time zone  │     int64      │               map(varchar, varchar[])               │
├─────────────┼────────────────────────────┼────────────────┼─────────────────────────────────────────────────────┤
│           0 │ 2025-09-15 20:36:38.335+08 │              0 │ {schemas_created=[main]}                            │
│           1 │ 2025-09-15 20:38:12.544+08 │              1 │ {tables_created=[main.QhTable001]}                  │
│           2 │ 2025-09-15 20:40:42.975+08 │              1 │ {tables_inserted_into=[1]}                          │
│           3 │ 2025-09-15 20:41:34.04+08  │              1 │ {tables_inserted_into=[1]}                          │
│           4 │ 2025-09-15 20:42:51.707+08 │              1 │ {tables_inserted_into=[1], tables_deleted_from=[1]} │
└─────────────┴────────────────────────────┴────────────────┴─────────────────────────────────────────────────────┘
D from QhTable001 at (version=>1)
路 ;
┌─────────┬───────┐
│  name   │  age  │
│ varchar │ int32 │
├─────────┴───────┤
│     0 rows      │
└─────────────────┘
D from QhTable001 at (version=>1);
┌─────────┬───────┐
│  name   │  age  │
│ varchar │ int32 │
├─────────┴───────┤
│     0 rows      │
└─────────────────┘
D from QhTable001 at (version=>2);
┌─────────┬───────┐
│  name   │  age  │
│ varchar │ int32 │
├─────────┼───────┤
│ 阙辉001 │  18   │
└─────────┴───────┘
D from QhTable001 at (version=>3);
┌─────────┬───────┐
│  name   │  age  │
│ varchar │ int32 │
├─────────┼───────┤
│ 阙辉001 │    18 │
│ 阙辉002 │    16 │
└─────────┴───────┘
D from QhTable001 at (version=>4);
┌─────────┬───────┐
│  name   │  age  │
│ varchar │ int32 │
├─────────┼───────┤
│ 阙辉001 │    18 │
│ 阙辉002 │    19 │
└─────────┴───────┘
D
D  create schema ods01;
D create table ods01.QhTablePer(name varchar,age integer);
D insert into ods01.QhTablePer values('quehui',20);
D  from ods01.QhTablePer;
┌─────────┬───────┐
│  name   │  age  │
│ varchar │ int32 │
├─────────┼───────┤
│ quehui  │  20   │
└─────────┴───────┘
D