Oracle has a great feature called flashback query. This allows a user to (try to) query a row as it existed at some point in the past. It provides this functionality by trying to find the necessary UNDO to reconstruct…
Month: July 2011
Printing all property values in an HBase configuration
I’m sure there is an easier (perhaps built-in) way to do this, but for now, I wanted to document how you can print all properties for a given configuration that you load into a JVM. import java.util.*; import org.apache.hadoop.hbase.*; import…
Loop through and print directory size
Set objShell = CreateObject(“WScript.Shell”) Set objFSO = CreateObject(“Scripting.FileSystemObject”) Set objFolder = objFSO.GetFolder(“C:\”) Set colSubfolders = objFolder.Subfolders For Each objSubfolder in colSubfolders on error resume next Wscript.Echo objSubfolder.Name, objSubfolder.Size Next
Simple HBase stress tester
What is below is a simple class to read a random set of records from a table. This should be a good start if you are looking for a simple one class test case, that may also be useful for…
Simple HBase class to load data
What is below is a simple java class to load the customers table we created in a previous post import java.util.*; import org.apache.hadoop.hbase.client.*; import org.apache.hadoop.hbase.util.*; public class putHbase { public static void main(String[] args) throws Exception { HTable hTable =…
Bridging the gap…from SQL to No SQL
For any DBA’s that have had someone call them and ask “What do you know about NoSQL?”, this post is specifically intended. Before you have a conniption fit and began quoting Tom Kyte-ism’s (an exceptionally smart guy, if you do…