/*
* This file is used to test the function of ExecVecHashJoin()---(2)
*/
----
--- Create Table and Insert Data
----
create schema vector_hashjoin_engine_second;
set current_schema to vector_hashjoin_engine_second;
-----
-----
\parallel on 4
create table vector_hashjoin_engine_second.ROW_HASHJOIN_TABLE_07
(
c_int int
,c_smallint smallint
,c3 char(100)
)distribute by hash(c_int);
create table vector_hashjoin_engine_second.ROW_HASHJOIN_TABLE_08
(
c_int int
,c_bigint bigint
,c3 char(100)
)distribute by hash(c_int);
create table vector_hashjoin_engine_second.vector_hashjoin_table_07
(
c_int int
,c_smallint smallint
,c3 char(100)
)with (orientation = column) distribute by hash(c_int);
create table vector_hashjoin_engine_second.vector_hashjoin_table_08
(
c_int int
,c_bigint bigint
,c3 char(100)
)with (orientation = column) distribute by hash(c_int);
\parallel off
\parallel on 8
--insert into ROW_HASHJOIN_TABLE_07 select generate_series(-2000,-1), generate_series(-2000,-1), 'vector_hashjoin_row'|| generate_series(1,2000);
copy ROW_HASHJOIN_TABLE_07 from '@abs_srcdir@/data/vec_hashjoin2_data1.txt' delimiter as ' ';
insert into ROW_HASHJOIN_TABLE_07 values(1,2,NULL);
insert into ROW_HASHJOIN_TABLE_07 values(NULL,-2,NULL);
insert into ROW_HASHJOIN_TABLE_07 values(-3,NULL,NULL);
--insert into ROW_HASHJOIN_TABLE_08 select generate_series(-2000,-1000), generate_series(-2000,-1000), 'vector_hashjoin_row'|| generate_series(1,1001);
copy ROW_HASHJOIN_TABLE_08 from '@abs_srcdir@/data/vec_hashjoin2_data1.txt' delimiter as ' ';
insert into ROW_HASHJOIN_TABLE_08 values(1,2,NULL);
insert into ROW_HASHJOIN_TABLE_08 values(NULL,-2,NULL);
insert into ROW_HASHJOIN_TABLE_08 values(-3,NULL,NULL);
\parallel off
\parallel on 5
insert into vector_hashjoin_engine_second.vector_hashjoin_table_07 select * from vector_hashjoin_engine_second.ROW_HASHJOIN_TABLE_07;
insert into vector_hashjoin_engine_second.vector_hashjoin_table_08 select * from vector_hashjoin_engine_second.ROW_HASHJOIN_TABLE_08;
insert into vector_hashjoin_engine_second.vector_hashjoin_table_07 select * from vector_hashjoin_engine_second.ROW_HASHJOIN_TABLE_07;
insert into vector_hashjoin_engine_second.vector_hashjoin_table_08 select * from vector_hashjoin_engine_second.ROW_HASHJOIN_TABLE_08;
insert into vector_hashjoin_engine_second.vector_hashjoin_table_08 select * from vector_hashjoin_engine_second.ROW_HASHJOIN_TABLE_08;
\parallel off
analyze vector_hashjoin_engine_second.vector_hashjoin_table_07;
analyze vector_hashjoin_engine_second.vector_hashjoin_table_08;
--select * from VECTOR_HASHJOIN_TABLE_07 A join VECTOR_HASHJOIN_TABLE_08 B on a.c_int=b.c_bigint order by 1,2,3,4,5,6 limit 100;
--select * from VECTOR_HASHJOIN_TABLE_07 A join VECTOR_HASHJOIN_TABLE_08 B on a.c_int=b.c_int and a.c_smallint=b.c_bigint order by 1,2,3,4,5,6 limit 100;
--select * from VECTOR_HASHJOIN_TABLE_07 A join VECTOR_HASHJOIN_TABLE_08 B on a.c_int=b.c_int +1 order by 1,2,3,4,5,6 limit 50;
--select * from VECTOR_HASHJOIN_TABLE_07 A right join VECTOR_HASHJOIN_TABLE_08 B on a.c_smallint=b.c_int order by 1,2,3,4,5,6 limit 100;
--select * from VECTOR_HASHJOIN_TABLE_07 A right join VECTOR_HASHJOIN_TABLE_08 B on substring(A.c3, 2) = substring(B.c3, 2) order by 1,2,3,4,5,6 limit 50;
--select * from VECTOR_HASHJOIN_TABLE_07 A right join VECTOR_HASHJOIN_TABLE_08 B on substring(A.c3, 2) = substring(B.c3, 2) and a.c_smallint=b.c_bigint order by 1,2,3,4,5,6 limit 50;
set work_mem=64;
set query_dop = 1;
set enable_compress_spill = on;
select * from VECTOR_HASHJOIN_TABLE_07 A join VECTOR_HASHJOIN_TABLE_08 B on a.c_int=b.c_bigint order by 1,2,3,4,5,6 limit 100;
c_int | c_smallint | c3 | c_int | c_bigint | c3
-------+------------+------------------------------------------------------------------------------------------------------+-------+----------+------------------------------------------------------------------------------------------------------
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1992 | -1992 | vector_hashjoin_row9 | -1992 | -1992 | vector_hashjoin_row9
-1992 | -1992 | vector_hashjoin_row9 | -1992 | -1992 | vector_hashjoin_row9
-1992 | -1992 | vector_hashjoin_row9 | -1992 | -1992 | vector_hashjoin_row9
-1992 | -1992 | vector_hashjoin_row9 | -1992 | -1992 | vector_hashjoin_row9
-1992 | -1992 | vector_hashjoin_row9 | -1992 | -1992 | vector_hashjoin_row9
-1992 | -1992 | vector_hashjoin_row9 | -1992 | -1992 | vector_hashjoin_row9
-1991 | -1991 | vector_hashjoin_row10 | -1991 | -1991 | vector_hashjoin_row10
-1991 | -1991 | vector_hashjoin_row10 | -1991 | -1991 | vector_hashjoin_row10
-1991 | -1991 | vector_hashjoin_row10 | -1991 | -1991 | vector_hashjoin_row10
-1991 | -1991 | vector_hashjoin_row10 | -1991 | -1991 | vector_hashjoin_row10
-1991 | -1991 | vector_hashjoin_row10 | -1991 | -1991 | vector_hashjoin_row10
-1991 | -1991 | vector_hashjoin_row10 | -1991 | -1991 | vector_hashjoin_row10
-1990 | -1990 | vector_hashjoin_row11 | -1990 | -1990 | vector_hashjoin_row11
-1990 | -1990 | vector_hashjoin_row11 | -1990 | -1990 | vector_hashjoin_row11
-1990 | -1990 | vector_hashjoin_row11 | -1990 | -1990 | vector_hashjoin_row11
-1990 | -1990 | vector_hashjoin_row11 | -1990 | -1990 | vector_hashjoin_row11
-1990 | -1990 | vector_hashjoin_row11 | -1990 | -1990 | vector_hashjoin_row11
-1990 | -1990 | vector_hashjoin_row11 | -1990 | -1990 | vector_hashjoin_row11
-1989 | -1989 | vector_hashjoin_row12 | -1989 | -1989 | vector_hashjoin_row12
-1989 | -1989 | vector_hashjoin_row12 | -1989 | -1989 | vector_hashjoin_row12
-1989 | -1989 | vector_hashjoin_row12 | -1989 | -1989 | vector_hashjoin_row12
-1989 | -1989 | vector_hashjoin_row12 | -1989 | -1989 | vector_hashjoin_row12
-1989 | -1989 | vector_hashjoin_row12 | -1989 | -1989 | vector_hashjoin_row12
-1989 | -1989 | vector_hashjoin_row12 | -1989 | -1989 | vector_hashjoin_row12
-1988 | -1988 | vector_hashjoin_row13 | -1988 | -1988 | vector_hashjoin_row13
-1988 | -1988 | vector_hashjoin_row13 | -1988 | -1988 | vector_hashjoin_row13
-1988 | -1988 | vector_hashjoin_row13 | -1988 | -1988 | vector_hashjoin_row13
-1988 | -1988 | vector_hashjoin_row13 | -1988 | -1988 | vector_hashjoin_row13
-1988 | -1988 | vector_hashjoin_row13 | -1988 | -1988 | vector_hashjoin_row13
-1988 | -1988 | vector_hashjoin_row13 | -1988 | -1988 | vector_hashjoin_row13
-1987 | -1987 | vector_hashjoin_row14 | -1987 | -1987 | vector_hashjoin_row14
-1987 | -1987 | vector_hashjoin_row14 | -1987 | -1987 | vector_hashjoin_row14
-1987 | -1987 | vector_hashjoin_row14 | -1987 | -1987 | vector_hashjoin_row14
-1987 | -1987 | vector_hashjoin_row14 | -1987 | -1987 | vector_hashjoin_row14
-1987 | -1987 | vector_hashjoin_row14 | -1987 | -1987 | vector_hashjoin_row14
-1987 | -1987 | vector_hashjoin_row14 | -1987 | -1987 | vector_hashjoin_row14
-1986 | -1986 | vector_hashjoin_row15 | -1986 | -1986 | vector_hashjoin_row15
-1986 | -1986 | vector_hashjoin_row15 | -1986 | -1986 | vector_hashjoin_row15
-1986 | -1986 | vector_hashjoin_row15 | -1986 | -1986 | vector_hashjoin_row15
-1986 | -1986 | vector_hashjoin_row15 | -1986 | -1986 | vector_hashjoin_row15
-1986 | -1986 | vector_hashjoin_row15 | -1986 | -1986 | vector_hashjoin_row15
-1986 | -1986 | vector_hashjoin_row15 | -1986 | -1986 | vector_hashjoin_row15
-1985 | -1985 | vector_hashjoin_row16 | -1985 | -1985 | vector_hashjoin_row16
-1985 | -1985 | vector_hashjoin_row16 | -1985 | -1985 | vector_hashjoin_row16
-1985 | -1985 | vector_hashjoin_row16 | -1985 | -1985 | vector_hashjoin_row16
-1985 | -1985 | vector_hashjoin_row16 | -1985 | -1985 | vector_hashjoin_row16
-1985 | -1985 | vector_hashjoin_row16 | -1985 | -1985 | vector_hashjoin_row16
-1985 | -1985 | vector_hashjoin_row16 | -1985 | -1985 | vector_hashjoin_row16
-1984 | -1984 | vector_hashjoin_row17 | -1984 | -1984 | vector_hashjoin_row17
-1984 | -1984 | vector_hashjoin_row17 | -1984 | -1984 | vector_hashjoin_row17
-1984 | -1984 | vector_hashjoin_row17 | -1984 | -1984 | vector_hashjoin_row17
-1984 | -1984 | vector_hashjoin_row17 | -1984 | -1984 | vector_hashjoin_row17
(100 rows)
select * from VECTOR_HASHJOIN_TABLE_07 A join VECTOR_HASHJOIN_TABLE_08 B on a.c_int=b.c_int and a.c_smallint=b.c_bigint order by 1,2,3,4,5,6 limit 100;
c_int | c_smallint | c3 | c_int | c_bigint | c3
-------+------------+------------------------------------------------------------------------------------------------------+-------+----------+------------------------------------------------------------------------------------------------------
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1992 | -1992 | vector_hashjoin_row9 | -1992 | -1992 | vector_hashjoin_row9
-1992 | -1992 | vector_hashjoin_row9 | -1992 | -1992 | vector_hashjoin_row9
-1992 | -1992 | vector_hashjoin_row9 | -1992 | -1992 | vector_hashjoin_row9
-1992 | -1992 | vector_hashjoin_row9 | -1992 | -1992 | vector_hashjoin_row9
-1992 | -1992 | vector_hashjoin_row9 | -1992 | -1992 | vector_hashjoin_row9
-1992 | -1992 | vector_hashjoin_row9 | -1992 | -1992 | vector_hashjoin_row9
-1991 | -1991 | vector_hashjoin_row10 | -1991 | -1991 | vector_hashjoin_row10
-1991 | -1991 | vector_hashjoin_row10 | -1991 | -1991 | vector_hashjoin_row10
-1991 | -1991 | vector_hashjoin_row10 | -1991 | -1991 | vector_hashjoin_row10
-1991 | -1991 | vector_hashjoin_row10 | -1991 | -1991 | vector_hashjoin_row10
-1991 | -1991 | vector_hashjoin_row10 | -1991 | -1991 | vector_hashjoin_row10
-1991 | -1991 | vector_hashjoin_row10 | -1991 | -1991 | vector_hashjoin_row10
-1990 | -1990 | vector_hashjoin_row11 | -1990 | -1990 | vector_hashjoin_row11
-1990 | -1990 | vector_hashjoin_row11 | -1990 | -1990 | vector_hashjoin_row11
-1990 | -1990 | vector_hashjoin_row11 | -1990 | -1990 | vector_hashjoin_row11
-1990 | -1990 | vector_hashjoin_row11 | -1990 | -1990 | vector_hashjoin_row11
-1990 | -1990 | vector_hashjoin_row11 | -1990 | -1990 | vector_hashjoin_row11
-1990 | -1990 | vector_hashjoin_row11 | -1990 | -1990 | vector_hashjoin_row11
-1989 | -1989 | vector_hashjoin_row12 | -1989 | -1989 | vector_hashjoin_row12
-1989 | -1989 | vector_hashjoin_row12 | -1989 | -1989 | vector_hashjoin_row12
-1989 | -1989 | vector_hashjoin_row12 | -1989 | -1989 | vector_hashjoin_row12
-1989 | -1989 | vector_hashjoin_row12 | -1989 | -1989 | vector_hashjoin_row12
-1989 | -1989 | vector_hashjoin_row12 | -1989 | -1989 | vector_hashjoin_row12
-1989 | -1989 | vector_hashjoin_row12 | -1989 | -1989 | vector_hashjoin_row12
-1988 | -1988 | vector_hashjoin_row13 | -1988 | -1988 | vector_hashjoin_row13
-1988 | -1988 | vector_hashjoin_row13 | -1988 | -1988 | vector_hashjoin_row13
-1988 | -1988 | vector_hashjoin_row13 | -1988 | -1988 | vector_hashjoin_row13
-1988 | -1988 | vector_hashjoin_row13 | -1988 | -1988 | vector_hashjoin_row13
-1988 | -1988 | vector_hashjoin_row13 | -1988 | -1988 | vector_hashjoin_row13
-1988 | -1988 | vector_hashjoin_row13 | -1988 | -1988 | vector_hashjoin_row13
-1987 | -1987 | vector_hashjoin_row14 | -1987 | -1987 | vector_hashjoin_row14
-1987 | -1987 | vector_hashjoin_row14 | -1987 | -1987 | vector_hashjoin_row14
-1987 | -1987 | vector_hashjoin_row14 | -1987 | -1987 | vector_hashjoin_row14
-1987 | -1987 | vector_hashjoin_row14 | -1987 | -1987 | vector_hashjoin_row14
-1987 | -1987 | vector_hashjoin_row14 | -1987 | -1987 | vector_hashjoin_row14
-1987 | -1987 | vector_hashjoin_row14 | -1987 | -1987 | vector_hashjoin_row14
-1986 | -1986 | vector_hashjoin_row15 | -1986 | -1986 | vector_hashjoin_row15
-1986 | -1986 | vector_hashjoin_row15 | -1986 | -1986 | vector_hashjoin_row15
-1986 | -1986 | vector_hashjoin_row15 | -1986 | -1986 | vector_hashjoin_row15
-1986 | -1986 | vector_hashjoin_row15 | -1986 | -1986 | vector_hashjoin_row15
-1986 | -1986 | vector_hashjoin_row15 | -1986 | -1986 | vector_hashjoin_row15
-1986 | -1986 | vector_hashjoin_row15 | -1986 | -1986 | vector_hashjoin_row15
-1985 | -1985 | vector_hashjoin_row16 | -1985 | -1985 | vector_hashjoin_row16
-1985 | -1985 | vector_hashjoin_row16 | -1985 | -1985 | vector_hashjoin_row16
-1985 | -1985 | vector_hashjoin_row16 | -1985 | -1985 | vector_hashjoin_row16
-1985 | -1985 | vector_hashjoin_row16 | -1985 | -1985 | vector_hashjoin_row16
-1985 | -1985 | vector_hashjoin_row16 | -1985 | -1985 | vector_hashjoin_row16
-1985 | -1985 | vector_hashjoin_row16 | -1985 | -1985 | vector_hashjoin_row16
-1984 | -1984 | vector_hashjoin_row17 | -1984 | -1984 | vector_hashjoin_row17
-1984 | -1984 | vector_hashjoin_row17 | -1984 | -1984 | vector_hashjoin_row17
-1984 | -1984 | vector_hashjoin_row17 | -1984 | -1984 | vector_hashjoin_row17
-1984 | -1984 | vector_hashjoin_row17 | -1984 | -1984 | vector_hashjoin_row17
(100 rows)
select * from VECTOR_HASHJOIN_TABLE_07 A join VECTOR_HASHJOIN_TABLE_08 B on a.c_int=b.c_int +1 order by 1,2,3,4,5,6 limit 50;
c_int | c_smallint | c3 | c_int | c_bigint | c3
-------+------------+------------------------------------------------------------------------------------------------------+-------+----------+------------------------------------------------------------------------------------------------------
-1999 | -1999 | vector_hashjoin_row2 | -2000 | -2000 | vector_hashjoin_row1
-1999 | -1999 | vector_hashjoin_row2 | -2000 | -2000 | vector_hashjoin_row1
-1999 | -1999 | vector_hashjoin_row2 | -2000 | -2000 | vector_hashjoin_row1
-1999 | -1999 | vector_hashjoin_row2 | -2000 | -2000 | vector_hashjoin_row1
-1999 | -1999 | vector_hashjoin_row2 | -2000 | -2000 | vector_hashjoin_row1
-1999 | -1999 | vector_hashjoin_row2 | -2000 | -2000 | vector_hashjoin_row1
-1998 | -1998 | vector_hashjoin_row3 | -1999 | -1999 | vector_hashjoin_row2
-1998 | -1998 | vector_hashjoin_row3 | -1999 | -1999 | vector_hashjoin_row2
-1998 | -1998 | vector_hashjoin_row3 | -1999 | -1999 | vector_hashjoin_row2
-1998 | -1998 | vector_hashjoin_row3 | -1999 | -1999 | vector_hashjoin_row2
-1998 | -1998 | vector_hashjoin_row3 | -1999 | -1999 | vector_hashjoin_row2
-1998 | -1998 | vector_hashjoin_row3 | -1999 | -1999 | vector_hashjoin_row2
-1997 | -1997 | vector_hashjoin_row4 | -1998 | -1998 | vector_hashjoin_row3
-1997 | -1997 | vector_hashjoin_row4 | -1998 | -1998 | vector_hashjoin_row3
-1997 | -1997 | vector_hashjoin_row4 | -1998 | -1998 | vector_hashjoin_row3
-1997 | -1997 | vector_hashjoin_row4 | -1998 | -1998 | vector_hashjoin_row3
-1997 | -1997 | vector_hashjoin_row4 | -1998 | -1998 | vector_hashjoin_row3
-1997 | -1997 | vector_hashjoin_row4 | -1998 | -1998 | vector_hashjoin_row3
-1996 | -1996 | vector_hashjoin_row5 | -1997 | -1997 | vector_hashjoin_row4
-1996 | -1996 | vector_hashjoin_row5 | -1997 | -1997 | vector_hashjoin_row4
-1996 | -1996 | vector_hashjoin_row5 | -1997 | -1997 | vector_hashjoin_row4
-1996 | -1996 | vector_hashjoin_row5 | -1997 | -1997 | vector_hashjoin_row4
-1996 | -1996 | vector_hashjoin_row5 | -1997 | -1997 | vector_hashjoin_row4
-1996 | -1996 | vector_hashjoin_row5 | -1997 | -1997 | vector_hashjoin_row4
-1995 | -1995 | vector_hashjoin_row6 | -1996 | -1996 | vector_hashjoin_row5
-1995 | -1995 | vector_hashjoin_row6 | -1996 | -1996 | vector_hashjoin_row5
-1995 | -1995 | vector_hashjoin_row6 | -1996 | -1996 | vector_hashjoin_row5
-1995 | -1995 | vector_hashjoin_row6 | -1996 | -1996 | vector_hashjoin_row5
-1995 | -1995 | vector_hashjoin_row6 | -1996 | -1996 | vector_hashjoin_row5
-1995 | -1995 | vector_hashjoin_row6 | -1996 | -1996 | vector_hashjoin_row5
-1994 | -1994 | vector_hashjoin_row7 | -1995 | -1995 | vector_hashjoin_row6
-1994 | -1994 | vector_hashjoin_row7 | -1995 | -1995 | vector_hashjoin_row6
-1994 | -1994 | vector_hashjoin_row7 | -1995 | -1995 | vector_hashjoin_row6
-1994 | -1994 | vector_hashjoin_row7 | -1995 | -1995 | vector_hashjoin_row6
-1994 | -1994 | vector_hashjoin_row7 | -1995 | -1995 | vector_hashjoin_row6
-1994 | -1994 | vector_hashjoin_row7 | -1995 | -1995 | vector_hashjoin_row6
-1993 | -1993 | vector_hashjoin_row8 | -1994 | -1994 | vector_hashjoin_row7
-1993 | -1993 | vector_hashjoin_row8 | -1994 | -1994 | vector_hashjoin_row7
-1993 | -1993 | vector_hashjoin_row8 | -1994 | -1994 | vector_hashjoin_row7
-1993 | -1993 | vector_hashjoin_row8 | -1994 | -1994 | vector_hashjoin_row7
-1993 | -1993 | vector_hashjoin_row8 | -1994 | -1994 | vector_hashjoin_row7
-1993 | -1993 | vector_hashjoin_row8 | -1994 | -1994 | vector_hashjoin_row7
-1992 | -1992 | vector_hashjoin_row9 | -1993 | -1993 | vector_hashjoin_row8
-1992 | -1992 | vector_hashjoin_row9 | -1993 | -1993 | vector_hashjoin_row8
-1992 | -1992 | vector_hashjoin_row9 | -1993 | -1993 | vector_hashjoin_row8
-1992 | -1992 | vector_hashjoin_row9 | -1993 | -1993 | vector_hashjoin_row8
-1992 | -1992 | vector_hashjoin_row9 | -1993 | -1993 | vector_hashjoin_row8
-1992 | -1992 | vector_hashjoin_row9 | -1993 | -1993 | vector_hashjoin_row8
-1991 | -1991 | vector_hashjoin_row10 | -1992 | -1992 | vector_hashjoin_row9
-1991 | -1991 | vector_hashjoin_row10 | -1992 | -1992 | vector_hashjoin_row9
(50 rows)
select * from VECTOR_HASHJOIN_TABLE_07 A right join VECTOR_HASHJOIN_TABLE_08 B on a.c_smallint=b.c_int order by 1,2,3,4,5,6 limit 100;
c_int | c_smallint | c3 | c_int | c_bigint | c3
-------+------------+------------------------------------------------------------------------------------------------------+-------+----------+------------------------------------------------------------------------------------------------------
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1992 | -1992 | vector_hashjoin_row9 | -1992 | -1992 | vector_hashjoin_row9
-1992 | -1992 | vector_hashjoin_row9 | -1992 | -1992 | vector_hashjoin_row9
-1992 | -1992 | vector_hashjoin_row9 | -1992 | -1992 | vector_hashjoin_row9
-1992 | -1992 | vector_hashjoin_row9 | -1992 | -1992 | vector_hashjoin_row9
-1992 | -1992 | vector_hashjoin_row9 | -1992 | -1992 | vector_hashjoin_row9
-1992 | -1992 | vector_hashjoin_row9 | -1992 | -1992 | vector_hashjoin_row9
-1991 | -1991 | vector_hashjoin_row10 | -1991 | -1991 | vector_hashjoin_row10
-1991 | -1991 | vector_hashjoin_row10 | -1991 | -1991 | vector_hashjoin_row10
-1991 | -1991 | vector_hashjoin_row10 | -1991 | -1991 | vector_hashjoin_row10
-1991 | -1991 | vector_hashjoin_row10 | -1991 | -1991 | vector_hashjoin_row10
-1991 | -1991 | vector_hashjoin_row10 | -1991 | -1991 | vector_hashjoin_row10
-1991 | -1991 | vector_hashjoin_row10 | -1991 | -1991 | vector_hashjoin_row10
-1990 | -1990 | vector_hashjoin_row11 | -1990 | -1990 | vector_hashjoin_row11
-1990 | -1990 | vector_hashjoin_row11 | -1990 | -1990 | vector_hashjoin_row11
-1990 | -1990 | vector_hashjoin_row11 | -1990 | -1990 | vector_hashjoin_row11
-1990 | -1990 | vector_hashjoin_row11 | -1990 | -1990 | vector_hashjoin_row11
-1990 | -1990 | vector_hashjoin_row11 | -1990 | -1990 | vector_hashjoin_row11
-1990 | -1990 | vector_hashjoin_row11 | -1990 | -1990 | vector_hashjoin_row11
-1989 | -1989 | vector_hashjoin_row12 | -1989 | -1989 | vector_hashjoin_row12
-1989 | -1989 | vector_hashjoin_row12 | -1989 | -1989 | vector_hashjoin_row12
-1989 | -1989 | vector_hashjoin_row12 | -1989 | -1989 | vector_hashjoin_row12
-1989 | -1989 | vector_hashjoin_row12 | -1989 | -1989 | vector_hashjoin_row12
-1989 | -1989 | vector_hashjoin_row12 | -1989 | -1989 | vector_hashjoin_row12
-1989 | -1989 | vector_hashjoin_row12 | -1989 | -1989 | vector_hashjoin_row12
-1988 | -1988 | vector_hashjoin_row13 | -1988 | -1988 | vector_hashjoin_row13
-1988 | -1988 | vector_hashjoin_row13 | -1988 | -1988 | vector_hashjoin_row13
-1988 | -1988 | vector_hashjoin_row13 | -1988 | -1988 | vector_hashjoin_row13
-1988 | -1988 | vector_hashjoin_row13 | -1988 | -1988 | vector_hashjoin_row13
-1988 | -1988 | vector_hashjoin_row13 | -1988 | -1988 | vector_hashjoin_row13
-1988 | -1988 | vector_hashjoin_row13 | -1988 | -1988 | vector_hashjoin_row13
-1987 | -1987 | vector_hashjoin_row14 | -1987 | -1987 | vector_hashjoin_row14
-1987 | -1987 | vector_hashjoin_row14 | -1987 | -1987 | vector_hashjoin_row14
-1987 | -1987 | vector_hashjoin_row14 | -1987 | -1987 | vector_hashjoin_row14
-1987 | -1987 | vector_hashjoin_row14 | -1987 | -1987 | vector_hashjoin_row14
-1987 | -1987 | vector_hashjoin_row14 | -1987 | -1987 | vector_hashjoin_row14
-1987 | -1987 | vector_hashjoin_row14 | -1987 | -1987 | vector_hashjoin_row14
-1986 | -1986 | vector_hashjoin_row15 | -1986 | -1986 | vector_hashjoin_row15
-1986 | -1986 | vector_hashjoin_row15 | -1986 | -1986 | vector_hashjoin_row15
-1986 | -1986 | vector_hashjoin_row15 | -1986 | -1986 | vector_hashjoin_row15
-1986 | -1986 | vector_hashjoin_row15 | -1986 | -1986 | vector_hashjoin_row15
-1986 | -1986 | vector_hashjoin_row15 | -1986 | -1986 | vector_hashjoin_row15
-1986 | -1986 | vector_hashjoin_row15 | -1986 | -1986 | vector_hashjoin_row15
-1985 | -1985 | vector_hashjoin_row16 | -1985 | -1985 | vector_hashjoin_row16
-1985 | -1985 | vector_hashjoin_row16 | -1985 | -1985 | vector_hashjoin_row16
-1985 | -1985 | vector_hashjoin_row16 | -1985 | -1985 | vector_hashjoin_row16
-1985 | -1985 | vector_hashjoin_row16 | -1985 | -1985 | vector_hashjoin_row16
-1985 | -1985 | vector_hashjoin_row16 | -1985 | -1985 | vector_hashjoin_row16
-1985 | -1985 | vector_hashjoin_row16 | -1985 | -1985 | vector_hashjoin_row16
-1984 | -1984 | vector_hashjoin_row17 | -1984 | -1984 | vector_hashjoin_row17
-1984 | -1984 | vector_hashjoin_row17 | -1984 | -1984 | vector_hashjoin_row17
-1984 | -1984 | vector_hashjoin_row17 | -1984 | -1984 | vector_hashjoin_row17
-1984 | -1984 | vector_hashjoin_row17 | -1984 | -1984 | vector_hashjoin_row17
(100 rows)
select * from VECTOR_HASHJOIN_TABLE_07 A right join VECTOR_HASHJOIN_TABLE_08 B on substring(A.c3, 2) = substring(B.c3, 2) order by 1,2,3,4,5,6 limit 50;
c_int | c_smallint | c3 | c_int | c_bigint | c3
-------+------------+------------------------------------------------------------------------------------------------------+-------+----------+------------------------------------------------------------------------------------------------------
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1992 | -1992 | vector_hashjoin_row9 | -1992 | -1992 | vector_hashjoin_row9
-1992 | -1992 | vector_hashjoin_row9 | -1992 | -1992 | vector_hashjoin_row9
(50 rows)
select * from VECTOR_HASHJOIN_TABLE_07 A right join VECTOR_HASHJOIN_TABLE_08 B on substring(A.c3, 2) = substring(B.c3, 2) and a.c_smallint=b.c_bigint order by 1,2,3,4,5,6 limit 50;
c_int | c_smallint | c3 | c_int | c_bigint | c3
-------+------------+------------------------------------------------------------------------------------------------------+-------+----------+------------------------------------------------------------------------------------------------------
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1992 | -1992 | vector_hashjoin_row9 | -1992 | -1992 | vector_hashjoin_row9
-1992 | -1992 | vector_hashjoin_row9 | -1992 | -1992 | vector_hashjoin_row9
(50 rows)
set enable_compress_spill = off;
select * from VECTOR_HASHJOIN_TABLE_07 A join VECTOR_HASHJOIN_TABLE_08 B on a.c_int=b.c_bigint order by 1,2,3,4,5,6 limit 100;
c_int | c_smallint | c3 | c_int | c_bigint | c3
-------+------------+------------------------------------------------------------------------------------------------------+-------+----------+------------------------------------------------------------------------------------------------------
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1992 | -1992 | vector_hashjoin_row9 | -1992 | -1992 | vector_hashjoin_row9
-1992 | -1992 | vector_hashjoin_row9 | -1992 | -1992 | vector_hashjoin_row9
-1992 | -1992 | vector_hashjoin_row9 | -1992 | -1992 | vector_hashjoin_row9
-1992 | -1992 | vector_hashjoin_row9 | -1992 | -1992 | vector_hashjoin_row9
-1992 | -1992 | vector_hashjoin_row9 | -1992 | -1992 | vector_hashjoin_row9
-1992 | -1992 | vector_hashjoin_row9 | -1992 | -1992 | vector_hashjoin_row9
-1991 | -1991 | vector_hashjoin_row10 | -1991 | -1991 | vector_hashjoin_row10
-1991 | -1991 | vector_hashjoin_row10 | -1991 | -1991 | vector_hashjoin_row10
-1991 | -1991 | vector_hashjoin_row10 | -1991 | -1991 | vector_hashjoin_row10
-1991 | -1991 | vector_hashjoin_row10 | -1991 | -1991 | vector_hashjoin_row10
-1991 | -1991 | vector_hashjoin_row10 | -1991 | -1991 | vector_hashjoin_row10
-1991 | -1991 | vector_hashjoin_row10 | -1991 | -1991 | vector_hashjoin_row10
-1990 | -1990 | vector_hashjoin_row11 | -1990 | -1990 | vector_hashjoin_row11
-1990 | -1990 | vector_hashjoin_row11 | -1990 | -1990 | vector_hashjoin_row11
-1990 | -1990 | vector_hashjoin_row11 | -1990 | -1990 | vector_hashjoin_row11
-1990 | -1990 | vector_hashjoin_row11 | -1990 | -1990 | vector_hashjoin_row11
-1990 | -1990 | vector_hashjoin_row11 | -1990 | -1990 | vector_hashjoin_row11
-1990 | -1990 | vector_hashjoin_row11 | -1990 | -1990 | vector_hashjoin_row11
-1989 | -1989 | vector_hashjoin_row12 | -1989 | -1989 | vector_hashjoin_row12
-1989 | -1989 | vector_hashjoin_row12 | -1989 | -1989 | vector_hashjoin_row12
-1989 | -1989 | vector_hashjoin_row12 | -1989 | -1989 | vector_hashjoin_row12
-1989 | -1989 | vector_hashjoin_row12 | -1989 | -1989 | vector_hashjoin_row12
-1989 | -1989 | vector_hashjoin_row12 | -1989 | -1989 | vector_hashjoin_row12
-1989 | -1989 | vector_hashjoin_row12 | -1989 | -1989 | vector_hashjoin_row12
-1988 | -1988 | vector_hashjoin_row13 | -1988 | -1988 | vector_hashjoin_row13
-1988 | -1988 | vector_hashjoin_row13 | -1988 | -1988 | vector_hashjoin_row13
-1988 | -1988 | vector_hashjoin_row13 | -1988 | -1988 | vector_hashjoin_row13
-1988 | -1988 | vector_hashjoin_row13 | -1988 | -1988 | vector_hashjoin_row13
-1988 | -1988 | vector_hashjoin_row13 | -1988 | -1988 | vector_hashjoin_row13
-1988 | -1988 | vector_hashjoin_row13 | -1988 | -1988 | vector_hashjoin_row13
-1987 | -1987 | vector_hashjoin_row14 | -1987 | -1987 | vector_hashjoin_row14
-1987 | -1987 | vector_hashjoin_row14 | -1987 | -1987 | vector_hashjoin_row14
-1987 | -1987 | vector_hashjoin_row14 | -1987 | -1987 | vector_hashjoin_row14
-1987 | -1987 | vector_hashjoin_row14 | -1987 | -1987 | vector_hashjoin_row14
-1987 | -1987 | vector_hashjoin_row14 | -1987 | -1987 | vector_hashjoin_row14
-1987 | -1987 | vector_hashjoin_row14 | -1987 | -1987 | vector_hashjoin_row14
-1986 | -1986 | vector_hashjoin_row15 | -1986 | -1986 | vector_hashjoin_row15
-1986 | -1986 | vector_hashjoin_row15 | -1986 | -1986 | vector_hashjoin_row15
-1986 | -1986 | vector_hashjoin_row15 | -1986 | -1986 | vector_hashjoin_row15
-1986 | -1986 | vector_hashjoin_row15 | -1986 | -1986 | vector_hashjoin_row15
-1986 | -1986 | vector_hashjoin_row15 | -1986 | -1986 | vector_hashjoin_row15
-1986 | -1986 | vector_hashjoin_row15 | -1986 | -1986 | vector_hashjoin_row15
-1985 | -1985 | vector_hashjoin_row16 | -1985 | -1985 | vector_hashjoin_row16
-1985 | -1985 | vector_hashjoin_row16 | -1985 | -1985 | vector_hashjoin_row16
-1985 | -1985 | vector_hashjoin_row16 | -1985 | -1985 | vector_hashjoin_row16
-1985 | -1985 | vector_hashjoin_row16 | -1985 | -1985 | vector_hashjoin_row16
-1985 | -1985 | vector_hashjoin_row16 | -1985 | -1985 | vector_hashjoin_row16
-1985 | -1985 | vector_hashjoin_row16 | -1985 | -1985 | vector_hashjoin_row16
-1984 | -1984 | vector_hashjoin_row17 | -1984 | -1984 | vector_hashjoin_row17
-1984 | -1984 | vector_hashjoin_row17 | -1984 | -1984 | vector_hashjoin_row17
-1984 | -1984 | vector_hashjoin_row17 | -1984 | -1984 | vector_hashjoin_row17
-1984 | -1984 | vector_hashjoin_row17 | -1984 | -1984 | vector_hashjoin_row17
(100 rows)
select * from VECTOR_HASHJOIN_TABLE_07 A join VECTOR_HASHJOIN_TABLE_08 B on a.c_int=b.c_int and a.c_smallint=b.c_bigint order by 1,2,3,4,5,6 limit 100;
c_int | c_smallint | c3 | c_int | c_bigint | c3
-------+------------+------------------------------------------------------------------------------------------------------+-------+----------+------------------------------------------------------------------------------------------------------
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1992 | -1992 | vector_hashjoin_row9 | -1992 | -1992 | vector_hashjoin_row9
-1992 | -1992 | vector_hashjoin_row9 | -1992 | -1992 | vector_hashjoin_row9
-1992 | -1992 | vector_hashjoin_row9 | -1992 | -1992 | vector_hashjoin_row9
-1992 | -1992 | vector_hashjoin_row9 | -1992 | -1992 | vector_hashjoin_row9
-1992 | -1992 | vector_hashjoin_row9 | -1992 | -1992 | vector_hashjoin_row9
-1992 | -1992 | vector_hashjoin_row9 | -1992 | -1992 | vector_hashjoin_row9
-1991 | -1991 | vector_hashjoin_row10 | -1991 | -1991 | vector_hashjoin_row10
-1991 | -1991 | vector_hashjoin_row10 | -1991 | -1991 | vector_hashjoin_row10
-1991 | -1991 | vector_hashjoin_row10 | -1991 | -1991 | vector_hashjoin_row10
-1991 | -1991 | vector_hashjoin_row10 | -1991 | -1991 | vector_hashjoin_row10
-1991 | -1991 | vector_hashjoin_row10 | -1991 | -1991 | vector_hashjoin_row10
-1991 | -1991 | vector_hashjoin_row10 | -1991 | -1991 | vector_hashjoin_row10
-1990 | -1990 | vector_hashjoin_row11 | -1990 | -1990 | vector_hashjoin_row11
-1990 | -1990 | vector_hashjoin_row11 | -1990 | -1990 | vector_hashjoin_row11
-1990 | -1990 | vector_hashjoin_row11 | -1990 | -1990 | vector_hashjoin_row11
-1990 | -1990 | vector_hashjoin_row11 | -1990 | -1990 | vector_hashjoin_row11
-1990 | -1990 | vector_hashjoin_row11 | -1990 | -1990 | vector_hashjoin_row11
-1990 | -1990 | vector_hashjoin_row11 | -1990 | -1990 | vector_hashjoin_row11
-1989 | -1989 | vector_hashjoin_row12 | -1989 | -1989 | vector_hashjoin_row12
-1989 | -1989 | vector_hashjoin_row12 | -1989 | -1989 | vector_hashjoin_row12
-1989 | -1989 | vector_hashjoin_row12 | -1989 | -1989 | vector_hashjoin_row12
-1989 | -1989 | vector_hashjoin_row12 | -1989 | -1989 | vector_hashjoin_row12
-1989 | -1989 | vector_hashjoin_row12 | -1989 | -1989 | vector_hashjoin_row12
-1989 | -1989 | vector_hashjoin_row12 | -1989 | -1989 | vector_hashjoin_row12
-1988 | -1988 | vector_hashjoin_row13 | -1988 | -1988 | vector_hashjoin_row13
-1988 | -1988 | vector_hashjoin_row13 | -1988 | -1988 | vector_hashjoin_row13
-1988 | -1988 | vector_hashjoin_row13 | -1988 | -1988 | vector_hashjoin_row13
-1988 | -1988 | vector_hashjoin_row13 | -1988 | -1988 | vector_hashjoin_row13
-1988 | -1988 | vector_hashjoin_row13 | -1988 | -1988 | vector_hashjoin_row13
-1988 | -1988 | vector_hashjoin_row13 | -1988 | -1988 | vector_hashjoin_row13
-1987 | -1987 | vector_hashjoin_row14 | -1987 | -1987 | vector_hashjoin_row14
-1987 | -1987 | vector_hashjoin_row14 | -1987 | -1987 | vector_hashjoin_row14
-1987 | -1987 | vector_hashjoin_row14 | -1987 | -1987 | vector_hashjoin_row14
-1987 | -1987 | vector_hashjoin_row14 | -1987 | -1987 | vector_hashjoin_row14
-1987 | -1987 | vector_hashjoin_row14 | -1987 | -1987 | vector_hashjoin_row14
-1987 | -1987 | vector_hashjoin_row14 | -1987 | -1987 | vector_hashjoin_row14
-1986 | -1986 | vector_hashjoin_row15 | -1986 | -1986 | vector_hashjoin_row15
-1986 | -1986 | vector_hashjoin_row15 | -1986 | -1986 | vector_hashjoin_row15
-1986 | -1986 | vector_hashjoin_row15 | -1986 | -1986 | vector_hashjoin_row15
-1986 | -1986 | vector_hashjoin_row15 | -1986 | -1986 | vector_hashjoin_row15
-1986 | -1986 | vector_hashjoin_row15 | -1986 | -1986 | vector_hashjoin_row15
-1986 | -1986 | vector_hashjoin_row15 | -1986 | -1986 | vector_hashjoin_row15
-1985 | -1985 | vector_hashjoin_row16 | -1985 | -1985 | vector_hashjoin_row16
-1985 | -1985 | vector_hashjoin_row16 | -1985 | -1985 | vector_hashjoin_row16
-1985 | -1985 | vector_hashjoin_row16 | -1985 | -1985 | vector_hashjoin_row16
-1985 | -1985 | vector_hashjoin_row16 | -1985 | -1985 | vector_hashjoin_row16
-1985 | -1985 | vector_hashjoin_row16 | -1985 | -1985 | vector_hashjoin_row16
-1985 | -1985 | vector_hashjoin_row16 | -1985 | -1985 | vector_hashjoin_row16
-1984 | -1984 | vector_hashjoin_row17 | -1984 | -1984 | vector_hashjoin_row17
-1984 | -1984 | vector_hashjoin_row17 | -1984 | -1984 | vector_hashjoin_row17
-1984 | -1984 | vector_hashjoin_row17 | -1984 | -1984 | vector_hashjoin_row17
-1984 | -1984 | vector_hashjoin_row17 | -1984 | -1984 | vector_hashjoin_row17
(100 rows)
select * from VECTOR_HASHJOIN_TABLE_07 A join VECTOR_HASHJOIN_TABLE_08 B on a.c_int=b.c_int +1 order by 1,2,3,4,5,6 limit 50;
c_int | c_smallint | c3 | c_int | c_bigint | c3
-------+------------+------------------------------------------------------------------------------------------------------+-------+----------+------------------------------------------------------------------------------------------------------
-1999 | -1999 | vector_hashjoin_row2 | -2000 | -2000 | vector_hashjoin_row1
-1999 | -1999 | vector_hashjoin_row2 | -2000 | -2000 | vector_hashjoin_row1
-1999 | -1999 | vector_hashjoin_row2 | -2000 | -2000 | vector_hashjoin_row1
-1999 | -1999 | vector_hashjoin_row2 | -2000 | -2000 | vector_hashjoin_row1
-1999 | -1999 | vector_hashjoin_row2 | -2000 | -2000 | vector_hashjoin_row1
-1999 | -1999 | vector_hashjoin_row2 | -2000 | -2000 | vector_hashjoin_row1
-1998 | -1998 | vector_hashjoin_row3 | -1999 | -1999 | vector_hashjoin_row2
-1998 | -1998 | vector_hashjoin_row3 | -1999 | -1999 | vector_hashjoin_row2
-1998 | -1998 | vector_hashjoin_row3 | -1999 | -1999 | vector_hashjoin_row2
-1998 | -1998 | vector_hashjoin_row3 | -1999 | -1999 | vector_hashjoin_row2
-1998 | -1998 | vector_hashjoin_row3 | -1999 | -1999 | vector_hashjoin_row2
-1998 | -1998 | vector_hashjoin_row3 | -1999 | -1999 | vector_hashjoin_row2
-1997 | -1997 | vector_hashjoin_row4 | -1998 | -1998 | vector_hashjoin_row3
-1997 | -1997 | vector_hashjoin_row4 | -1998 | -1998 | vector_hashjoin_row3
-1997 | -1997 | vector_hashjoin_row4 | -1998 | -1998 | vector_hashjoin_row3
-1997 | -1997 | vector_hashjoin_row4 | -1998 | -1998 | vector_hashjoin_row3
-1997 | -1997 | vector_hashjoin_row4 | -1998 | -1998 | vector_hashjoin_row3
-1997 | -1997 | vector_hashjoin_row4 | -1998 | -1998 | vector_hashjoin_row3
-1996 | -1996 | vector_hashjoin_row5 | -1997 | -1997 | vector_hashjoin_row4
-1996 | -1996 | vector_hashjoin_row5 | -1997 | -1997 | vector_hashjoin_row4
-1996 | -1996 | vector_hashjoin_row5 | -1997 | -1997 | vector_hashjoin_row4
-1996 | -1996 | vector_hashjoin_row5 | -1997 | -1997 | vector_hashjoin_row4
-1996 | -1996 | vector_hashjoin_row5 | -1997 | -1997 | vector_hashjoin_row4
-1996 | -1996 | vector_hashjoin_row5 | -1997 | -1997 | vector_hashjoin_row4
-1995 | -1995 | vector_hashjoin_row6 | -1996 | -1996 | vector_hashjoin_row5
-1995 | -1995 | vector_hashjoin_row6 | -1996 | -1996 | vector_hashjoin_row5
-1995 | -1995 | vector_hashjoin_row6 | -1996 | -1996 | vector_hashjoin_row5
-1995 | -1995 | vector_hashjoin_row6 | -1996 | -1996 | vector_hashjoin_row5
-1995 | -1995 | vector_hashjoin_row6 | -1996 | -1996 | vector_hashjoin_row5
-1995 | -1995 | vector_hashjoin_row6 | -1996 | -1996 | vector_hashjoin_row5
-1994 | -1994 | vector_hashjoin_row7 | -1995 | -1995 | vector_hashjoin_row6
-1994 | -1994 | vector_hashjoin_row7 | -1995 | -1995 | vector_hashjoin_row6
-1994 | -1994 | vector_hashjoin_row7 | -1995 | -1995 | vector_hashjoin_row6
-1994 | -1994 | vector_hashjoin_row7 | -1995 | -1995 | vector_hashjoin_row6
-1994 | -1994 | vector_hashjoin_row7 | -1995 | -1995 | vector_hashjoin_row6
-1994 | -1994 | vector_hashjoin_row7 | -1995 | -1995 | vector_hashjoin_row6
-1993 | -1993 | vector_hashjoin_row8 | -1994 | -1994 | vector_hashjoin_row7
-1993 | -1993 | vector_hashjoin_row8 | -1994 | -1994 | vector_hashjoin_row7
-1993 | -1993 | vector_hashjoin_row8 | -1994 | -1994 | vector_hashjoin_row7
-1993 | -1993 | vector_hashjoin_row8 | -1994 | -1994 | vector_hashjoin_row7
-1993 | -1993 | vector_hashjoin_row8 | -1994 | -1994 | vector_hashjoin_row7
-1993 | -1993 | vector_hashjoin_row8 | -1994 | -1994 | vector_hashjoin_row7
-1992 | -1992 | vector_hashjoin_row9 | -1993 | -1993 | vector_hashjoin_row8
-1992 | -1992 | vector_hashjoin_row9 | -1993 | -1993 | vector_hashjoin_row8
-1992 | -1992 | vector_hashjoin_row9 | -1993 | -1993 | vector_hashjoin_row8
-1992 | -1992 | vector_hashjoin_row9 | -1993 | -1993 | vector_hashjoin_row8
-1992 | -1992 | vector_hashjoin_row9 | -1993 | -1993 | vector_hashjoin_row8
-1992 | -1992 | vector_hashjoin_row9 | -1993 | -1993 | vector_hashjoin_row8
-1991 | -1991 | vector_hashjoin_row10 | -1992 | -1992 | vector_hashjoin_row9
-1991 | -1991 | vector_hashjoin_row10 | -1992 | -1992 | vector_hashjoin_row9
(50 rows)
select * from VECTOR_HASHJOIN_TABLE_07 A right join VECTOR_HASHJOIN_TABLE_08 B on a.c_smallint=b.c_int order by 1,2,3,4,5,6 limit 100;
c_int | c_smallint | c3 | c_int | c_bigint | c3
-------+------------+------------------------------------------------------------------------------------------------------+-------+----------+------------------------------------------------------------------------------------------------------
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1992 | -1992 | vector_hashjoin_row9 | -1992 | -1992 | vector_hashjoin_row9
-1992 | -1992 | vector_hashjoin_row9 | -1992 | -1992 | vector_hashjoin_row9
-1992 | -1992 | vector_hashjoin_row9 | -1992 | -1992 | vector_hashjoin_row9
-1992 | -1992 | vector_hashjoin_row9 | -1992 | -1992 | vector_hashjoin_row9
-1992 | -1992 | vector_hashjoin_row9 | -1992 | -1992 | vector_hashjoin_row9
-1992 | -1992 | vector_hashjoin_row9 | -1992 | -1992 | vector_hashjoin_row9
-1991 | -1991 | vector_hashjoin_row10 | -1991 | -1991 | vector_hashjoin_row10
-1991 | -1991 | vector_hashjoin_row10 | -1991 | -1991 | vector_hashjoin_row10
-1991 | -1991 | vector_hashjoin_row10 | -1991 | -1991 | vector_hashjoin_row10
-1991 | -1991 | vector_hashjoin_row10 | -1991 | -1991 | vector_hashjoin_row10
-1991 | -1991 | vector_hashjoin_row10 | -1991 | -1991 | vector_hashjoin_row10
-1991 | -1991 | vector_hashjoin_row10 | -1991 | -1991 | vector_hashjoin_row10
-1990 | -1990 | vector_hashjoin_row11 | -1990 | -1990 | vector_hashjoin_row11
-1990 | -1990 | vector_hashjoin_row11 | -1990 | -1990 | vector_hashjoin_row11
-1990 | -1990 | vector_hashjoin_row11 | -1990 | -1990 | vector_hashjoin_row11
-1990 | -1990 | vector_hashjoin_row11 | -1990 | -1990 | vector_hashjoin_row11
-1990 | -1990 | vector_hashjoin_row11 | -1990 | -1990 | vector_hashjoin_row11
-1990 | -1990 | vector_hashjoin_row11 | -1990 | -1990 | vector_hashjoin_row11
-1989 | -1989 | vector_hashjoin_row12 | -1989 | -1989 | vector_hashjoin_row12
-1989 | -1989 | vector_hashjoin_row12 | -1989 | -1989 | vector_hashjoin_row12
-1989 | -1989 | vector_hashjoin_row12 | -1989 | -1989 | vector_hashjoin_row12
-1989 | -1989 | vector_hashjoin_row12 | -1989 | -1989 | vector_hashjoin_row12
-1989 | -1989 | vector_hashjoin_row12 | -1989 | -1989 | vector_hashjoin_row12
-1989 | -1989 | vector_hashjoin_row12 | -1989 | -1989 | vector_hashjoin_row12
-1988 | -1988 | vector_hashjoin_row13 | -1988 | -1988 | vector_hashjoin_row13
-1988 | -1988 | vector_hashjoin_row13 | -1988 | -1988 | vector_hashjoin_row13
-1988 | -1988 | vector_hashjoin_row13 | -1988 | -1988 | vector_hashjoin_row13
-1988 | -1988 | vector_hashjoin_row13 | -1988 | -1988 | vector_hashjoin_row13
-1988 | -1988 | vector_hashjoin_row13 | -1988 | -1988 | vector_hashjoin_row13
-1988 | -1988 | vector_hashjoin_row13 | -1988 | -1988 | vector_hashjoin_row13
-1987 | -1987 | vector_hashjoin_row14 | -1987 | -1987 | vector_hashjoin_row14
-1987 | -1987 | vector_hashjoin_row14 | -1987 | -1987 | vector_hashjoin_row14
-1987 | -1987 | vector_hashjoin_row14 | -1987 | -1987 | vector_hashjoin_row14
-1987 | -1987 | vector_hashjoin_row14 | -1987 | -1987 | vector_hashjoin_row14
-1987 | -1987 | vector_hashjoin_row14 | -1987 | -1987 | vector_hashjoin_row14
-1987 | -1987 | vector_hashjoin_row14 | -1987 | -1987 | vector_hashjoin_row14
-1986 | -1986 | vector_hashjoin_row15 | -1986 | -1986 | vector_hashjoin_row15
-1986 | -1986 | vector_hashjoin_row15 | -1986 | -1986 | vector_hashjoin_row15
-1986 | -1986 | vector_hashjoin_row15 | -1986 | -1986 | vector_hashjoin_row15
-1986 | -1986 | vector_hashjoin_row15 | -1986 | -1986 | vector_hashjoin_row15
-1986 | -1986 | vector_hashjoin_row15 | -1986 | -1986 | vector_hashjoin_row15
-1986 | -1986 | vector_hashjoin_row15 | -1986 | -1986 | vector_hashjoin_row15
-1985 | -1985 | vector_hashjoin_row16 | -1985 | -1985 | vector_hashjoin_row16
-1985 | -1985 | vector_hashjoin_row16 | -1985 | -1985 | vector_hashjoin_row16
-1985 | -1985 | vector_hashjoin_row16 | -1985 | -1985 | vector_hashjoin_row16
-1985 | -1985 | vector_hashjoin_row16 | -1985 | -1985 | vector_hashjoin_row16
-1985 | -1985 | vector_hashjoin_row16 | -1985 | -1985 | vector_hashjoin_row16
-1985 | -1985 | vector_hashjoin_row16 | -1985 | -1985 | vector_hashjoin_row16
-1984 | -1984 | vector_hashjoin_row17 | -1984 | -1984 | vector_hashjoin_row17
-1984 | -1984 | vector_hashjoin_row17 | -1984 | -1984 | vector_hashjoin_row17
-1984 | -1984 | vector_hashjoin_row17 | -1984 | -1984 | vector_hashjoin_row17
-1984 | -1984 | vector_hashjoin_row17 | -1984 | -1984 | vector_hashjoin_row17
(100 rows)
select * from VECTOR_HASHJOIN_TABLE_07 A right join VECTOR_HASHJOIN_TABLE_08 B on substring(A.c3, 2) = substring(B.c3, 2) order by 1,2,3,4,5,6 limit 50;
c_int | c_smallint | c3 | c_int | c_bigint | c3
-------+------------+------------------------------------------------------------------------------------------------------+-------+----------+------------------------------------------------------------------------------------------------------
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1992 | -1992 | vector_hashjoin_row9 | -1992 | -1992 | vector_hashjoin_row9
-1992 | -1992 | vector_hashjoin_row9 | -1992 | -1992 | vector_hashjoin_row9
(50 rows)
select * from VECTOR_HASHJOIN_TABLE_07 A right join VECTOR_HASHJOIN_TABLE_08 B on substring(A.c3, 2) = substring(B.c3, 2) and a.c_smallint=b.c_bigint order by 1,2,3,4,5,6 limit 50;
c_int | c_smallint | c3 | c_int | c_bigint | c3
-------+------------+------------------------------------------------------------------------------------------------------+-------+----------+------------------------------------------------------------------------------------------------------
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-2000 | -2000 | vector_hashjoin_row1 | -2000 | -2000 | vector_hashjoin_row1
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1999 | -1999 | vector_hashjoin_row2 | -1999 | -1999 | vector_hashjoin_row2
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1998 | -1998 | vector_hashjoin_row3 | -1998 | -1998 | vector_hashjoin_row3
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1997 | -1997 | vector_hashjoin_row4 | -1997 | -1997 | vector_hashjoin_row4
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1996 | -1996 | vector_hashjoin_row5 | -1996 | -1996 | vector_hashjoin_row5
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1995 | -1995 | vector_hashjoin_row6 | -1995 | -1995 | vector_hashjoin_row6
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1994 | -1994 | vector_hashjoin_row7 | -1994 | -1994 | vector_hashjoin_row7
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1993 | -1993 | vector_hashjoin_row8 | -1993 | -1993 | vector_hashjoin_row8
-1992 | -1992 | vector_hashjoin_row9 | -1992 | -1992 | vector_hashjoin_row9
-1992 | -1992 | vector_hashjoin_row9 | -1992 | -1992 | vector_hashjoin_row9
(50 rows)
reset enable_compress_spill;
\o xml_explain_temp.txt
explain (analyze on, timing off, format xml) select * from VECTOR_HASHJOIN_TABLE_07 A right join VECTOR_HASHJOIN_TABLE_08 B on substring(A.c3, 2) = substring(B.c3, 2) and a.c_smallint=b.c_bigint;
\o
explain (analyze on, detail on, timing off) select * from VECTOR_HASHJOIN_TABLE_07 A right join VECTOR_HASHJOIN_TABLE_08 B on substring(A.c3, 2) = substring(B.c3, 2) and a.c_smallint=b.c_bigint order by 1,2,3,4,5,6 limit 50;
--? QUERY PLAN
--?--------------------------------------------------------------------------------------------------------------------------------------------
--? Row Adapter (cost=1771.68..1771.68 rows=50 width=220) (actual rows=50 loops=1)
--? -> Vector Limit (cost=1769.09..1771.68 rows=50 width=220) (actual rows=50 loops=1)
--? -> Vector Streaming (type: GATHER) (cost=1769.09..1800.13 rows=600 width=220) (actual rows=600 loops=1)
Merge Sort Key: a.c_int, a.c_smallint, a.c3, b.c_int, b.c_bigint, b.c3
Node/s: All datanodes
--? -> Vector Limit (cost=1765.09..1765.22 rows=600 width=220)
datanode1 (actual rows=50 loops=1)
datanode10 (actual rows=50 loops=1)
datanode11 (actual rows=50 loops=1)
datanode12 (actual rows=50 loops=1)
datanode2 (actual rows=50 loops=1)
datanode3 (actual rows=50 loops=1)
datanode4 (actual rows=50 loops=1)
datanode5 (actual rows=50 loops=1)
datanode6 (actual rows=50 loops=1)
datanode7 (actual rows=50 loops=1)
datanode8 (actual rows=50 loops=1)
datanode9 (actual rows=50 loops=1)
--? -> Vector Sort (cost=1765.09..1766.66 rows=7512 width=220)
datanode1 (actual rows=50 loops=1)
datanode10 (actual rows=50 loops=1)
datanode11 (actual rows=50 loops=1)
datanode12 (actual rows=50 loops=1)
datanode2 (actual rows=50 loops=1)
datanode3 (actual rows=50 loops=1)
datanode4 (actual rows=50 loops=1)
datanode5 (actual rows=50 loops=1)
datanode6 (actual rows=50 loops=1)
datanode7 (actual rows=50 loops=1)
datanode8 (actual rows=50 loops=1)
datanode9 (actual rows=50 loops=1)
Sort Key: a.c_int, a.c_smallint, a.c3, b.c_int, b.c_bigint, b.c3
--? datanode1 Sort Method: top-N heapsort Memory: \d+kB
--? datanode10 Sort Method: top-N heapsort Memory: \d+kB
--? datanode11 Sort Method: top-N heapsort Memory: \d+kB
--? datanode12 Sort Method: top-N heapsort Memory: \d+kB
--? datanode2 Sort Method: top-N heapsort Memory: \d+kB
--? datanode3 Sort Method: top-N heapsort Memory: \d+kB
--? datanode4 Sort Method: top-N heapsort Memory: \d+kB
--? datanode5 Sort Method: top-N heapsort Memory: \d+kB
--? datanode6 Sort Method: top-N heapsort Memory: \d+kB
--? datanode7 Sort Method: top-N heapsort Memory: \d+kB
--? datanode8 Sort Method: top-N heapsort Memory: \d+kB
--? datanode9 Sort Method: top-N heapsort Memory: \d+kB
--? -> Vector Hash Left Join (cost=849.66..1744.2\d+rows=7512 width=220)
datanode1 (actual rows=909 loops=1)
datanode10 (actual rows=990 loops=1)
datanode11 (actual rows=1068 loops=1)
datanode12 (actual rows=930 loops=1)
datanode2 (actual rows=1038 loops=1)
datanode3 (actual rows=876 loops=1)
datanode4 (actual rows=996 loops=1)
datanode5 (actual rows=1020 loops=1)
datanode6 (actual rows=972 loops=1)
datanode7 (actual rows=1158 loops=1)
datanode8 (actual rows=1077 loops=1)
datanode9 (actual rows=975 loops=1)
Hash Cond: (("substring"((b.c3)::text, 2) = "substring"((a.c3)::text, 2)) AND (b.c_bigint = a.c_smallint))
datanode1 (LLVM Optimized)
datanode10 (LLVM Optimized)
datanode11 (LLVM Optimized)
datanode12 (LLVM Optimized)
datanode2 (LLVM Optimized)
datanode3 (LLVM Optimized)
datanode4 (LLVM Optimized)
datanode5 (LLVM Optimized)
datanode6 (LLVM Optimized)
datanode7 (LLVM Optimized)
datanode8 (LLVM Optimized)
datanode9 (LLVM Optimized)
--? datanode1 Memory Used : 22kB
--? datanode10 Memory Used : 24kB
--? datanode11 Memory Used : 26kB
--? datanode12 Memory Used : 22kB
--? datanode2 Memory Used : 25kB
--? datanode3 Memory Used : 21kB
--? datanode4 Memory Used : 24kB
--? datanode5 Memory Used : 24kB
--? datanode6 Memory Used : 23kB
--? datanode7 Memory Used : 28kB
--? datanode8 Memory Used : 26kB
--? datanode9 Memory Used : 23kB
--? -> Vector Streaming(type: REDISTRIBUTE) (cost=0.00..949.83 rows=6009 width=113)
datanode1 (actual rows=456 loops=1)
datanode10 (actual rows=495 loops=1)
datanode11 (actual rows=534 loops=1)
datanode12 (actual rows=465 loops=1)
datanode2 (actual rows=519 loops=1)
datanode3 (actual rows=438 loops=1)
datanode4 (actual rows=498 loops=1)
datanode5 (actual rows=510 loops=1)
datanode6 (actual rows=486 loops=1)
datanode7 (actual rows=579 loops=1)
datanode8 (actual rows=540 loops=1)
datanode9 (actual rows=489 loops=1)
Spawn on: All datanodes
--? -> CStore Scan on vector_hashjoin_table_08 b (cost=0.00..908.50 rows=6009 width=113)
datanode1 (actual rows=456 loops=1)
datanode10 (actual rows=495 loops=1)
datanode11 (actual rows=534 loops=1)
datanode12 (actual rows=465 loops=1)
datanode2 (actual rows=519 loops=1)
datanode3 (actual rows=438 loops=1)
datanode4 (actual rows=498 loops=1)
datanode5 (actual rows=510 loops=1)
datanode6 (actual rows=486 loops=1)
datanode7 (actual rows=579 loops=1)
datanode8 (actual rows=540 loops=1)
datanode9 (actual rows=489 loops=1)
--? -> Vector Streaming(type: REDISTRIBUTE) (cost=0.00..887.89 rows=4006 width=107)
datanode1 (actual rows=304 loops=1)
datanode10 (actual rows=330 loops=1)
datanode11 (actual rows=356 loops=1)
datanode12 (actual rows=310 loops=1)
datanode2 (actual rows=346 loops=1)
datanode3 (actual rows=292 loops=1)
datanode4 (actual rows=332 loops=1)
datanode5 (actual rows=340 loops=1)
datanode6 (actual rows=324 loops=1)
datanode7 (actual rows=386 loops=1)
datanode8 (actual rows=360 loops=1)
datanode9 (actual rows=326 loops=1)
Spawn on: All datanodes
--? -> CStore Scan on vector_hashjoin_table_07 a (cost=0.00..860.33 rows=4006 width=107)
datanode1 (actual rows=304 loops=1)
datanode10 (actual rows=330 loops=1)
datanode11 (actual rows=356 loops=1)
datanode12 (actual rows=310 loops=1)
datanode2 (actual rows=346 loops=1)
datanode3 (actual rows=292 loops=1)
datanode4 (actual rows=332 loops=1)
datanode5 (actual rows=340 loops=1)
datanode6 (actual rows=324 loops=1)
datanode7 (actual rows=386 loops=1)
datanode8 (actual rows=360 loops=1)
datanode9 (actual rows=326 loops=1)
--? Total runtime: 906.992 ms
(137 rows)
reset work_mem;
----
--- Clean table and resource
----
drop schema vector_hashjoin_engine_second cascade;
NOTICE: drop cascades to 4 other objects
--?DETAIL: drop cascades to table .*
--?drop cascades to table .*
--?drop cascades to table .*
--?drop cascades to table .*