My partitions are returning inconsistent results (Mapped JSON file data)

Mark Ehlke 1

I have a set of tables based on a number of JSON files taken from a data lake v2 container. I'm building an external table using derived data from JSON mapping, then using derived columns based on those columns to generate an identifier. When I go to partition the results based on the identifier, I get inconsistent results - sometimes when I run it I get no rows, sometimes one, sometimes two. I expect two every time with the way the tables are currently configured. What might be causing this?

HimanshuSinha-msft 19,476 Reputation points Microsoft Employee

2020-10-12T21:01:56.903+00:00

Hello @Mark Ehlke ,

Thanks for the ask and also using the Microsoft Q&A.

Well do you think we can share some dummy data , so that we can work and try to repro the issue ?

Thanks Himanshu
HimanshuSinha-msft 19,476 Reputation points Microsoft Employee

2020-10-15T17:19:26.137+00:00

Hello @Mark Ehlke ,
We have not heard back from you on this and was just following up if you can eloborate more on the ask as requested before .
Incase if you have resolution , request you to share the same here , so that other community members can benefit from that .

Thanks
Himanshu

Share via

My partitions are returning inconsistent results (Mapped JSON file data)

Your answer