LAlance-format
Table
Data

Add new columns to table schema

Changed on

Add new columns to table id using SQL expressions or default values.

post/v1/table/{id}/add_columns

Request

  • Base URL
    http://localhost:2333
  • Auth
    • OAuth 2
      Client credentials
      Token URL: /oauth/token
    • or HTTP bearer
    • or API key in header x-api-key

Path parameters

idstring required

string identifier of an object in a namespace, following the Lance Namespace spec. When the value is equal to the delimiter, it represents the root namespace. For example, v1/namespace/$/list performs a ListNamespace on the root namespace.

Query parameters

delimiterstring

An optional delimiter of the string identifier, following the Lance Namespace spec. When not specified, the $ delimiter must be used.

Request body

contextunknown
idstring[]

Table identifier path (namespace + table name)

branchstring

Branch to target. When not specified, the main branch is used.

Example request

{
  "identity": {
    "api_key": "api_key",
    "auth_token": "auth_token"
  },
  "new_columns": [
    {
      "expression": "expression",
      "computed": "computed",
      "name": "name",
      "virtual_column": {
        "outputs": [
          {
            "metadata": {
              "key": "metadata"
            },
            "nullable": true,
            "column": "column",
            "data_type": "{}",
            "struct_field": "struct_field"
          },
          {
            "metadata": {
              "key": "metadata"
            },
            "nullable": true,
            "column": "column",
            "data_type": "{}",
            "struct_field": "struct_field"
          }
        ],
        "image": "image",
        "field_metadata": {
          "key": "field_metadata"
        },
        "manifest_checksum": "manifest_checksum",
        "udf": "udf",
        "udf_name": "udf_name",
        "manifest": "manifest",
        "input_columns": [
          "input_columns",
          "input_columns"
        ],
        "udf_backend": "udf_backend",
        "auto_backfill": true,
        "udf_version": "udf_version"
      }
    },
    {
      "expression": "expression",
      "computed": "computed",
      "name": "name",
      "virtual_column": {
        "outputs": [
          {
            "metadata": {
              "key": "metadata"
            },
            "nullable": true,
            "column": "column",
            "data_type": "{}",
            "struct_field": "struct_field"
          },
          {
            "metadata": {
              "key": "metadata"
            },
            "nullable": true,
            "column": "column",
            "data_type": "{}",
            "struct_field": "struct_field"
          }
        ],
        "image": "image",
        "field_metadata": {
          "key": "field_metadata"
        },
        "manifest_checksum": "manifest_checksum",
        "udf": "udf",
        "udf_name": "udf_name",
        "manifest": "manifest",
        "input_columns": [
          "input_columns",
          "input_columns"
        ],
        "udf_backend": "udf_backend",
        "auto_backfill": true,
        "udf_version": "udf_version"
      }
    }
  ],
  "context": {
    "key": "context"
  },
  "id": [
    "id",
    "id"
  ],
  "branch": "branch"
}

Response

Add columns operation result

contextunknown
versioninteger required

The commit version associated with the operation

Example response

{
  "context": {
    "key": "context"
  },
  "version": 0
}

Changes

  • 12f98a34d4a8Revision changes
    • info

      added the new optional request property //

  • 591cd95574b0Revision changes
    • info

      added the new optional request property

    • info

      added the optional property to the response with the status

    • info

      added the optional property to the response with the status

    • info

      added the optional property to the response with the status

    • info

      added the optional property to the response with the status

    • info

      added the optional property to the response with the status

    • info

      added the optional property to the response with the status

    • info

      added the optional property to the response with the status