https://community.databricks.com/t5/data-engineering/how-many-bytes-are-used-to-store-null-values-in-data-lake/m-p/17922#M11839 <P>there is no single answer to this.</P><P>If you look at parquet, which is a very common format on data lakes:</P><P><A href="https://parquet.apache.org/docs/file-format/nulls/" target="test_blank">https://parquet.apache.org/docs/file-format/nulls/</A></P><P>and on <A href="https://stackoverflow.com/questions/59211451/what-is-the-weight-of-a-column-of-nulls-in-parquet" alt="https://stackoverflow.com/questions/59211451/what-is-the-weight-of-a-column-of-nulls-in-parquet" target="_blank">SO</A></P> Thu, 08 Dec 2022 14:27:37 GMT -werners- 2022-12-08T14:27:37Z https://community.databricks.com/t5/data-engineering/how-many-bytes-are-used-to-store-null-values-in-data-lake/m-p/17919#M11836 Thu, 08 Dec 2022 07:14:25 GMT https://community.databricks.com/t5/data-engineering/how-many-bytes-are-used-to-store-null-values-in-data-lake/m-p/17919#M11836 DB_developer 2022-12-08T07:14:25Z https://community.databricks.com/t5/data-engineering/how-many-bytes-are-used-to-store-null-values-in-data-lake/m-p/17920#M11837 <P>Generally they require 1 byte</P> Thu, 08 Dec 2022 08:46:15 GMT https://community.databricks.com/t5/data-engineering/how-many-bytes-are-used-to-store-null-values-in-data-lake/m-p/17920#M11837 Geeta1 2022-12-08T08:46:15Z https://community.databricks.com/t5/data-engineering/how-many-bytes-are-used-to-store-null-values-in-data-lake/m-p/17921#M11838 <P>Can you please provide any supporting documentation ? </P> Thu, 08 Dec 2022 09:20:46 GMT https://community.databricks.com/t5/data-engineering/how-many-bytes-are-used-to-store-null-values-in-data-lake/m-p/17921#M11838 DB_developer 2022-12-08T09:20:46Z https://community.databricks.com/t5/data-engineering/how-many-bytes-are-used-to-store-null-values-in-data-lake/m-p/17922#M11839 <P>there is no single answer to this.</P><P>If you look at parquet, which is a very common format on data lakes:</P><P><A href="https://parquet.apache.org/docs/file-format/nulls/" target="test_blank">https://parquet.apache.org/docs/file-format/nulls/</A></P><P>and on <A href="https://stackoverflow.com/questions/59211451/what-is-the-weight-of-a-column-of-nulls-in-parquet" alt="https://stackoverflow.com/questions/59211451/what-is-the-weight-of-a-column-of-nulls-in-parquet" target="_blank">SO</A></P> Thu, 08 Dec 2022 14:27:37 GMT https://community.databricks.com/t5/data-engineering/how-many-bytes-are-used-to-store-null-values-in-data-lake/m-p/17922#M11839 -werners- 2022-12-08T14:27:37Z