Your Browser is Out of Date

Nytro.ai uses technology that works best in other browsers.
For a full experience use one of the browsers below
Design Guide — Oracle Big Data SQL on Dell EMC PowerFlex
Introduction Solution architecture Solution components Phase I: Infrastructure design and deployment Network design Phase II: Storage design Phase III: Oracle 19c database design and deployment Hadoop cluster design and deployment Configuring Big Data SQL Oracle NoSQL design and deployment Microsoft SQL Server design and deployment Oracle Gateways design and deployment Generate and load data
Generate and load data
Installing and loading TPCH data using DBGEN
Cleaning the data
Loading TPCH data in Oracle NoSQL
Loading TPCH data in Hadoop
Loading TPCH data into the Oracle database
Loading TPCH Schema on Microsoft SQL Server
Creating Oracle external tables pointing to Oracle NoSQL kvstore
Creating Oracle external tables pointing to HDFS
Accessing Microsoft SQL Server tables using Oracle Gateways
Data virtualization with Big Data SQL
References Appendix A

Loading TPCH data in Oracle NoSQL

Loading TPCH data in Oracle NoSQL

  • We followed these steps to load TPCH data into Oracle NoSQL:

    1. We created TPCH-tables “Nation” and “Region” and loaded them into the Oracle NoSQL kvstore using these commands:

    DROP TABLE IF EXISTS ext_region;

    CREATE TABLE ext_region

    (

       r_regionkey  integer,

       r_name       string,

       r_comment    string,

       primary key(r_regionkey)

    );

    DROP TABLE IF EXISTS ext_nation;

    CREATE TABLE ext_nation

    (

       n_nationkey  integer,

       n_name       string,

       n_regionkey  string,

       n_comment    string,

       primary key(n_nationkey)

    );

    1. We connected to the NoSQL kvstore and created two TPCH tables using these commands:

    [oracle@oracle-nosql   kv-19.5.19] $ java -jar lib/sql.jar -helper-hosts oracle-nosql. localdomain:5001 -store kvstore load -file /home/oracle/nation.ddl

    Table created successfully

    [oracle@oracle-nosql   kv-19.5.19] $ java -jar lib/sql.jar -helper-hosts oracle-nosql.localdomain:5001 -store kvstore load -file /home/oracle/region.ddl

    Table created successfully

    1. We loaded the CSV files into the NoSQL kvstore using these commands:

    [oracle@oracle-nosql   kv-19.5.19] $ java -jar lib/sql.jar -helper-hosts oracle-nosql. localdomain:5001 -store kvstore import -table ext_nation -file /home/nation.tbl CSV

    Loaded 25 rows to ext_nation

    [oracle@oracle-nosql   kv-19.5.19] $java -jar lib/sql.jar -helper-hosts oracle-nosql. localdomain:5001 -store kvstore import -table ext_region -file /home/region.tbl CSV

    Loaded 5 rows to ext_region.