My Oracle Support Banner

H2H Failed With Spark Execution Engine Mode (Doc ID 2752841.1)

Last updated on FEBRUARY 22, 2021

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.7 and later
Information in this document applies to any platform.

Symptoms

On : 8.0.7.4 version .

ACTUAL BEHAVIOR
---------------

After upgrading to 8074, H2H with spark is failing on partitioned tables

EXPECTED BEHAVIOR
-----------------------
H2H execution should be successful.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:


1.Define a H2H on partitioned tables

2.execute the H2H

3.It fails with below error: Error executing statement : org.apache.spark.SparkException: Dynamic partition strict mode requires at least one static partition column. To turn this off set hive.exec.dynamic.partition.mode=nonstrict


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, unable to execute H2H

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.