Oracle Big Data SQL on Oracle Big Data Appliance Frequently Asked Questions (FAQ)
(Doc ID 1933180.1)
Last updated on DECEMBER 07, 2022
Applies to:
Oracle Big Data SQL - Version 1.0 and laterLinux x86-64
Purpose
Frequently Asked Questions for Oracle Big Data SQL on Oracle Big Data Appliance(BDA).
Questions and Answers
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
Purpose |
Questions and Answers |
What Oracle Big Data SQL? |
Does this mean that Big Data SQL supports the full set of Oracle SQL? |
Is an Exadata and BDA required to use BDSQL? |
Does BDSQL required a separate licence? |
Does Cloudera Manager(CM) provide support to manage BDSQL? |
Will CM send an alert if BDSQL services/roles are down? |
Does Oracle Big Data SQL use external tables? |
Does BDSQL support data in HDFS? |
Does BDSQL support data in Hive? |
Does BDSQL support HBase? |
Does BDSQL support Smart Scan Technology? |
Does BDSQl use Hive for its metadata? |
Does BDSQL have security features? |
Is OPatch used to patch BDSQL on the BDA? |
Two environment variables $CDPATH and $CELLTRACE on the BDA with Big Data SQL installed have ASM names in their path. Is this a bug? |
How do you install Exadata Storage Server Software on Oracle Big Data Appliance ? Do you have to install it manually on the BDA? |
Can one Exadata talk to multiple BDA clusters using Big Data SQL? |
Is a running 12c database (not just the software binaries) required in order to use Big Data SQL? Can BDA connect to an Exadata machine running an 11g database? |
For Big Data SQL is it an absolute requirement to have an InfinBand network connection between the BDA and Exadata? |
For Big Data SQL v1.1 is there a security concern when creating a public DB link? |
For Big Data SQL v1.1 if two users access the same Hadoop cluster is there a direct way of preventing one user from accessing a different set of Hive table names than the other? |
What roles/privileges are necessary in order for a general user to execute the "Copying Oracle Tables to Hadoop" operation? |
Does BDS V2.0 support optimizations for Parquet? |
Is wallet compatible with BDS V2.0? |
How should Active SQL Monitor Report be used with BDS V2.0? |
We just upgraded to Bundle Patch 13 as part of the OCT 2015 QFSDP do we need to patch again and to which Bundle Patch? |
The documentation specifies Exadata storage version 12.1.1.1 or 12.1.1.0. Will this work with 12.1.2.2.0 and is that supported? |
Is the patch number 21419192 available for SAP databases? |
On BDA V4.4 with Big Data SQL 3.0 can Big Data SQL be run off the BDA? |
Is Big Data SQL v3.0.0 provided by default on BDA V4.4? |
With Big Data SQL v3.0.0 what configurations are supported? |
Is there way to limit the resources used by Big Data SQL? |
Why is BDS 2.0.2 discovered on a new BDA 4.5 installation when BDS 3.0.1 should have been installed? |
What about Big Data SQL recognition of compressed file? |
Does the database parameter _external_table_smart_scan need to be "ON" for smart scan to work? |
Does BDS use the listener TCP or SDP? |
Does the MOS note: Setup Listener on Infiniband Network using both SDP and TCP Protocol (Doc ID 1580584.1) apply to BDS? |
With BDA V4.7/ BDS 3.0.1 is is possible to install BDS on an Exadata and access a non-BDA cluster? |
What about BDS 3.1? |
Can the celladmin account be locked on all cluster nodes? |
Where can more information on specific Big Data SQL errors be found? |
Where is the BDS compatibility maxtrix? |
References |