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

Mark Ehlke 1 Reputation point
2020-10-09T21:00:12.793+00:00

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?

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,409 questions
Azure Container Instances
Azure Container Instances
An Azure service that provides customers with a serverless container experience.
669 questions
Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
502 questions