byzer-lang icon indicating copy to clipboard operation
byzer-lang copied to clipboard

load excel file on hdfs failed

Open chncaesar opened this issue 2 years ago • 0 comments

load statement

load excel.`/tmp/upload/example_en.xlsx` where header="true" as example_en_table;

Exception:

Your InputStream was neither an OLE2 stream, nor an OOXML stream
java.io.IOException: Your InputStream was neither an OLE2 stream, nor an OOXML stream
shadeio.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:258)
shadeio.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:221)
com.crealytics.spark.excel.DefaultWorkbookReader.$anonfun$openWorkbook$1(WorkbookReader.scala:49)
scala.Option.fold(Option.scala:251)
com.crealytics.spark.excel.DefaultWorkbookReader.openWorkbook(WorkbookReader.scala:49)
com.crealytics.spark.excel.WorkbookReader.withWorkbook(WorkbookReader.scala:14)
com.crealytics.spark.excel.WorkbookReader.withWorkbook$(WorkbookReader.scala:13)
com.crealytics.spark.excel.DefaultWorkbookReader.withWorkbook(WorkbookReader.scala:45)
com.crealytics.spark.excel.ExcelRelation.excerpt$lzycompute(ExcelRelation.scala:31)
com.crealytics.spark.excel.ExcelRelation.excerpt(ExcelRelation.scala:31)
com.crealytics.spark.excel.ExcelRelation.headerColumns$lzycompute(ExcelRelation.scala:102)
com.crealytics.spark.excel.ExcelRelation.headerColumns(ExcelRelation.scala:101)
com.crealytics.spark.excel.ExcelRelation.$anonfun$inferSchema$1(ExcelRelation.scala:163)
scala.Option.getOrElse(Option.scala:189)

File on HDFS: image

Same file , load statement, byzer-lang main jar and excel plguin work on VS code Extension

chncaesar avatar Apr 27 '22 08:04 chncaesar