How to Confirm Big Data SQL 3.2 Queries to Hadoop Clusters and Smart Scan Are Working After Big Data SQL 3.2 Install

(Doc ID 2334388.1)

Last updated on JANUARY 10, 2018

Applies to:

Oracle Big Data SQL - Version 3.2.0 and later
Linux x86-64

Goal

After installing Big Data SQL 3.2 perform these steps on the Oracle database as the 'database owner user' user, typically the 'oracle' user, to confirm that queries to Hadoop clusters and Smart Scan are working. You can also confirm queries to multiple Hadoop clusters are working if the Oracle database connects to more than one Hadoop cluster.

Note: In the examples that follow, the SQL "create table" clauses vary depending on the table structure of the external Hive tables where the data resides on the Hadoop cluster, see the BDS 3.2 User's Guide for more details.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms