Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • Common Content for Data Engineering 10.2.2 HotFix 1
  • All Products

Table of Contents

Search

  1. Abstract
  2. 10.2.2 HotFix 1 Installation and Upgrade
  3. 10.2.2 HotFix 1 Fixed Limitations
  4. 10.2.2 HotFix 1 Known Limitations
  5. 10.2.2 Service Pack 1 Fixed Limitations
  6. 10.2.2 Service Pack 1 Known Limitations
  7. 10.2.2 Fixed Limitations and Closed Enhancements
  8. 10.2.2 Known Limitations
  9. Emergency Bug Fixes Merged into 10.2.2 HotFix 1
  10. Informatica Global Customer Support

Big Data Release Notes

Big Data Release Notes

Back Next

Third-Party Known Limitations (10.2.2)

Third-Party Known Limitations (10.2.2)

The following table describes known limitations:
Bug
Description
OCON-9943
If you configure Sqoop to import time data from a Netezza database, the mapping fails.
Apache ticket reference number: SQOOP-2978
OCON-8786
If you configure Sqoop to export data of the Clob or DBClob data type to IBM DB2 z/OS targets, the mapping fails.
OCON-8561
If you configure Sqoop to export data of the Money data type to Microsoft SQL Server targets, the mapping fails.
OCON-8387
If you configure TDCH and Sqoop and run a mapping on the Blaze or Spark engine to export data of the Time data type, only milliseconds are written to the target. The nanosecond part is truncated.
Cloudera ticket reference number: 124306
OCON-8332
If you configure Sqoop to export data of the Clob or DBClob data type to IBM DB2 targets, the mapping fails.
OCON-7974
If you configure Sqoop and a column name contains spaces, the mapping fails.
Apache ticket reference number: SQOOP-2737
OCON-7620
If you import data from an IBM DB2 source through Sqoop and the table name contains mixed case characters, the mapping fails.
Sqoop JIRA issue number: SQOOP-3211
OCON-7505
Sqoop mappings that read byte or varbyte data from a Teradata source and write it to a Teradata target fail on the Blaze engine. This issue occurs if you use Cloudera Connector Powered by Teradata.
Cloudera ticket reference number: 124305
OCON-7504
When you use Sqoop to read data of the Timestamp data type from a Teradata source and write it to a Teradata target, only milliseconds are written to the target. This issue occurs if you run the Teradata Parallel Transporter mapping on a Cloudera cluster and on the Blaze engine.
Cloudera ticket reference number: 124302
OCON-7503
When you use Sqoop to read time data from a Teradata source and write it to a Teradata target, the fractional seconds get corrupted. This issue occurs if you use Cloudera Connector Powered by Teradata or Hortonworks Connector for Teradata, and run the mapping on the Blaze engine.
Cloudera ticket reference number: 124306
OCON-7459
When you export data to an IBM DB2 target through Sqoop, the mapping fails if all of the following conditions are true:
  • You create or replace the IBM DB2 target table at run time.
  • The IBM DB2 target table name or column names contain mixed case characters.
  • You run the mapping on a Cloudera 5u8 cluster.
Apache ticket reference number: SQOOP-3212
OCON-7431
When you read time data from a Teradata source and write it to a Teradata target, the fractional seconds get corrupted. This issue occurs if you run the Teradata Parallel Transporter mapping on a Hortonworks cluster and on the Blaze engine.
Cloudera ticket reference number: 124302
OCON-7219
When you run a Sqoop mapping on the Blaze engine to export Teradata float data, the data is truncated after the decimal point.
Cloudera support ticket number: 113716
OCON-7214
Sqoop mappings fail on the Blaze engine if you use a custom query with the Order By clause to import data.
Sqoop JIRA issue number: SQOOP-3064
OCON-7213
The Sqoop program does not honor the --num-mappers argument and -m argument when you export data and run the mapping on the Blaze or Spark engine.
Sqoop JIRA issue number: SQOOP-2837
OCON-7211
When you run a Sqoop mapping to import data from or export data to Microsoft SQL Server databases that are hosted on Azure, the mapping fails.
Sqoop JIRA issue number: SQOOP-2349
BDM-25135
When you create a cluster configuration using an Active Directory user on an Azure HDInsight cluster with Enterprise Security Package, the creation of the cluster configuration fails with the following error: 
[ICMD_10033] Command [createConfiguration] failed with error [[CLUSTERCONF_10009] Create failed for the cluster configuration [testcco] while fetching the configuration from the cluster because of the following error: [Failed to create the cluster configuration due to invalid credentials. Verify cluster information such as host name, port number, user ID, and password.].].
Microsoft ticket reference number: 119042624000873
Workaround: Create a cluster configuration using a local user.
BDM-23420
A mapping with a Sorter transformation that contains datetime data in its default value changes the data when you run the mapping on a MapR cluster.
MapR ticket reference number: 00072094
BDM-23104
The Spark engine cannot write data to a bucketed Hive target if the Hadoop distribution is MapR.
MapR case number: 00074338
BDM-17470
In an Azure HDInsight environment, if you enable Hive merge in an Update Strategy transformation and if Hive is enabled to execute vectorized queries, inserting data into specific columns fails.
Workaround: In the hive-site.xml on the cluster, set the hive.vectorized.execution.enabled property to false.
Apache Hive ticket reference number: HIVE-14076
BDM-17020
When you run a mapping that uses a schema in an Avro file, the Spark engine adds a NULL data type to the primitive data types in the schema.
BDM-14422
The mapping fails with an error on Spark engine due to duplicate columns in the Hive table.
SPARK-23519
BDM-14410
The mapping fails because the Spark engine cannot read from an empty ORC Hive source.
SPARK-19809
BDM-10570
The Spark job fails with out of memory errors when a mapping that converts relational data to hierarchical data contains more than three Aggregator and Joiner transformations.
Workaround: To convert relational data to a hierarchical data of more than four levels, develop more than one mapping to stage the intermediate data. For example, develop a mapping that converts relational data to a hierarchical data up to three levels. Use the hierarchical data in another mapping to generate a hierarchical data of four levels.
SPARK-22207
BDM-10455
Inserts into a bucketed table can sometimes fail when you use Hive on Tez as the execution engine. The issue is more probable if the table is a Hive ACID table and a delete operation is performed before the inserts.
Apache ticket reference number: TEZ-3814
BDM-9585
Mappings fail on the Spark engine when you configure an SQL override to access a Hive view.
Apache Spark ticket reference number: SPARK-21154.
0 COMMENTS
We’d like to hear from you!