Conversion from ArrayType to ArrayType not defined

Question

Conversion from ArrayType to ArrayType not defined

Urmo Arr 11

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.

This is the data preview right before the SINK

Sink Mapping is

This Gives the Error

if i change the sink mapping to anything else than "Machines"

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

1 answer

Your answer

Answer 1

Urmo Arr 11

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

MartinJaffer-MSFT 26,156 Reputation points

2022-06-02T19:58:41.073+00:00

Hello @Urmo Arr ,
It was great to know that you were able to get to a resolution . We expect you to keep using this forum and also motivate others to do that same . You can always help other community members by answering to their queries ..

Thanks
Martin

Share via

Conversion from ArrayType to ArrayType not defined

1 answer

Your answer