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 JUNE 12, 2019
Applies to:Oracle Big Data SQL - Version 3.2.0 and later
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document