Conversion from ArrayType to ArrayType not defined

Urmo Arr 11 Reputation points
2022-06-01T09:44:52.027+00:00

I keep getting this error

Conversion from ArrayType(StructType(StructField(MachineKey,StringType,true)),true) to ArrayType(StructType(StructField(MachineKey,StringType,true), StructField(FrameNumber,StringType,true), StructField(IsActive,BooleanType,true), StructField(Created,StringType,true), StructField(Modified,StringType,true)),false) not defined

For simplicity sake i have only one value in array.
207440-image.png

This is the data preview right before the SINK

Sink Mapping is
207511-image.png

This Gives the Error

if i change the sink mapping to anything else than "Machines"
207521-image.png

it works. HOW , why ? but i need the data key value to be Machines:[] and that is the only name i cannot use
and that is the only name that gives the errors. It looks like i have to create a new sink to simply rename.
I tried that, doenst work.
please help

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Urmo Arr 11 Reputation points
    2022-06-02T13:03:41.387+00:00

    So i figured it out.
    Looks like the there was a schema imported on the dataset Sink, and that forces that Name (Machines) to have the imported array as a the type on saving.
    just clear the datasets schemas, and import them when sure that your dataflow has inserted correctly

    2 people found this answer helpful.

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.