# FileIndexColumnValues: Big Data JSON File Index Column Values The exact values the index holds for a column of a data file, where there were few enough to hold. ## Documentation The exact values the index holds for a column of a data file, where there were few enough to hold. - Catalog: `BigData` - Schema: `System` - Label: File Index Column Values 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 `FileIndexColumnValues` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `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. | | `table_name` | `varchar2(240)` | Table Name | ☑ | Full name of the table whose index the row comes from. | | `value_ordinal` | `number` | Value Ordinal | ☑ | Position of the value in the sorted list of values, counted from one. | | `value` | `clob` | Value | ☐ | The value, written as the index writes it. A value is held whole however long it is, so a message or a stack trace held as a value appears here in full. |