How to read .csv file using BlobId

Question

Below is my code that returning NullPointer exception. but reading using fileReader it is returning value as expected.

var readChannel:ReadChannel  = storage.reader(blobId)
var excelFileRead:InputStream =  Channels.newInputStream(readChannel)
var br:BufferedReader = new BufferedReader(new InputStreamReader(excelFileRead))
var csvReader: CSVReader = new CSVReader(br)
csvReader.readNext

Please provide proper Java code, and also the complete stacktrace for the exception. (With the question in its current form, the best we can do is to close it as a dup of the canonical question on fixing NPEs.) — Stephen C
– Stephen C, Commented Feb 10, 2021 at 11:38
2021-02-15 11:42:35.958+0530 XAV-602000112 67128 [http-nio-8084-exec-1] ERROR o.a.c.c.C.[.[.[.[dispatcherServlet] - Servlet.service() for servlet [dispatcherServlet] in context with path [/galileo/api/v1] threw exception [Request processing failed; nested exception is java.lang.NullPointerException] with root cause java.lang.NullPointerException: null at scala.collection.mutable.ArrayOps$ofRef$.length$extension(ArrayOps.scala:192) at scala.collection.mutable.ArrayOps$ofRef.length(ArrayOps.scala:192) at scala.collection.IndexedSeqOptimized$class.foreach(IndexedSeqOptimized.scala:32) — avinash kumar tiwari
– avinash kumar tiwari, Commented Feb 15, 2021 at 6:16

avinash kumar tiwari · Accepted Answer · 2021-02-18 06:21:26Z

1

Please find the beow code that is working fine for me:-Initially i was using CsvReader that was returning the null value but it is working fine with BufferReader as shown below.

  def getHeaderFromFile(blobId: BlobId,storage: Storage): Array[String] = {
   val readChannel:ReadChannel  = storage.reader(blobId)
   val excelFileRead:InputStream =  Channels.newInputStream(readChannel)
   val br:BufferedReader = new BufferedReader(new InputStreamReader(excelFileRead))
   val header:String = br.readLine()
   val headers: Array[String] = header.split(",")
    headers
  }

answered Feb 18, 2021 at 6:21

avinash kumar tiwari

233 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to read .csv file using BlobId

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related