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...
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...
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...
In Hadoop world Kerberos is de facto standard of securing cluster and it's even not a question that Big Data SQL should support Kerberos. Oracle has good...
In Hadoop world Kerberos is de facto standard of securing cluster and it's even not a question that Big Data SQL should support Kerberos. Oracle has good documentation about how to install Big Data SQL over Kerberized cluster, but today, I'd like to show couple typical steps how to test and debug Kerberized installation. First of all, let me tell about test environment. it's a 4 nodes: 3 nodes for Hadoop cluster (vm0[1-3]) and one for Database (vm04). Kerberos tickets should...
In Hadoop world Kerberos is de facto standard of securing cluster and it's even not a question that Big Data SQL should support Kerberos. Oracle has good documentation about how to install Big Data...
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:...
One of the major Big Data SQL benefits is security. You deal with the data, which you store in HDFS or other sources, through Oracle Database, which means, that...
One of the major Big Data SQL benefits is security. You deal with the data, which you store in HDFS or other sources, through Oracle Database, which means, that you could apply many Database features, such as Data Redaction, VPD or Database Vault. These features in conjunction with database schema/grant privileged model, allows you to protect data from Database side (when intruder tries to reach data from database side). But it's also important to keep in mind, that Data...
One of the major Big Data SQL benefits is security. You deal with the data, which you store in HDFS or other sources, through Oracle Database, which means, that you could apply many Database features,...
According to latest analysts reports and data breaches statistics, Data Protection is rising up to be the most important IT issue in the coming years! Due to...
According to latest analysts reports and data breaches statistics, Data Protection is rising up to be the most important IT issue in the coming years! Due to increasing threats and cyber-attacks, new privacy regulations are being implemented such as the European Union (EU) General Data Protection Regulation (GDPR), are also being enforced and the increasing adoption of Public Cloud also legitimate these new Cyber Security requirements. Data Lake/Hub environments can be a...
According to latest analysts reports and data breaches statistics, Data Protection is rising up to be the most important IT issue in the coming years! Due to increasing threats and cyber-attacks, new...
