retrieveDenseVectorData
required_capability: dense_vector_field_type_released
required_capability: dense_vector_agg_metric_double_if_version
required_capability: l2_norm_vector_similarity_function

FROM dense_vector
| KEEP id, float_vector
| SORT id
;

id:l | float_vector:dense_vector
0    | [1.0, 2.0, 3.0]
1    | [4.0, 5.0, 6.0]
2    | [9.0, 8.0, 7.0]
3    | [0.054, 0.032, 0.012]
4    | null
;

denseVectorWithEval
required_capability: dense_vector_agg_metric_double_if_version
required_capability: l2_norm_vector_similarity_function

FROM dense_vector
| EVAL v = float_vector
| KEEP id, v
| SORT id
;

id:l | v:dense_vector
0    | [1.0, 2.0, 3.0]
1    | [4.0, 5.0, 6.0]
2    | [9.0, 8.0, 7.0]
3    | [0.054, 0.032, 0.012]
4    | null
;

denseVectorWithRenameAndDrop
required_capability: dense_vector_agg_metric_double_if_version
required_capability: l2_norm_vector_similarity_function

FROM dense_vector 
| EVAL v = float_vector 
| RENAME v AS new_vector 
| DROP float_vector, byte_vector, bit_vector
| SORT id
;

id:l | new_vector:dense_vector
0    | [1.0, 2.0, 3.0]
1    | [4.0, 5.0, 6.0]
2    | [9.0, 8.0, 7.0]
3    | [0.054, 0.032, 0.012]
4       | null
;

convertIntsToDenseVector
required_capability: dense_vector_field_type_released
required_capability: to_dense_vector_function

// tag::to_dense_vector-ints[]
row ints = [1, 2, 3]
| eval vector = to_dense_vector(ints)
| keep vector
// end::to_dense_vector-ints[]
;

// tag::to_dense_vector-ints-result[]
vector:dense_vector
[1.0, 2.0, 3.0]
// end::to_dense_vector-ints-result[]
;

convertLongsToDenseVector
required_capability: dense_vector_field_type_released
required_capability: to_dense_vector_function

row longs = [5013792, 2147483647, 501379200000]
| eval vector = to_dense_vector(longs)
| keep vector
;

vector:dense_vector
[5013792.0, 2147483647.0, 501379200000.0]
;

convertDoublesToDenseVector
required_capability: dense_vector_field_type_released
required_capability: to_dense_vector_function

row doubles = [123.4, 567.8, 901.2]
| eval vector = to_dense_vector(doubles)
| keep vector
;

vector:dense_vector
[123.4, 567.8, 901.2]
;

convertHexStringToDenseVector
required_capability: dense_vector_field_type_released
required_capability: to_dense_vector_function

row hex_str = "0102030405060708090a0b0c0d0e0f"
| eval vector = to_dense_vector(hex_str)
| keep vector
;

vector:dense_vector
 [1.0, 2.0, 3.0, 4.0, 5.0, 6.0, 7.0, 8.0, 9.0, 10.0, 11.0, 12.0, 13.0, 14.0, 15.0]
;

denseVectorWithEnrich
required_capability: enrich_load
required_capability: enrich_dense_vector_bugfix

from colors 
| enrich colors_policy
| sort color_name
| limit 10
| keep color_name, cmyk_vector
;

color_name:text | cmyk_vector:dense_vector
aqua marine     | [50.0, 0.0, 17.0, 0.0]
azure           | [6.0, 0.0, 0.0, 0.0]
beige           | [0.0, 0.0, 10.0, 4.0]
bisque          | [0.0, 11.0, 23.0, 0.0]
black           | [0.0, 0.0, 0.0, 100.0]
blue            | [100.0, 100.0, 0.0, 0.0]
brown           | [0.0, 75.0, 75.0, 35.0]
burly wood      | [0.0, 17.0, 39.0, 13.0]
chartreuse      | [50.0, 0.0, 100.0, 0.0]
chocolate       | [0.0, 50.0, 86.0, 18.0]
;

denseVectorRowWithEnrich
required_capability: enrich_load
required_capability: enrich_dense_vector_bugfix

row id=0
| enrich colors_policy
| keep color_name, cmyk_vector
;

color_name:text | cmyk_vector:dense_vector
maroon          | [0.0, 100.0, 100.0, 50.0]
;

denseVectorAggregationFunctions
required_capability: dense_vector_agg_functions

from dense_vector
| stats count_all = count(*), count_vectors = count(float_vector), present = present(float_vector), absent = absent(float_vector)
;

count_all:long | count_vectors:long | present:boolean | absent:boolean
5              | 4                  | true            | false
;

denseVectorCount
required_capability: dense_vector_agg_functions

from dense_vector
| stats count_vectors = count(float_vector)
;

count_vectors:long
4               
;

denseVectorLiteralCount
required_capability: dense_vector_agg_functions

row vector = to_dense_vector([0, 1, 2])
| stats count_vectors = count(vector)
;

count_vectors:long
1               
;