Monthly Archives: February 2015

Querying Hadoop from SQL Server

SQL Server 2012 | SQL Server 2014 Microsoft’s Analytics Platform System (APS) offers built in transparent access to Hadoop data sources through the Polybase technology. This includes bidirectional access not only to Hadoop but also to Cloud services. The SMP … Continue reading

Posted in Allgemein | Leave a comment

Hive file format comparison

Apache Hive 0.11+ in this post I’d like to compare the different file formats for Hive, as well as the different execution times for queries depending on the file format, compression and execution engine. As for the data, I’m using … Continue reading

Posted in Allgemein | Leave a comment

Geo spatial data support for Hive

Hive 0.1x Apache Hive doesn’t have support for geo spatial functions out of the box. However, it’s easy to extend the functionality by using external libraries, that can be called via user defined functions (UDFs). This post shows how to … Continue reading

Posted in Allgemein | Leave a comment

PowerBI Dashboard Public Preview

PowerBI PowerBI Dashboard is a new interactive dashboard and visualization platform that enables end users to select and visualize the information they are most interested in. No support from IT is needed to build the dashboard and for me, this … Continue reading

Posted in Allgemein | Leave a comment