spark 读取Hbase数据直接生成rdd

package com.lenovo.hbaseToMysql

import java.util.Properties

import com.lenovo.Utils.MysqlSession
import org.apache.hadoop.hbase.HBaseConfiguration
import org.apache.hadoop.hbase.client._
import org.apache.hadoop.hbase.io.ImmutableBytesWritable
import org.apache.hadoop.hbase.mapreduce.TableInputFormat
import org.apache.hadoop.hbase.util.Bytes
import org.apache.spark.sql.{SaveMode, SparkSession}

object HbaseToMysql {
  def main(args: Array[String]): Unit = {
    val ss = SparkSession
      .builder()
      .appName("HbaseToMysql ")
      .master("yarn")
      .getOrCreate()

    // HBase成产库
    val tableName = "upp:upp_user_profile"
    //Hbase客户端配置参数
    val masterPort = "60000"
    val zookeeperClientPort = "2181"
    val zookeeperQuorum = "node73.it.leap.com,node75.it.leap.com,node76.it.leap.com,node81.it.leap.com,node82.it.leap.com"
    val zookeeperZnodeParent = "/hbase-unsecure"

    //设置Hbase配置
    val conf = HBaseConfiguration.create()
    conf.set("hbase.master.port", masterPort)
    conf.set("hbase.zookeeper.property.clientport", zookeeperClientPort)
    conf.set("hbase.zookeeper.quorum", zookeeperQuorum)
    conf.set("zookeeper.znode.parent", zookeeperZnodeParent)
    conf.set(TableInputFormat.INPUT_TABLE, tableName)

    val sc = ss.sparkContext
    val hbase_data = sc.newAPIHadoopRDD(conf,classOf[TableInputFormat],classOf[ImmutableBytesWritable],classOf[Result])

    val tb_upp_Attitude = hbase_data.map(line => {
      val rowkey = Bytes.toString(line._2.getRow)
      val complaint = Bytes.toString(line._2.getValue(Bytes.toBytes("attitude"), Bytes.toBytes("complaint")))
      val praise = Bytes.toString(line._2.getValue(Bytes.toBytes("attitude"),Bytes.toBytes("praise")))
      val urgency = Bytes.toString(line._2.getValue(Bytes.toBytes("attitude"),Bytes.toBytes("urgency")))

      (rowkey,complaint,praise,urgency)
    }).toDF("user_name","complaint","praise","urgency")
  }
}

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

不会飞的乌龟

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值