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;