My Oracle Support Banner

Oracle Big Data SQL on Oracle Big Data Appliance Frequently Asked Questions (FAQ) (Doc ID 1933180.1)

Last updated on FEBRUARY 28, 2018

Applies to:

Oracle Big Data SQL - Version 1.0 and later
Linux 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? 
 So just to clarify does that mean BDSQL can not run on comodity hardware?
 Is there any way to test it out without a BDA/Exadata.
 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?
 For Big Data SQL v1.1 is it correct that the only granularity possible is the whole cluster, so every user who has read access on the ORA_BIGDATA_CL_<cluster> directory and has the <create table> privilege can query all Hive tables on the entire cluster?
 What roles/privileges are necessary in order for a general user to execute the "Copying Oracle Tables to Hadoop" operation?
 Table 8-1 of the Big Data Appliance Software User's Guide, Section: About Data Type Conversions, explains Oracle to Hive data type conversions.  But what about Oracle data types like "LONG", "BFILE" and "BLOB" which are not explained in Table 8-1?
 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?
 Is there a way to control the BDS resource limit on an HDP cluster similar to resource limits on a CDH cluster (i.e. via cpu.shares, bikio.weight, memory.soft_limit_in_bytes and memory.limit_in_bytes parameters in the bigdatasql-config.xml file)?
 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.