kCGErrorFailure with BigSQL

So you are trying to start BigSQL on your mac and get the following error: java[5413] <Error>: kCGErrorFailure: Set a breakpoint @ CGErrorBreakpoint() to catch errors as they are logged. after trying to run the following command: hadoop namenode -format The issue may have to do with the combination of your OS and Java version [...]

By | September 6th, 2013|Categories: BigSQL, Java, OSX|Comments Off on kCGErrorFailure with BigSQL

Hadoop Thrift Tutorial

At OpenSCG we have been using thrift to make a Hadoop Foreign Data Wrapper. This tool, which is already integrated into BigSQL, allows you to take advantage of the power of Hadoop from within PostgreSQL. The BigSQL Tutorial show how you can easily create a postgres table that references a Hive or Hbase table, run [...]

By | August 21st, 2013|Categories: BigSQL, Cady PostgreSQL, FDW (Foreign Data Wrapper), Hadoop, Java, PostgreSQL, Python|Comments Off on Hadoop Thrift Tutorial

Announcing BigSQL 9.3 Beta 1.7

Our latest BigSQL Beta is now feature rich and stable. Powerful/simple/safe developers sandbox bundles are available for Linux and OSX. BigSQL leverages new features of PostgreSQL 9.3 to provide seamless & deep integration with Hadoop/Hive. The combined bundle gives you all the best OLTP features of standard ANSI PostgreSQL with all of the massive parallel [...]

By | June 11th, 2013|Categories: Big Data, BigSQL, Hadoop, Java, PostgreSQL|Comments Off on Announcing BigSQL 9.3 Beta 1.7

Announcing BenchmarkSQL 4.0

I've been working on this project for nine years now and it finally doesn't suck. :-) Thanks to Cady Motyka for finishing the work to rip out the annoying Swing GUI on this TPC-C like RDBMS Benchmark. It now runs wonderfully from the command-line and is useful for testing the performance of any RDBMS OLTP [...]

By | June 7th, 2013|Categories: BigSQL, community, Java, MySQL, PostgreSQL|Comments Off on Announcing BenchmarkSQL 4.0

A Java Based Command Line PortChecker

The below code snippet is a lovely little piece of Java magic the we use in various installation and configuration scenarios to verify if a port is available or busy [java] import*; import*; public class PortChecker { public static void main(String[] args) { int port=0; if (args.length == 1) { try { port [...]

By | April 7th, 2013|Categories: Java, tip|Comments Off on A Java Based Command Line PortChecker

Setting JAVA_HOME for JDK6 on Linux and OSX

Here is a useful little code snippet I use as part of BigSQL. [bash] if [ "x$JAVA_HOME" == "x" ]; then macosx_j6="/System/Library/Java/JavaVirtualMachines/1.6.0.jdk/Contents/Home" ubuntu_j6="/usr/lib/jvm/java-6-openjdk-amd64" redhat_j6="/usr/lib/jvm/java-1.6.0-openjdk.x86_64" if [ -d "$macosx_j6" ]; then export JAVA_HOME="$macosx_j6" elif [ -d "$ubuntu_j6" ]; then export JAVA_HOME="$ubuntu_j6" elif [ -d "$redhat_j6" ]; then export JAVA_HOME="$redhat_j6" else echo "WARNING: Cannot figure out JAVA_HOME." [...]

By | April 5th, 2013|Categories: BASH Code, Java, tip|Comments Off on Setting JAVA_HOME for JDK6 on Linux and OSX