DATE type data shows as INT value in ARRAY of Struct

We are forming tree structure using collect_set and struct. We are observing when query to the table DATE type data shows as int value whearas querying to the flattened structure date format appears correctly. I’m bit confused why is the behaviour like this? Is it the expected behaviour or this can be treated as defect ? Please let me know if you need further clarification on this.

This topic was automatically closed after 30 days. New replies are no longer allowed.