byzer-lang
byzer-lang copied to clipboard
load excel file on hdfs failed
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:
Same file , load statement, byzer-lang main jar and excel plguin work on VS code Extension