Home > Workload Solutions > Oracle > Guides > Design Guide — Oracle Big Data SQL on Dell EMC PowerFlex > Creating Oracle external tables pointing to HDFS
SQL>create table tpch.lineitem (l_orderkey number(10,0),l_partkey number(10,0),l_suppkey number(10,0),l_linenumber integer,l_quantity number,l_extendedprice number,l_discount number,l_tax number,l_returnflag char(1),l_linestatus char(1),l_shipdate date,l_commitdate date,l_receipdate date,l_shipinstruct char(10),l_shipmode char(10), l_comment varchar2(44))
organization external
(type oracle_hdfs
DEFAULT DIRECTORY DEFAULT_DIR
access parameters
(com. oracle. bigdata. cluster = cluster1
com. oracle.bigdata.rowformat = delimited fields terminated by ‘|’
LOCATION ('/user/oracle/lineitem*.csv’);
SQL>create table tpch.part (p_partkey number(10,0) NOT NULL,p_name varchar2(55) NOT NULL, p_mfgr CHAR(25) NOT NULL, p_brand CHAR(10), NOT NULL, p_type varchar2(25) NOT NULL p_size INTEGER NOT NULL, p_container CHAR(10) NOT NULL, p_retailprice NUMBER NUMBER NOT NULL, p_comment varchar2(23) NOT NULL)
organization external
(type oracle_hdfs
DEFAULT DIRECTORY DEFAULT_DIR
access parameters
(com.oracle.bigdata.cluster = cluster1
com.oracle.bigdata.rowformat = delimited fields terminated by '|’
LOCATION ('/user/oracle/part*.csv’))
REJECT LIMIT UNLIMITED;