1create table t1( 2 ts BIG INT, 3 dur BIG INT, 4 part BIG INT, 5 PRIMARY KEY (part, ts) 6) without rowid; 7 8create table t2( 9 ts BIG INT, 10 dur BIG INT, 11 part BIG INT, 12 PRIMARY KEY (part, ts) 13) without rowid; 14 15-- Insert a single row into t1. 16INSERT INTO t1(ts, dur, part) 17VALUES (500, 100, 10); 18 19-- Insert a single row into t2. 20INSERT INTO t2(ts, dur, part) 21VALUES (500, 100, 5); 22 23create virtual table sp using span_left_join(t1 PARTITIONED part, 24 t2 PARTITIONED part); 25 26select * from sp; 27