Home > Workload Solutions > Oracle > White Papers > Oracle Big Data SQL on Dell EMC PowerFlex > TPC-H Query 1 test
In this query, tables from Cloudera Hadoop (LINEITEM), SQL Server (CUSTOMER), and Oracle (ORDERS) were joined to produce a shipping priority report. The script uses the previously defined external tables: EXT_HDFS_CUSTOMER, EXT_HDFS_ORDERS, and EXT_HDFS_LINEITEM.
/* TPC_H Query 1 - Shipping Priority */
SELECT TOP 10 L_ORDERKEY,
SUM(L_EXTENDEDPRICE*(1-L_DISCOUNT)) AS REVENUE,
O_ORDERDATE,
O_SHIPPRIORITY
FROM EXT_HDFS_CUSTOMER,
EXT_HDFS_ORDERS,
EXT_HDFS_LINEITEM
WHERE C_MKTSEGMENT = 'FURNITURE'
AND C_CUSTKEY = O_CUSTKEY
AND L_ORDERKEY = O_ORDERKEY
AND O_ORDERDATE < '1995-03-06'
AND L_SHIPDATE > '1995-03-06'
GROUP BY L_ORDERKEY,
O_ORDERDATE,
O_SHIPPRIORITY
ORDER BY REVENUE DESC,
O_ORDERDATE