Tutorial

/Tag:Tutorial

Install PostgreSQL 10 Today

Hey, have you heard? PostgreSQL 10 Beta is road ready! Kick the tires and take the cool new features and improvements out for a spin. Highlights include: Declarative Partitioning Logical Replication SCRAM Authentication See the full list of features here. Take the easy route Never used the BigSQL PostgreSQL Distributions before? Follow these 5 easy [...]

By | May 19th, 2017|Categories: Holly PostgreSQL|Tags: , , , , , , , , |2 Comments

Installing pgDevOps

Install in 6 easy steps Never used the BigSQL PostgreSQL Distributions before? Follow these 5 easy steps. Already have BigSQL pgc installed? Jump to step #3. Read this short introduction to BigSQL's package and update manager (pgc). Install pgc via command line to a sandbox: MAC / Linux: python -c "$(curl -fsSL http://s3.amazonaws.com/pgcentral/install.py)" Windows: @powershell [...]

ETL (Extract, Transform, Load) PostGIS Data with ogr2ogr

In an earlier post, I showed you how to use the shp2pgsql tool to import shapefiles into PostGIS. But what if you need to import other geodata formats (e.g. GeoJSON, MapInfo, KML, CSV, etc.)? ogr2ogr - ETL for PostGIS Lucky for you, the BigSQL PostGIS distribution comes bundled with GDAL and the ogr2ogr (or as [...]

By | April 24th, 2017|Categories: Holly PostGIS, Holly PostgreSQL|Tags: , , , , , |2 Comments

Importing Shapefiles into PostGIS with shp2pgsql

Geojson may be catching up, but by and far the most popular data format for sharing geospatial data is (and has been since the early 1990's) the shapefile. Although a shapefile is a simple way to share data that can be easily consumed by almost any GIS system, it comes with many limitations and is [...]

By | March 23rd, 2017|Categories: Holly PostGIS, Holly PostgreSQL|Tags: , , |1 Comment

Tutorial on running Crystal Reports with BigSQL in Eclipse

1. Pre Requsites to run this tutorial: a) BigSQL Tutorial The BigSQL tutorial is required to be followed till the first three steps from the following link http://www.bigsql.org/se/tutorial.jsp Step 1 : Creating example.customer_history in HIVE and loading values. Step 2 : Creating example.customer_history as foreign table in Postgres Step 3 : Verifying example.customer_history b) Eclipse [...]

By | October 4th, 2013|Categories: BigSQL, Hadoop|Tags: , , , , , , |Comments Off on Tutorial on running Crystal Reports with BigSQL in Eclipse

JasperReports with Hadoop – Tutorial

This tutorial covers step by step instruction on running Jasper Reports with Hadoop using Jaspersoft Studio easy and simple to use environment . Also, publishing the created sample report with Jasperserver that is connected to Jaspersoft Studio . 1. Prerequisites a) BigSQL Tutorial is required to be followed till Step 3 http://www.bigsql.org/se/tutorial.jsp Step 1 : Creating example.customer_history [...]

By | September 25th, 2013|Categories: Big Data, BigSQL, Hadoop, OpenSCG|Tags: , , , , , |Comments Off on JasperReports with Hadoop – Tutorial

Tutorial – Run BIRT against Hadoop

This tutorial covers setting up of BIRT (Business Intelligence Reporting Tool) to run against Hadoop. BIRT is a relatively simple and yet powerful analytics tool and the tutorial will help you harness the power against Hadoop. 1. Pre-Requisites BigSQL Tutorial The BigSQL Tutorial (http://www.bigsql.org/se/tutorial.jsp) needs to be followed till step 3 Step 1 : Creating example.customer_history [...]