ADF Projects often need jars from popular open source libraries and frameworks. JDeveloper supports the addition of dependencies from public (and private) repositories. To add a new dependency to project we need to: Go to Project folder in Application browser and expand the Resources folder under Project. Then open pom.xml file and go to dependencies section. The click the Green …
Deck Transition changes Checkbox’s value (Oracle Jdeveloper 12.1.3.0)
A really nice new feature introduced in ADF 12c is the deck ui component. Two helpful examples on how to use this component are the following: How to use the Deck component (ADF 12.1.3 New Feature) from Andreas Koop Using af:deck component to animate content in ADF 12c(12.1.3) from Ashish Awasthi You can find some more examples over the internet but …
Unexpected behavior of Spark dataframe filter method
[EDIT: Thanks to this post, the issue reported here has been resolved since Spark 1.4.1 – see the comments below] While writing the previous post on Spark dataframes, I encountered an unexpected behavior of the respective .filter method; but, on the one hand, I needed some more time to experiment and confirm it and, on the other hand, I knew …
Installing rJava R package in Oracle Linux
The Oracle Big Data Lite (BDLite) VM is a handy and convenient platform for testing, development, and training on the related tools and technologies, such as Cloudera Hadoop, Oracle NoSQL database, Oracle SQL Developer & Data Modeler etc. Among other things, it includes a full distribution of the Oracle R Enterprise (ORE) and the Oracle R Connectors for Hadoop (ORCH). …
ADF Calendar Implementation
One of the new projects that we are currently working on is the implementation of a complete school management solution using Oracle ADF 12c. As one might imagine, one of the basic requirements of this project was to implement a Scheduling functionality. The schedule implementation has many different aspects, but in this post we will focus on the ADF Calendar implementation that will …
Spark data frames from CSV files: handling headers & column types
If you come from the R (or Python/pandas) universe, like me, you must implicitly think that working with CSV files must be one of the most natural and straightforward things to happen in a data analysis context. Indeed, if you have your data in a CSV file, practically the only thing you have to do from R is to fire …
ViewCriteria issue when using same attribute twice (Oracle JDeveloper 12.1.3.0)
Some days ago, in an Oracle MAF technical workshop, I witnessed one of those awkward moments when you are certain that something should work correctly in a presentation but it didn’t. While showing us some basic functionality in Oracle ADF 12c, the instructor implemented a simple query using ViewCriteria. He used an OR conjunction but the query seemed to react …
Undocumented behavior of ore.make.names() function in Oracle R Enterprise
While working with some data in Hive recently using the Oracle R Connectors for Hadoop (ORCH), I tried to use the ore.make.names function (of package OREbase ). The function creates valid column names for ore.frame objects. Here is a reproducible example, copied straight from the function documentation: Experimenting a little, I discovered that ore.make.names becomes functional after executing ore.connect. Indeed, …
Oracle R Enterprise issues in Oracle Big Data Lite VM 4.1.0
In the previous post, we examined some configuration issues with Cloudera Manager and Hadoop services in the latest release of Oracle Big Data Lite VM (4.1.0). In this post we report issues with Oracle R Enterprise, and the remedies we applied. It turns out that if we load the ORE package in R, we subsequently cannot use the help system …
Cloudera Manager configuration issues in Oracle Big Data Lite VM 4.1.0
Oracle has recently announced the release of a new version (4.1.0) of its Big Data Lite VM. Compared to the previous release (4.0.1), we now have more recent versions of Oracle Enterprise Linux (6.5), Oracle NoSQL database (3.2.5), Cloudera distribution of Apache Hadoop (CDH 5.3.0) and Cloudera Manager (5.3.0). The new version of CDH, by itself, also brings forward several …