terastream

Terastream

JRuby client to query data from the Teradata data warehouse. Used in your own programs as a gem or via the terasql cli. The client takes a middleware based approach to formatting query results and streaming data to an output location.

Bundled formatter and output middlewares support formatting results as

• Ruby objects
• JSON records
• lines of CSV

and streaming results to

• STDOUT
• Kafka
• Redis pub/sub

Installation

• install JRuby (9.0.0.0 preferred)
• Check out the repo
• rake install
• ????
• profit

If it's been pushed to a gem server:

Add this line to your application's Gemfile:

gem 'terastream'

And then execute:

$ bundle

Or install it yourself as:

$ gem install terastream

Usage

If using Terastream in your own application:

client = Terastream.new do |connection|
  connection.username  = "something"
  connection.password  = "password"
  connection.hostname  = "somehost.somwhere"
  connection.formatter = Terastream::JsonBuilder
  connection.output    = Terastream::Output::Redis
end

results = client.query("SELECT * FROM sometable")
results.each do |result|
  p result.field
end

Or using the terasql command line utility

terasql --username username --password password --host somehost.somewhere --formatter json --output redis --query "SELECT * FROM sometable"

Todo

• Support for Amazon Kinesis as a results destination
• Support for DDL files being run before final query execution

Warning

ALPHA SOFTWARE!!!!!

Contributing

• Fork it ( https://github.com/[my-github-username]/terastream/fork )
• Create your feature branch (git checkout -b my-new-feature)
• Commit your changes (git commit -am 'Add some feature')
• Push to the branch (git push origin my-new-feature)
• Create a new Pull Request