Oracle Big Data SQL on Oracle Big Data Appliance Frequently Asked Questions (FAQ)
(Doc ID 1933180.1)
Last updated on SEPTEMBER 05, 2023
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? |
| 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 |