Support Questions
Find answers, ask questions, and share your expertise

regex pattern for flume-hbase

regex pattern for flume-hbase

Explorer

I have data coming into flume which I want to go into three columns in a column family in a hbase table.

The data pattern is like :

A000052019-01-02:13:14:260000000SG

First six digits are id. next 19 digits are date time. Last 9 digits are code.

I need to know what to put in the flume configuration parameter r_hbase.sinks.sink1.serializer.regex - as below :

r_hbase.sinks.sink1.table = mnew:r_test

r_hbase.sinks.sink1.columnFamily = me_data

r_hbase.sinks.sink1.serializer=org.apache.flume.sink.hbase.RegexHbaseEventSerializer

r_hbase.sinks.sink1.serializer.regex=

r_hbase.sinks.sink1.serializer.colNames=me_data:id,me_data:date,me_data:code

Appreciate the help.