{"action":"created","issue":{"url":"https://api.github.com/repos/ZuInnoTe/hadoopoffice/issues/25","repository_url":"https://api.github.com/repos/ZuInnoTe/hadoopoffice","labels_url":"https://api.github.com/repos/ZuInnoTe/hadoopoffice/issues/25/labels{/name}","comments_url":"https://api.github.com/repos/ZuInnoTe/hadoopoffice/issues/25/comments","events_url":"https://api.github.com/repos/ZuInnoTe/hadoopoffice/issues/25/events","html_url":"https://github.com/ZuInnoTe/hadoopoffice/issues/25","id":298597034,"number":25,"title":"Excel Read hadoopoffice","user":{"login":"pkvg","id":11185538,"avatar_url":"https://avatars1.githubusercontent.com/u/11185538?v=4","gravatar_id":"","url":"https://api.github.com/users/pkvg","html_url":"https://github.com/pkvg","followers_url":"https://api.github.com/users/pkvg/followers","following_url":"https://api.github.com/users/pkvg/following{/other_user}","gists_url":"https://api.github.com/users/pkvg/gists{/gist_id}","starred_url":"https://api.github.com/users/pkvg/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pkvg/subscriptions","organizations_url":"https://api.github.com/users/pkvg/orgs","repos_url":"https://api.github.com/users/pkvg/repos","events_url":"https://api.github.com/users/pkvg/events{/privacy}","received_events_url":"https://api.github.com/users/pkvg/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2018-02-20T13:39:45Z","updated_at":"2018-02-20T19:52:35Z","closed_at":null,"author_association":"NONE","body":"Hi, I am using hadoopoffice in my spark application. I have followed your steps and added the dependency in my pom.xml file.\r\n\r\n<dependency>\r\n<groupId>com.github.zuinnote</groupId> \r\n<artifactId>spark-hadoopoffice-ds_2.11</artifactId>\r\n<version>1.0.4</version> \r\n</dependency>\r\n\r\nwhen i run my program i receive the below error.\r\n\r\n18/02/20 13:13:00 WARN TaskSetManager: Lost task 0.0 in stage 2.0 (TID 3, 192.168.0.5, executor 1): java.lang.NullPointerException\r\n\tat org.apache.hadoop.conf.Configuration.<init>(Configuration.java:711)\r\n\tat org.apache.hadoop.mapred.JobConf.<init>(JobConf.java:436)\r\n\tat org.apache.hadoop.mapreduce.task.JobContextImpl.<init>(JobContextImpl.java:67)\r\n\tat org.apache.hadoop.mapreduce.task.TaskAttemptContextImpl.<init>(TaskAttemptContextImpl.java:49)\r\n\tat org.apache.hadoop.mapreduce.task.TaskAttemptContextImpl.<init>(TaskAttemptContextImpl.java:44)\r\n\tat org.zuinnote.spark.office.excel.HadoopFileExcelReader.<init>(HadoopFileExcelReader.scala:53)\r\n\tat org.zuinnote.spark.office.excel.DefaultSource$$anonfun$buildReader$2.apply(DefaultSource.scala:413)\r\n\tat org.zuinnote.spark.office.excel.DefaultSource$$anonfun$buildReader$2.apply(DefaultSource.scala:412)\r\n\tat org.apache.spark.sql.execution.datasources.FileFormat$$anon$1.apply(FileFormat.scala:138)\r\n\tat org.apache.spark.sql.execution.datasources.FileFormat$$anon$1.apply(FileFormat.scala:122)\r\n\tat org.apache.spark.sql.execution.datasources.FileScanRDD$$anon$1.nextIterator(FileScanRDD.scala:168)\r\n\tat org.apache.spark.sql.execution.datasources.FileScanRDD$$anon$1.hasNext(FileScanRDD.scala:109)\r\n\tat org.apache.spark.sql.catalyst.expressions.GeneratedClass$GeneratedIterator.agg_doAggregateWithoutKey$(Unknown Source)\r\n\tat org.apache.spark.sql.catalyst.expressions.GeneratedClass$GeneratedIterator.processNext(Unknown Source)\r\n\tat org.apache.spark.sql.execution.BufferedRowIterator.hasNext(BufferedRowIterator.java:43)\r\n\tat org.apache.spark.sql.execution.WholeStageCodegenExec$$anonfun$8$$anon$1.hasNext(WholeStageCodegenExec.scala:377)\r\n\tat scala.collection.Iterator$$anon$11.hasNext(Iterator.scala:408)\r\n\tat org.apache.spark.shuffle.sort.BypassMergeSortShuffleWriter.write(BypassMergeSortShuffleWriter.java:124)\r\n\tat org.apache.spark.scheduler.ShuffleMapTask.runTask(ShuffleMapTask.scala:96)\r\n\tat org.apache.spark.scheduler.ShuffleMapTask.runTask(ShuffleMapTask.scala:53)\r\n\tat org.apache.spark.scheduler.Task.run(Task.scala:99)\r\n\tat org.apache.spark.executor.Executor$TaskRunner.run(Executor.scala:322)\r\n\tat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)\r\n\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)\r\n\tat java.lang.Thread.run(Thread.java:748)\r\n\r\nI tried with all versions of org.apache.spark. I am unable to move further. Looks like JobConf value is passed as null.\r\n\r\nAlso which hadoop version is the library referring to JobConf? \r\n\r\nThis is really important to me in reading XLS or XLSX file. Appreciate your timely help in fixing this. \r\n\r\nThanks\r\n"},"comment":{"url":"https://api.github.com/repos/ZuInnoTe/hadoopoffice/issues/comments/367098552","html_url":"https://github.com/ZuInnoTe/hadoopoffice/issues/25#issuecomment-367098552","issue_url":"https://api.github.com/repos/ZuInnoTe/hadoopoffice/issues/25","id":367098552,"user":{"login":"jornfranke","id":1659364,"avatar_url":"https://avatars0.githubusercontent.com/u/1659364?v=4","gravatar_id":"","url":"https://api.github.com/users/jornfranke","html_url":"https://github.com/jornfranke","followers_url":"https://api.github.com/users/jornfranke/followers","following_url":"https://api.github.com/users/jornfranke/following{/other_user}","gists_url":"https://api.github.com/users/jornfranke/gists{/gist_id}","starred_url":"https://api.github.com/users/jornfranke/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jornfranke/subscriptions","organizations_url":"https://api.github.com/users/jornfranke/orgs","repos_url":"https://api.github.com/users/jornfranke/repos","events_url":"https://api.github.com/users/jornfranke/events{/privacy}","received_events_url":"https://api.github.com/users/jornfranke/received_events","type":"User","site_admin":false},"created_at":"2018-02-20T19:52:35Z","updated_at":"2018-02-20T19:52:35Z","author_association":"OWNER","body":"Another question: Do you have KyroSerialization activated?"}}
{"actor":{"display_login":"jornfranke"}}