Databases at CERN blog

Integrating Hadoop and Elasticsearch - Part 1 - Loading into and Querying Elasticsearch from Apache Hive


As more and more organisations are deploying Hadoop and Elasticsearch in tandem to satisfy batch analytics, real-time analytics and monitoring requirements, the need for tigher integration between Hadoop and Elasticsearch has never been more important. In this series of blogposts we look at how these two distributed systems can be tightly integrated and how each of them can exploit the feaures of the other system to achieve ever demanding analytics and monitoring needs.

Using SQL Developer to access Apache Hive with kerberos authentication

With Hadoop implementations moving into mainstream, many of the Oracle DBA's are having to access SQL on Hadoop frameworks such as Apache Hive in their day to day operations. What better way is there to achieve this than using the familiar, functional and trusted Oracle SQL Developer!

Oracle SQL Developer (since version 4.0.3) allows access to Apache Hive to create, alter and query hive tables and much more . Lets look at how to setup connections to Hive both with and without kerberos and once connected look at the available functionality.

CERN IT-DB group develops a new WebLogic Command Line Interface tool for CERN Java Middleware Services

Oracle WebLogic 12c introduced a new REST API for managing and monitoring several aspects of a domain in a lightweight and fast manner. These RESTful interfaces represent the current industry standard followed by the noteworthy and widely used Oracle WebLogic application server. Feature introduced some time ago, but improved in the current Server version, allows administrators to access the most important WebLogic Server runtime values using a simple URL. Having every reason to believe that the potential of WebLogic REST services and its maturity level is apparent, CERN decided to implement a CLI system for serving the interface, having regard to the security, testability and performance aspects. This article provides an indication of the potential of the new management API and offers a comprehensive overview of the WebLogic CLI system architecture that is being developed at CERN DB group.

Konrad Kaczkowski (IT-DB-IMS)


Subscribe to Databases at CERN blog