1create table t1( 2 ts BIG INT, 3 dur BIG INT, 4 part BIG INT, 5 a BIG INT, 6 PRIMARY KEY (part, ts) 7) without rowid; 8 9create table t2( 10 ts BIG INT, 11 dur BIG INT, 12 b BIG INT, 13 PRIMARY KEY (ts) 14) without rowid; 15 16-- Then insert some rows into t1 in part 1, 3, 4 and 5. 17INSERT INTO t1(ts, dur, part, a) 18VALUES 19(100, 400, 1, 111), 20(500, 150, 1, 111), 21(500, 50, 3, 222), 22(500, 100, 4, 333), 23(0, 1000, 5, 444); 24 25-- Then insert some rows into t2. 26INSERT INTO t2(ts, dur, b) 27VALUES 28(50, 200, 111), 29(300, 100, 222), 30(400, 250, 333); 31 32create virtual table sp using span_left_join(t1 PARTITIONED part, t2); 33 34select * from sp; 35