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

Cleaning the data

Cleaning the data

  • Here are the steps for cleaning the data using vi scripting. We repeated these same steps for all the CSV files.

    1. sed -i 's/,//g' part.tbl.1
    1. sed -i 's/|/,/g' part.tbl.1
    2. sed -i 's/.$//' part.tbl.1