Zero-Cost NDV Estimation from Columnar File Metadata
arXiv:2603.24606v1 Announce Type: new Abstract: We present a method for estimating the number of distinct values (NDV) of a column in columnar file formats, using only existing file metadata–no extra storage, no data access. Two complementary signals are exploited: (1)~inverting the dictionary-encoded storage size equation yields accurate NDV estimates when distinct values are well-spread across row groups; (2)~counting distinct min/max values across row groups and inverting a coupon collector model provides robust estimates for sorted or partitioned data. […]