title: Spark Structured Streaming with Hbase integration
body: <p>We are doing streaming on kafka data which being collected from MySQL. Now once all the analytics has been done i want to save my data directly to Hbase. I have through the spark structured streaming document but couldn't find any sink with Hbase. Code which I used to read the data from Kafka is below.</p>
  
  <pre><code> val records = spark.readStream.format("kafka").option("subscribe", "kaapociot").option("kafka.bootstrap.servers", "XX.XX.XX.XX:6667").option("startingOffsets", "earliest").load
   val jsonschema = StructType(Seq(StructField("header", StringType, true),StructField("event", StringType, true)))
   val uschema = StructType(Seq(
               StructField("MeterNumber", StringType, true),
               StructField("Utility", StringType, true),
               StructField("VendorServiceNumber", StringType, true),
               StructField("VendorName", StringType, true),
               StructField("SiteNumber",  StringType, true),
               StructField("SiteName", StringType, true),
               StructField("Location", StringType, true),
               StructField("timestamp", LongType, true),
               StructField("power", DoubleType, true)
               ))
   val DF_Hbase = records.selectExpr("cast (value as string) as Json").select(from_json($"json",schema=jsonschema).as("data")).select("data.event").select(from_json($"event", uschema).as("mykafkadata")).select("mykafkadata.*")
  </code></pre>
  
  <p>Now finally, I want to save DF_Hbase dataframe in hbase.</p>