[ https://issues.apache.org/jira/browse/SPARK-30476?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
XiongCheng updated SPARK-30476: ------------------------------- Attachment: (was: SPARK-30885-master.patch) > NullPointerException when Insert data to hive mongo external table by > spark-sql > ------------------------------------------------------------------------------- > > Key: SPARK-30476 > URL: https://issues.apache.org/jira/browse/SPARK-30476 > Project: Spark > Issue Type: Bug > Components: SQL > Affects Versions: 2.4.3 > Environment: mongo-hadoop: 2.0.2 > spark-version: 2.4.3 > scala-version: 2.11 > hive-version: 1.2.1 > hadoop-version: 2.6.0 > Reporter: XiongCheng > Priority: Minor > Attachments: SPARK-30885-master.patch > > > I execute the sql,but i got a NPE. > result_data_mongo is a mongodb hive external table. > {code:java} > insert into result_data_mongo > values("1111111115","1111111115","1111111115",1111111115,"1111111115",1111111115,1111111115,1111111115,1111111115,1111111115,1111111115,1111111115,1111111115,1111111115,1111111115); > {code} > NPE detail: > {code:java} > org.apache.hadoop.hive.ql.metadata.HiveException: > java.lang.NullPointerException > at > org.apache.hadoop.hive.ql.io.HiveFileFormatUtils.getHiveRecordWriter(HiveFileFormatUtils.java:249) > at > org.apache.spark.sql.hive.execution.HiveOutputWriter.<init>(HiveFileFormat.scala:123) > at > org.apache.spark.sql.hive.execution.HiveFileFormat$$anon$1.newInstance(HiveFileFormat.scala:103) > at > org.apache.spark.sql.execution.datasources.SingleDirectoryDataWriter.newOutputWriter(FileFormatDataWriter.scala:120) > at > org.apache.spark.sql.execution.datasources.SingleDirectoryDataWriter.<init>(FileFormatDataWriter.scala:108) > at > org.apache.spark.sql.execution.datasources.FileFormatWriter$.org$apache$spark$sql$execution$datasources$FileFormatWriter$$executeTask(FileFormatWriter.scala:236) > at > org.apache.spark.sql.execution.datasources.FileFormatWriter$$anonfun$write$1.apply(FileFormatWriter.scala:170) > at > org.apache.spark.sql.execution.datasources.FileFormatWriter$$anonfun$write$1.apply(FileFormatWriter.scala:169) > at org.apache.spark.scheduler.ResultTask.runTask(ResultTask.scala:90) > at org.apache.spark.scheduler.Task.run(Task.scala:121) > at > org.apache.spark.executor.Executor$TaskRunner$$anonfun$10.apply(Executor.scala:408) > at org.apache.spark.util.Utils$.tryWithSafeFinally(Utils.scala:1360) > at org.apache.spark.executor.Executor$TaskRunner.run(Executor.scala:414) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) > at java.lang.Thread.run(Thread.java:748) > Caused by: java.lang.NullPointerException > at > com.mongodb.hadoop.output.MongoOutputCommitter.getTaskAttemptPath(MongoOutputCommitter.java:264) > at > com.mongodb.hadoop.output.MongoRecordWriter.<init>(MongoRecordWriter.java:59) > at > com.mongodb.hadoop.hive.output.HiveMongoOutputFormat$HiveMongoRecordWriter.<init>(HiveMongoOutputFormat.java:80) > at > com.mongodb.hadoop.hive.output.HiveMongoOutputFormat.getHiveRecordWriter(HiveMongoOutputFormat.java:52) > at > org.apache.hadoop.hive.ql.io.HiveFileFormatUtils.getRecordWriter(HiveFileFormatUtils.java:261) > at > org.apache.hadoop.hive.ql.io.HiveFileFormatUtils.getHiveRecordWriter(HiveFileFormatUtils.java:246) > ... 15 more > {code} > I know mongo-hadoop use the incorrect key to get TaskAttemptID,so I modified > the source code of mongo-hadoop to get the correct properties > ('mapreduce.task.id' and 'mapreduce.task.attempt.id'), but I still can't get > the value. I found that these parameters are stored in spark In > TaskAttemptContext, but TaskAttemptContext is not passed into > HiveOutputWriter, is this a design flaw? > here are two key point. > mongo-hadoop: > [https://github.com/mongodb/mongo-hadoop/blob/cdcd0f15503f2d1c5a1a2e3941711d850d1e427b/hive/src/main/java/com/mongodb/hadoop/hive/output/HiveMongoOutputFormat.java#L80] > spark-hive:[https://github.com/apache/spark/blob/7c7d7f6a878b02ece881266ee538f3e1443aa8c1/sql/hive/src/main/scala/org/apache/spark/sql/hive/execution/HiveFileFormat.scala#L103] > -- This message was sent by Atlassian Jira (v8.3.4#803005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org