Typo in the column name of the loaderMap for the table Causes OraLoaderException
(Doc ID 1456330.1)
Last updated on FEBRUARY 03, 2022
Applies to:
Oracle Loader for Hadoop - Version 1.1.0 and laterLinux x86-64
Symptoms
Running a job with Oracle Loader for Hadoop and receiving the following exception:
Exception in thread "main" oracle.hadoop.loader.OraLoaderException: load target column "N2" does not exist in the table "TARGET_TAB"
at oracle.hadoop.loader.metadata.OraLoaderMetadata.correlateLoaderMap(OraLoaderMetadata.java:958)
at oracle.hadoop.loader.metadata.OraLoaderMetadata.<init>(OraLoaderMetadata.java:602)
at oracle.hadoop.loader.OraLoader.run(OraLoader.java:372)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
at oracle.hadoop.loader.OraLoader.main(OraLoader.java:734)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.hadoop.util.RunJar.main(RunJar.java:197)
at oracle.hadoop.loader.metadata.OraLoaderMetadata.correlateLoaderMap(OraLoaderMetadata.java:958)
at oracle.hadoop.loader.metadata.OraLoaderMetadata.<init>(OraLoaderMetadata.java:602)
at oracle.hadoop.loader.OraLoader.run(OraLoader.java:372)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
at oracle.hadoop.loader.OraLoader.main(OraLoader.java:734)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.hadoop.util.RunJar.main(RunJar.java:197)
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 |