Oracle Big Data SQL provides Unified Query for Big Data Management. It enables organizations to analyze the data across Apache Hadoop, Apache Kafka, Oracle NoSQL Database, and Apache HBase seamlessly, as if all the data were all stored in an Oracle database.
Oracle Big Data SQL supports the complete Oracle SQL syntax. You can execute highly complex SQL SELECT statements against data in the Hadoop ecosystem, either manually or through your existing applications.
Oracle Big Data SQL provides external tables to analyze the data across Hadoop, Apache Kafka, and NoSQL objects from the Oracle database. An external table identifies the data residing outside of the Oracle database. We can run queries on external tables using the same SQL syntax that we use to run queries on other databases.
External tables use access drivers to parse the data outside the database. Each type of external data requires a unique access driver. Oracle Big Data SQL includes two access drivers for big data: one for data that has metadata defined in Apache Hive, and the other for accessing data stored in the Hadoop Distributed File System.
Oracle Big Data SQL is configured in two phases: