Because Primary & Foreign Key information is not enforced.
"Primary and foreign keys are informational only and are not enforced" from:
https://docs.databricks.com/en/tables/constraints.html#declare-primary-key-and-foreign-key-relationships
https://www.databricks.com/discover/pages/optimize-data-workloads-guide#delta-data
Delta data skipping automatically collects the stats (min, max, etc.) for the first 32 columns for each underlying Parquet file when you write data into a Delta table. Databricks takes advantage of this information (minimum and maximum values) at query time to skip unnecessary files in order to speed up the queries.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
SRV_33
3 months agoPrashantTiwari
1 year, 2 months agoguillesd
1 year, 2 months agospaceexplorer
1 year, 2 months agoCrocjun
1 year, 3 months agodecisiontree
3 months, 2 weeks agocryptoflam
1 year, 3 months agoPatito
1 year, 3 months agoAndreFR
8 months agoervinshang
1 year, 3 months agof728f7f
1 year, 3 months agochokthewa
1 year, 5 months ago