Home > Workload Solutions > Oracle > White Papers > Oracle Big Data SQL on Dell EMC PowerFlex > TPC-H Query 3 test
In this query, tables from SQL Server (PARTSUPP), Cloudera Hadoop (SUPPLIERS), and ONDB (EXT_ORA_NATION) were used for an important stock identification report. The table names in the script were modified to use the external tables: EXT_HDFS_PARTSUPP and EXT_ORA_NATION.
/* TPC_H Query 3 - Important Stock Identification */
SELECT PS_PARTKEY,
SUM(PS_SUPPLYCOST*PS_AVAILQTY) AS VALUE
FROM EXT_HDFS_PARTSUPP,
SUPPLIER,
EXT_ORA_NATION
WHERE PS_SUPPKEY = S_SUPPKEY
AND S_NATIONKEY = N_NATIONKEY
AND N_NAME = 'ARGENTINA'
GROUP BY PS_PARTKEY HAVING SUM(PS_SUPPLYCOST*PS_AVAILQTY) > (SELECT SUM(PS_SUPPLYCOST*PS_AVAILQTY) * 0.0000001000
FROM EXT_HDFS_PARTSUPP,
SUPPLIER,
EXT_ORA_NATION
WHERE PS_SUPPKEY = S_SUPPKEY
AND S_NATIONKEY = N_NATIONKEY
AND N_NAME = 'ARGENTINA')
ORDER BY VALUE DESC