# FileIndexBloomFilters: Big Data JSON File Index Bloom Filters The Bloom filters the index holds for a column of a data file, where there were too many values to hold exactly. ## Documentation The Bloom filters the index holds for a column of a data file, where there were too many values to hold exactly. - Catalog: `BigData` - Schema: `System` - Label: File Index Bloom Filters This is a read-only view. The Big Data JSON API may not support changing the data or the Invantive UniversalSQL driver for Big Data JSON does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Big Data JSON API. ## View Columns The columns of the view `FileIndexBloomFilters` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `bit_count` | `number` | Bit Count | ☑ | Number of bits in the filter. | | `bits_set` | `number` | Bits Set | ☐ | Number of bits of the filter which are set: a filter of which nearly every bit is set answers maybe to every value and rules out no file. | | `bits` | `clob` | Bits | ☐ | The bits of the filter, as the index writes them. | | `column_name` | `varchar2(240)` | Column Name | ☑ | Name of the column. | | `file_name` | `varchar2(1024)` | File Name | ☑ | Name of the data file within the directory of the table, as the index keys it. | | `hash_count` | `number` | Hash Count | ☑ | Number of hashes per value. | | `hash_name` | `varchar2(60)` | Hash Name | ☐ | Name of the hash the filter is built with. | | `seed` | `int64` | Seed | ☑ | Seed of the hash. | | `table_name` | `varchar2(240)` | Table Name | ☑ | Full name of the table whose index the row comes from. |