> ## Documentation Index
> Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt
> Use this file to discover all available pages before exploring further.

<AgentInstructions>

## Submitting Feedback

If you encounter incorrect, outdated, or confusing documentation on this page, submit feedback:

POST https://docs.firebolt.io/feedback

```json
{
  "path": "/reference-sql/functions-reference/vector/vector-squared-euclidean-distance",
  "feedback": "Description of the issue"
}
```

Only submit feedback when you have something specific and actionable to report.

</AgentInstructions>

> Reference material for VECTOR_SQUARED_EUCLIDEAN_DISTANCE function

# VECTOR_SQUARED_EUCLIDEAN_DISTANCE

## VECTOR\_SQUARED\_EUCLIDEAN\_DISTANCE

Returns the squared [Euclidean distance](/reference-sql/functions-reference/vector/vector-euclidean-distance), or squared [L2 distance](/reference-sql/functions-reference/vector/vector-euclidean-distance) between two vectors. The squared Euclidean distance measures how far apart two vectors based on the size of their differences, without considering direction. By squaring the difference, it emphasizes larger differences, which can help in finding outliers or large deviations.

## Syntax

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
VECTOR_SQUARED_EUCLIDEAN_DISTANCE(<array>, <array>)
```

## Parameters

| Parameter | Description                                        | Supported input types                                                 |
| :-------- | :------------------------------------------------- | :-------------------------------------------------------------------- |
| `<array>` | The first array used in the distance calculation.  | Any array of [numeric data types](/reference-sql/data-types#numeric). |
| `<array>` | The second array used in the distance calculation. | Any array of [numeric data types](/reference-sql/data-types#numeric). |

## Notes

Both input `array` arguments must have the same number of elements.

## Return Type

`DOUBLE`

## Examples

**Example**

The following code returns the squared Euclidean distance between two vectors:

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SELECT VECTOR_SQUARED_EUCLIDEAN_DISTANCE([1, 2], [3, 4]) AS distance;
```

**Returns**

| distance (DOUBLE PRECISION) |
| :-------------------------- |
| 8                           |

**Example**

The following code returns the squared Euclidean distance between two identical vectors:

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SELECT VECTOR_SQUARED_EUCLIDEAN_DISTANCE([1, 1], [1, 1]) AS distance;
```

**Returns**

| distance (DOUBLE PRECISION) |
| :-------------------------- |
| 0                           |

**Example**

The following code returns the squared Euclidean distance between two vectors that are very far apart:

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SELECT VECTOR_SQUARED_EUCLIDEAN_DISTANCE([1, 1], [10, 10]) AS distance;
```

**Returns**

| distance (DOUBLE PRECISION) |
| :-------------------------- |
| 162                         |