SQL on OTS

GetRow

message GetRowRequest {
    required string table_name = 1;
    repeated Column primary_key = 2;
    repeated string columns_to_get = 3;
    optional ColumnCondition filter = 4;
}

=>

SELECT attr1, attr2, attr3 FROM table WHERE pk1 = ? and pk2 = ? and pk3 = ? and pk4 = ?

API design:

ots.query(sql, filter);

CreateTable

message CreateTableRequest {
    required TableMeta table_meta = 1;
    required ReservedThroughput reserved_throughput = 2;
}

CREATE TABLE tbl {
  pk1 type,
  pk2 type,
  pk3 type,
  ...
}

ListTable

message ListTableRequest {
}

=>

show tables

API design:

ots.query('show tables');

DescribeTable

desc tbl

ots.query('desc tbl');