#表结构
CREATE TABLE LINEITEM_C ( 
L_ORDERKEY   INTEGER NOT NULL,
L_PARTKEY	INTEGER NOT NULL, 
L_SUPPKEY	 INTEGER NOT NULL, 
L_LINENUMBER  INTEGER NOT NULL,
L_QUANTITY		DECIMAL(15,2) NOT NULL, 
L_EXTENDEDPRICE DECIMAL(15,2) NOT NULL, 
L_DISCOUNT		 DECIMAL(15,2) NOT NULL, 
L_TAX	 DECIMAL(15,2) NOT NULL, 
L_RETURNFLAG CHAR(1) NOT NULL, 
L_LINESTATUS CHAR(1) NOT NULL, 
L_SHIPDATE	DATE NOT NULL, 
L_COMMITDATE DATE NOT NULL, 
L_RECEIPTDATE DATE NOT NULL, 
L_SHIPINSTRUCT CHAR(25) NOT NULL, 
L_SHIPMODE  CHAR(10) NOT NULL, 
L_COMMENT  VARCHAR(44) NOT NULL
) ;


#执行SQL
EXPLAIN ANALYZE 
SELECT
L_RETURNFLAG, L_LINESTATUS,
SUM(L_QUANTITY) AS SUM_QTY, SUM(L_EXTENDEDPRICE) AS SUM_BASE_PRICE,
SUM(L_EXTENDEDPRICE * (1 - L_DISCOUNT)) AS SUM_DISC_PRICE, SUM(L_EXTENDEDPRICE * (1 - L_DISCOUNT) * (1 + L_TAX)) AS SUM_CHARGE, AVG(L_QUANTITY) AS AVG_QTY,
AVG(L_EXTENDEDPRICE) AS AVG_PRICE, AVG(L_DISCOUNT) AS AVG_DISC, COUNT(*) AS COUNT_ORDER
FROM LINEITEM_COPY
 WHERE
L_SHIPDATE = DATE '1994-01-16' 
GROUP BY
L_RETURNFLAG, L_LINESTATUS;

set try_vector_engine_strategy=force;

set try_vector_engine_strategy=force;
show try_vector_engine_strategy;