Parellelism for External Tables

Thursday, October 23, 2014

With Hive and Oracle Big Data SQL, you are now able to process external tables in parallel.

Example
CREATE TABLE table1 (col1 VARCHAR2(4000))

ORGANIZATION EXTERNAL
(TYPE ORACLE_HIVE
 DEFAULT DIRECTORY DEFAULT_DIR
)
PARALLEL 20
REJECT LIMIT UNLIMITED;

- Previously external tables were "file-centric"
- Enhanced external tables understand parallelism


More info on Oracle Big Data SQL, http://bit.ly/1ymiRVL

 

GW/JUVO