Skip to main content

Hbase Connector Introduction

The HBase Connector is contributed by the community and supports Sink yet.

Syntax

CREATE TABLE hbase_table (
id BIGINT,
name VARCHAR,
age INT
) WITH (
type='hbase',
geaflow.dsl.hbase.zookeeper.quorum = '127.0.0.1',
geaflow.dsl.hbase.tablename = 'GeaFlowBase',
geaflow.dsl.hbase.rowkey.column = 'id'
);

Options

KeyRequiredDescription
geaflow.dsl.hbase.zookeeper.quorumtrueHBase zookeeper quorum servers list.
geaflow.dsl.hbase.namespacefalseHBase namespace.
geaflow.dsl.hbase.tablenametrueHBase table name.
geaflow.dsl.hbase.rowkey.columntrueHBase rowkey columns.
geaflow.dsl.hbase.rowkey.separatorfalseHBase rowkey join serapator.
geaflow.dsl.hbase.familyname.mappingfalseHBase column family name mapping.
geaflow.dsl.hbase.buffersizefalseHBase writer buffer size.

Example

CREATE TABLE file_source (
id BIGINT,
name VARCHAR,
age INT
) WITH (
type='file',
geaflow.dsl.file.path = '/path/to/file'
);

CREATE TABLE hbase_table (
id BIGINT,
name VARCHAR,
age INT
) WITH (
type='hbase',
geaflow.dsl.hbase.zookeeper.quorum = '127.0.0.1',
geaflow.dsl.hbase.tablename = 'GeaFlowBase',
geaflow.dsl.hbase.rowkey.column = 'id'
);

INSERT INTO hbase_table
SELECT * FROM file_source;