Spark: How to use HBase filter e.g QualiferFilter

Question

I want to get rows from HBase by using filter like QualiferFilter at python-api.
I know the way to get rows from HBase like under the code.

host = 'localhost'
keyConv = "org.apache.spark.examples.pythonconverters.ImmutableBytesWritableToStringConverter"
valueConv = "org.apache.spark.examples.pythonconverters.HBaseResultToStringConverter"
conf = {"hbase.zookeeper.quorum": host, "hbase.mapreduce.inputtable": "user",
                "hbase.mapreduce.scan.columns": "u:uid",
                "hbase.mapreduce.scan.row.start": "1", "hbase.mapreduce.scan.row.stop": "100"}
rdd = sc.newAPIHadoopRDD("org.apache.hadoop.hbase.mapreduce.TableInputFormat",
                             "org.apache.hadoop.hbase.io.ImmutableBytesWritable",
                         "org.apache.hadoop.hbase.client.Result",
                         keyConverter=keyConv, valueConverter=valueConv, conf=conf)

But, I also want to get rows by using filters.
What type of codes do I need to add?

Answer 1

Hello you can check this code................

def  doYourStuff(row):
     text = row.split("\n")
     data = {} 
     for row in text:
        if json.loads(row)["qualifier"] == "message":
              data["message"] = json.loads(row)["value"]
        if json.loads(row)["qualifier"] == "domain":
              data["domain"] = json.loads(row)["value"]
        data["rowKey"] = json.loads(row)["row"]
      return DoWhatYouWantToDo(data)

    def save_record(rdd):
        host = '172.31.@@.@@'
        table = 'TableName'
        keyConv1 = "org.apache.spark.examples.pythonconverters.StringToImmutableBytesWritableConverter"
        valueConv1 = "org.apache.spark.examples.pythonconverters.StringListToPutConverter"
        conf = {"hbase.zookeeper.quorum": host,
                "hbase.mapred.outputtable": table,
                "mapreduce.outputformat.class": "org.apache.hadoop.hbase.mapreduce.TableOutputFormat",
                "mapreduce.job.output.key.class": "org.apache.hadoop.hbase.io.ImmutableBytesWritable",
                "mapreduce.job.output.value.class": "org.apache.hadoop.io.Writable"}
         rdd.saveAsNewAPIHadoopDataset(
            keyConverter=keyConv1, valueConverter=valueConv1,conf=conf)


    hbaseRdd = hbaseRdd.map(lambda x: x[1])  # message_rdd = hbase_rdd.map(lambda x:x[0]) will give only row-key

    processedRdd = hbaseRdd.map(lambda x: doYourStuff(x))
    save_record(processedRdd)