Skip to content
gerritjvv edited this page May 17, 2012 · 2 revisions

DLL

INSERT INTO

INSERT INTO [tableName] (col, col2 ...) STDIN

This will read tab separated lines from the STDIN and insert into hbase.

The code takes care of compound keys and columns.

CREATE TABLE

CREATE [HBASE] TABLE [tableName] [tableDefinition]

Creates a table in the SimpleSQL catalog.

Tables can have types:

  • HBASE

More types can be added

The types are matched to a table engine class in the /opt/aggregator/conf/engines file

TableEngine

Methods:

  • select
  • create
  • delete
  • insert

Clone this wiki locally