You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "XiongCheng (Jira)" <ji...@apache.org> on 2020/01/23 02:47:00 UTC
[jira] [Commented] (SPARK-30476) NullPointerException when Insert
data to hive mongo external table by spark-sql
[ https://issues.apache.org/jira/browse/SPARK-30476?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17021709#comment-17021709 ]
XiongCheng commented on SPARK-30476:
------------------------------------
[~hyukjin.kwon]Thanks for your reply~.However, my doubt is why mapreduce.task.attempt.id is not passed into the HiveOutputWriter, so that mongo-hadoop cannot get mapreduce.task.attempt.id. I also tried to fix this myself, extracted mapreduce.task.attempt.id and merged it with jobConf.value,It works~
> 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: Major
>
> 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-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org