Table of Contents

Search

  1. Preface
  2. Part 1: Version 10.5.7
  3. Part 2: Version 10.5.6 - Version 10.5.6.x
  4. Part 3: Version 10.5.5 - 10.5.5.x
  5. Part 4: Version 10.5.4 - 10.5.4.x
  6. Part 5: Version 10.5.3 - 10.5.3.x
  7. Part 6: Version 10.5.2 - 10.5.2.1.x
  8. Part 7: Version 10.5.1 - 10.5.1.1
  9. Part 8: Versions 10.5 - 10.5.0.1
  10. Part 9: Versions 10.4.1 - 10.4.1.3
  11. Part 10: Versions 10.4 - 10.4.0.2
  12. Part 11: Versions 10.2.2 - 10.2.2 HotFix 1
  13. Part 12: Version 10.2.1
  14. Part 13: Version 10.2 - 10.2 HotFix 2

Null Values in Target

Null Values in Target

Effective in version 10.4.0, the following changes are applicable when you write data to a complex file:
  • If the mapping source contains null values and you use the
    Create Target
    option to create a Parquet target file, the default schema contains optional fields and you can insert null values to the target.
    Previously, all the fields were created as REQUIRED in the default schema and you had to manually update the data type in the target schema from "required" to "Optional" to write the columns with null values to the target.
  • If the mapping source contains null values and you use the
    Create Target
    option to create an Avro target file, null values are defined in the default schema and you can insert null values into the target file.
    Previously, the null values were not defined in the default schema and you had to manually update the default target schema to add "null" data type to the schema.
You can manually edit the schema if you do not want to allow null values to the target. You cannot edit the schema to prevent the null values in the target with mapping flow enabled.
These changes are applicable to the following adapters:
  • PowerExchange for HDFS
  • PowerExchange for Amazon S3
  • PowerExchange for Google Cloud Storage
  • PowerExchange for Microsoft Azure Blob Storage
  • PowerExchange for Microsoft Azure Data Lake Storage Gen1

0 COMMENTS

We’d like to hear from you!