Big Data

/Big Data

Stinger Delivers Fast Hive SQL via YARN & TEZ

The latest BigSQL bundle now includes Stinger and Tez to dramatically improve performance and extend the SQL dialect. In the latest distribution of BigSQL Release 2, it is extremely easy to get started exploring Tez and Stinger in your own sandbox environment. Taking advantage of YARN, Stinger is now delivering on its three main goals [...]

By | March 12th, 2014|Big Data, BigSQL, OpenSCG|Comments Off on Stinger Delivers Fast Hive SQL via YARN & TEZ

BigSQL Adds Cassandra to the Hadoop and PostgreSQL Bundle

The BigSQL developer's bundle has added a significant new component: Cassandra 2.0.4.  All of the bundles and VM's now allow developers to get up and running with the latest Hadoop ecosystem and Cassandra.   Join our free Beta program now!   As a significant number of our clients are leveraging Cassandra for Highly Available Multi Partition [...]

By | January 16th, 2014|Big Data, BigSQL, FDW (Foreign Data Wrapper), Hadoop, OpenSCG, PostgreSQL|Comments Off on BigSQL Adds Cassandra to the Hadoop and PostgreSQL Bundle

BigSQL Hadoop + Postgres now Available as a VM

With the continued success of the BigSQL developer's bundle, we are proud to announce the availability of a new VM image with BigSQL preinstalled.  Primarily created to provide our Windows friends access to the technology bundle, the Image is based on CentOS 6.4 Desktop including many tools to begin exploring today.  Join our free Beta [...]

By | November 20th, 2013|Big Data, BigSQL, Global Development, Hadoop, OpenSCG, OpenSource|Comments Off on BigSQL Hadoop + Postgres now Available as a VM

PostgreSQL, Hadoop, and Pentaho to Analyze and Visualize Data

This tutorial shows how to use Postgres, Hadoop, Hive, Hbase, and Pig to load, refine, and store big data for visualization- all in fewer than five minutes. You can watch the BigSQL, Postgres + Hadoop, Pentaho Demo here or follow along with the written version below. [youtube url="http://www.youtube.com/watch?v=eSEe_33pImA" fs="1" rel="0"] The following tutorial shows the scripts [...]

By | September 30th, 2013|Big Data, BigSQL, Cady PostgreSQL, FDW (Foreign Data Wrapper), Hadoop, PostgreSQL, presentation|Comments Off on PostgreSQL, Hadoop, and Pentaho to Analyze and Visualize Data

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|Big Data, BigSQL, Business Intelligence, Hadoop, OpenSCG|Comments Off on JasperReports with Hadoop – Tutorial

HadoopFDW

With the release of PostgreSQL 9.3, it let's us do some really cool things with writable foreign tables. BigSQL has just released a Hadoop Foreign Data Wrapper that is writable into HDFS files and Hbase tables. The Hbase integration allows for full SELECT, INSERT, UPDATE and DELETE syntax through PostgreSQL and the HDFS integration allows [...]

By | September 18th, 2013|Big Data, BigSQL, FDW (Foreign Data Wrapper), Jim PostgreSQL|Comments Off on HadoopFDW

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 [...]

By | September 16th, 2013|Big Data, BigSQL, Business Intelligence, Hadoop|Comments Off on Tutorial – Run BIRT against Hadoop

The Three “V”s of Big Data

Big Data. What's the big deal, really? Data has been around for a long time, and organizations have been using it to their advantage since for ever. So what is so different now? Legitimate questions from anyone who is sick of hearing all the hype around Big Data. Granted, you will come across many instances [...]

By | July 31st, 2013|Big Data, BigSQL, Business Intelligence, Hadoop|Comments Off on The Three “V”s of Big Data

Hadoop Sqoop Tutorial HDFS Hive & Postgres

The Hadoop Sqoop Tutorial is the third in the series providing easy to follow examples of using a Hadoop cluster in conjunction with Postgres.  This tutorial will build on the Hadoop Hive Tutorial which should be considered a pre requisite if you want to run the examples provided. In this tutorial, we will create a Postgres table from public domain [...]

By | July 10th, 2013|Big Data, BigSQL, Hadoop, OpenSCG, OpenSource, PostgreSQL|Comments Off on Hadoop Sqoop Tutorial HDFS Hive & Postgres

BI and Hadoop

The Data Warehousing Institute anticipates that Hadoop technologies will soon become a common and valuable complement to established products and practices for BI (http://tdwi.org/research/2013/04/tdwi-best-practices-report-integrating-hadoop-into-business-intelligence-and-data-warehousing.aspx). Increasingly, data conscious businesses are putting their BI groups under pressure for all sorts of data and analytics. Where, some time back, a weekly report summarizing a few select KPIs was [...]

By | July 10th, 2013|Big Data, BigSQL, Business Intelligence, Hadoop|Comments Off on BI and Hadoop