MicroStrategy Desktop connect to Impala

Environment: MicroStrategy Desktop 10.11 Cloudera CDH 5.12 Impala 2.x Steps to connect MicroStrategy Destop to Cloudera Impala: Best thing about MicroStrategy Desktop unlike Tableau Desktop is it is free to download and use and a powerful BI visualization/query tool. Tableau Public Desktop is free but it only has few connectors and cannot connect to Hadoop … Continue reading MicroStrategy Desktop connect to Impala


ESRI-GIS Tools for Hadoop

The ESRI GIS Tools for Hadoop are a collection of GIS tools for spatial analysis of big data. References: https://github.com/Esri/gis-tools-for-hadoop/tree/master/samples/point-in-polygon-aggregation-hive   Aggregation Sample for Hive: point-in-polygon-aggregation-hive The following steps are taken from the above reference. Step-1: Make a folder anywhere in your local server where hive is installed: $mkdir /tmp/esri-git Step-2: Bring down the git repository: … Continue reading ESRI-GIS Tools for Hadoop

Elasticsearch notes

Elasticsearch vs RDBMS concepts: You can (roughly) think of an Elastic index like a RDBMS database.   MySQL => Databases => Tables => Rows=>Columns Elasticsearch => Indices(database) => Types(tables) => Documents(rows) with Properties(columns) An Elasticsearch cluster can contain multiple Indices (databases), which in turn contain multiple Types(tables). These types hold multiple Documents (rows), and each document has Properties(columns). A ES mapping … Continue reading Elasticsearch notes