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