列式数据库InfiniDB(calpont)tpch测试记录

〇〇

5
mysql> -- Edited to run in CNX.  Added "+ 0" so that CNX will see that the condition as a cross table comparison rather
mysql> -- than a join to avoid the circular join error.
mysql> SELECT
    ->  N_NAME,
    ->  SUM(L_EXTENDEDPRICE * (1-L_DISCOUNT)) AS REVENUE
    -> FROM
    ->  CUSTOMER,
    ->  ORDERS,
    ->  LINEITEM,
    ->  SUPPLIER,
    ->  NATION,
    ->  REGION
    -> WHERE
    ->  C_CUSTKEY = O_CUSTKEY AND
    ->  L_ORDERKEY = O_ORDERKEY AND
    ->  L_SUPPKEY = S_SUPPKEY AND
    ->  C_NATIONKEY = S_NATIONKEY + 0 AND
    ->  S_NATIONKEY = N_NATIONKEY AND
    ->  N_REGIONKEY = R_REGIONKEY AND
    ->  R_NAME = 'AFRICA' AND
    ->  O_ORDERDATE >= date '1997-01-01' AND
    ->  O_ORDERDATE < date '1997-01-01' + interval '1' year
    -> GROUP BY
    ->  N_NAME
    -> ORDER BY
    ->  REVENUE DESC;
+------------+---------------+
| N_NAME     | REVENUE       |
+------------+---------------+
| MOZAMBIQUE | 56212522.6300 |
| ALGERIA    | 55579002.6347 |
| ETHIOPIA   | 49327831.7214 |
| MOROCCO    | 46813540.6771 |
| KENYA      | 45538187.4775 |
+------------+---------------+
5 rows in set (21.98 sec)

mysql>