spark + sftp

1,读取本地图片,并上传至SFTP
  val file = new File("/mnt/data/hdd4/yarn/local/usercache/IT_bigdata/appcache/tag1200.jpg")
    val img = ImageIO.read(file)
    val baos = new ByteArrayOutputStream()
    ImageIO.write(img, "jpg", baos)

    val byte = baos.toByteArray
    val input01 = new ByteArrayInputStream(byte)

    channel.put(input01, s"/bigdata/B3I_D63" + "/" + "yy123254.jpg")

二:spark读取卡夫卡中数据写入SFTP,图片类型为BASE64转码后的格式

 try {
      df.collect().foreach {
        row => {
          logger.info("begining----row----")
          val picName = row.getString(0)
          val filedata64 = row.getString(1)
          val sftpFile = s"/dir" + "/" + picName
          val input = new ByteArrayInputStream(Base64.getDecoder.decode(filedata64))
          channel.put(input, sftpFile)
          input.close()
        }
      }
    } catch {
      case e: Exception =>
        e.printStackTrace()
    } finally {
      session.disconnect()
      channel.disconnect()
      logger.info("-------close----")
    }

三:非图片格式

   df.write
      .format("com.springml.spark.sftp")
      .option("host", host)
      .option("username", username)
      .option("password", password)
      .option("header", false)
      .option("fileType", "txt") // Text data source supports only a single column, and you have 3 columns.
      .mode("append")
      .save(sftpFile)

  • 0
    点赞
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
spark 读取 linux sftp上的文本文件,原jar只支持josn,csv等,增加bcp,txt文件的支持 下面是例子: public static void main(String[] args) throws Exception { SparkConf conf = new SparkConf().setMaster("local").setAppName("SparkDataFrame"); JavaSparkContext javacontext = new JavaSparkContext(conf); SQLContext sqlContext = new SQLContext(javacontext); Dataset<Row> df = sqlContext.read(). format("com.springml.spark.sftp"). option("host", "192.168.1.3"). option("username", "root"). option("password", "111111"). option("fileType", "bcp"). load("/sparktest/sparkfile0.bcp"); /*List<Row> list = df.collectAsList(); for(Row row:list){ String[] words = new String(row.getString(0).getBytes(),0,row.getString(0).length(),"UTF-8").split(" ",-1); for(int i=0;i<words.length;i++){ System.out.println("words==="+words[i]); } }*/ JavaRDD<Row> rowRdd = df.javaRDD(); JavaRDD<Row> words_bcp= rowRdd.map(new Function<Row, Row>() { @Override public Row call(Row row) throws Exception { // TODO Auto-generated method stub String line = row.getString(0); String[] words = new String(line.getBytes(),0,line.getBytes().length,"utf-8").split(" ",-1); return RowFactory.create(words); } }); List<Row> list = words_bcp.collect(); for(Row row:list){ System.out.println("row1=="+row.getString(0)); } df.write().format("com.springml.spark.sftp"). option("host", "192.168.1.3"). option("username", "root"). option("password", "111111"). option("fileType", "bcp"). save("/sparktest/luozhao.bcp"); df.show(); javacontext.close(); }
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

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

余额充值