Uploaded image for project: 'Sqoop (Retired)'
  1. Sqoop (Retired)
  2. SQOOP-3176

decompressing error while load 'gz' and 'bz2' data into table

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Won't Fix
    • None
    • None
    • None
    • None
    • spark 2.1.0

    Description

      import org.apache.spark.sql.SparkSession
      import org.apache.spark.sql.CarbonSession._
      val carbon = SparkSession.builder().config(sc.getConf).getOrCreateCarbonSession("hdfs://nsha/user/ranmx/test/carbon")
      carbon.sql("CREATE TABLE IF NOT EXISTS test_table(id string, name string, city string, age Int) STORED BY 'carbondata'")
      carbon.sql("LOAD DATA inpath '/ranmx/test/sh.csv.bz2' INTO TABLE test_table1")

      会报错:
      17/04/26 11:11:26 ERROR LoadTable: main
      java.lang.NullPointerException
      at org.apache.hadoop.io.compress.bzip2.Bzip2Factory.isNativeBzip2Loaded(Bzip2Factory.java:54)
      at org.apache.hadoop.io.compress.bzip2.Bzip2Factory.getBzip2DecompressorType(Bzip2Factory.java:120)
      at org.apache.hadoop.io.compress.BZip2Codec.getDecompressorType(BZip2Codec.java:242)
      at org.apache.hadoop.io.compress.CodecPool.getDecompressor(CodecPool.java:176)
      at org.apache.hadoop.io.compress.CompressionCodec$Util.createInputStreamWithCodecPool(CompressionCodec.java:157)
      at org.apache.hadoop.io.compress.BZip2Codec.createInputStream(BZip2Codec.java:157)
      at org.apache.carbondata.core.datastore.impl.FileFactory.getDataInputStream(FileFactory.java:139)
      at org.apache.carbondata.core.datastore.impl.FileFactory.getDataInputStream(FileFactory.java:104)
      at org.apache.carbondata.core.util.CarbonUtil.readHeader(CarbonUtil.java:1273)
      at org.apache.carbondata.spark.util.CommonUtil$.getCsvHeaderColumns(CommonUtil.scala:319)
      at org.apache.spark.sql.execution.command.LoadTable.run(carbonTableSchema.scala:474)
      ...

      Attachments

        Activity

          People

            Unassigned Unassigned
            ranmx Ran Mingxuan
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - 24h
                24h
                Remaining:
                Remaining Estimate - 24h
                24h
                Logged:
                Time Spent - Not Specified
                Not Specified