One of the popular new Big Data SQL features is its Query Server. You can think of Query Server as an Oracle Database 18c query engine that uses the Hive...
One of the popular new Big Data SQL features is its Query Server. You can think of Query Server as an Oracle Database 18c query engine that uses the Hive metastore to capture table definitions. Data isn’t stored in Query Server; it allows you to access data in Hadoop, NoSQL, Kafka and Object Stores (Oracle Object Store and Amazon S3) using Oracle SQL. Installation and Configuration Architecturally, here’s what a Big Data SQL deployment with Query Server looks like: There...
One of the popular new Big Data SQL features is its Query Server. You can think of Query Server as an Oracle Database 18c query engine that uses the Hive metastore to capture table definitions. Data...
I’m excited to announce the availability of Big Data SQL 4.0. This release is packed with new capabilities: Query more sources – including Oracle Object Store...
I’m excited to announce the availability of Big Data SQL 4.0. This release is packed with new capabilities: Query more sources – including Oracle Object Store and S3 Query data without requiring an Oracle Database using Big Data SQL Query Server Enhanced query processing – pushing aggregations to the Hadoop cluster nodes Support Apache Sentry authorization rules Support for CDH 6 Continued improvements to the install process Big Data SQL 4.0 can be downloaded from...
I’m excited to announce the availability of Big Data SQL 4.0. This release is packed with new capabilities: Query more sources – including Oracle Object Store and S3 Query data without requiring an...
Big Data SQL 4.0 introduces a data processing enhancement that can have a dramatic impact on query performance: distributed aggregation using in-memory...
Big Data SQL 4.0 introduces a data processing enhancement that can have a dramatic impact on query performance: distributed aggregation using in-memory capabilities. Big Data SQL has always done a great job of filtering data on the Hadoop cluster. It does this using the following optimizations: 1) column projection, 2) partition pruning, 3) storage indexes, 4) predicate pushdown. Column projection is the first optimization. If your table has 200 columns – and you are only...
Big Data SQL 4.0 introduces a data processing enhancement that can have a dramatic impact on query performance: distributed aggregation using in-memory capabilities. Big Data SQL has always done a...
Apache Avro is a common data format in big data solutions. Now, these types of files are easily accessible to Oracle Autonomous Databases. One of Avro's key...
Apache Avro is a common data format in big data solutions. Now, these types of files are easily accessible to Oracle Autonomous Databases. One of Avro's key benefits is that it enables efficient data exchange between applications and services. Data storage is compact and efficient – and the file format itself supports schema evolution. It does this by including the schema within each file – with an explanation of the characteristics of each field. In a previous post about...
Apache Avro is a common data format in big data solutions. Now, these types of files are easily accessible to Oracle Autonomous Databases. One of Avro's key benefits is that it enables efficient...
You have idea, you have feedback, you want to be involved in the products and services you use. Of course, so here is the new Idea Lab for Big Data, where you...
You have idea, you have feedback, you want to be involved in the products and services you use. Of course, so here is the new Idea Lab for Big Data, where you can submit your ideas and vote on ideas submitted by others. Visit the Big Data Idea Lab now. What does the Idea Lab let you do, and how do we use your feedback? For all our products and services we (Product Management) define a set of features and functionality that will enhance the products and solves customer...
You have idea, you have feedback, you want to be involved in the products and services you use. Of course, so here is the new Idea Lab for Big Data, where you can submit your ideas and vote on...
Last week Cloudera announced the general availability of Cloudera CDH 6 (read more from Cloudera here). With that, many of the ecosystem components switched to...
Last week Cloudera announced the general availability of Cloudera CDH 6 (read more from Cloudera here). With that, many of the ecosystem components switched to a newer base version, which should provide significant benefits for customer applications. This post describes Oracle's strategy to support our customers in up-taking C6 quickly and efficiently, with minimal disruption to their infrastructure. The Basics One of the key differences with C6 are its core versions, which...
Last week Cloudera announced the general availability of Cloudera CDH 6 (read more from Cloudera here). With that, many of the ecosystem components switched to a newer base version, which...
BDA 4.13 will have the following features, versions etc.: Of course an update to CDH. In this case we are going to uptake CDH 5.15.0. However, the release date...
BDA 4.13 will have the following features, versions etc.: Of course an update to CDH. In this case we are going to uptake CDH 5.15.0. However, the release date of 5.15.1 is pretty close to our planned date, and so, we may choose to pick up that version We are adding the following features: Support for SHA-2 certificates with Kerberos Upgrade and Expand for Kafka clusters (the create was introduced in BDA 4.12) A disk shredding utility, where you easily "erase" data on the...
BDA 4.13 will have the following features, versions etc.: Of course an update to CDH. In this case we are going to uptake CDH 5.15.0. However, the release date of 5.15.1 is pretty close to our...
We are very excited to announce our newly launched big data community on the Cloud Customer Connect Community. As of today we are live and ready to help,...
We are very excited to announce our newly launched big data community on the Cloud Customer Connect Community. As of today we are live and ready to help, discuss and ensure your questions are answered and comments are taken on board. How do you find us? Easy, go to the community main page. Then do the following to start asking your questions on big data: Once you are here, click on the thing you want from us, in this case I would assume that you want some answers on some...
We are very excited to announce our newly launched big data community on the Cloud Customer Connect Community. As of today we are live and ready to help, discuss and ensure your questions are answered...
Just wanted to give a quick update. I am pleased to announce that Oracle Big Data SQL 3.2.1 is now available. This release provides support for Oracle...
Just wanted to give a quick update. I am pleased to announce that Oracle Big Data SQL 3.2.1 is now available. This release provides support for Oracle Database 12.2.0.1. Here are some key details: Existing customers using Big Data SQL 3.2 do not need to take this update; Oracle Database 12.2.0.1 support is the reason for the update. Big Data SQL 3.2.1 can be used for both Oracle Database 12.1.0.2 and 12.2.0.1 deployments For Oracle Database 12.2.0.1, Big Data SQL 3.2.1...
Just wanted to give a quick update. I am pleased to announce that Oracle Big Data SQL 3.2.1 is now available. This release provides support for Oracle Database 12.2.0.1. Here are some key details:...
