You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@druid.apache.org by vi...@apache.org on 2024/09/18 22:04:21 UTC
(druid) branch vtlim-patch-1 created (now a43d9d1b74e)
This is an automated email from the ASF dual-hosted git repository.
victoria pushed a change to branch vtlim-patch-1
in repository https://gitbox.apache.org/repos/asf/druid.git
at a43d9d1b74e separate H2
This branch includes the following new commits:
new a43d9d1b74e separate H2
The 1 revisions listed above as "new" are entirely new to this
repository and will be described in separate emails. The revisions
listed as "add" were already present in the repository and have only
been added to this reference.
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org
(druid) 01/01: separate H2
Posted by vi...@apache.org.
This is an automated email from the ASF dual-hosted git repository.
victoria pushed a commit to branch vtlim-patch-1
in repository https://gitbox.apache.org/repos/asf/druid.git
commit a43d9d1b74ed4c565771ce6545948a14c75d241c
Author: Victoria Lim <vt...@users.noreply.github.com>
AuthorDate: Wed Sep 18 15:04:10 2024 -0700
separate H2
---
docs/release-info/migr-mvd-array.md | 15 +++++++++++++--
1 file changed, 13 insertions(+), 2 deletions(-)
diff --git a/docs/release-info/migr-mvd-array.md b/docs/release-info/migr-mvd-array.md
index e089a6a733e..37440b2674c 100644
--- a/docs/release-info/migr-mvd-array.md
+++ b/docs/release-info/migr-mvd-array.md
@@ -231,7 +231,11 @@ GROUP BY 1, 2
```
-## How to ingest data as arrays
+## How to ingest arrays
+
+:::tip
+As a best practice, always use the ARRAY data type in your input schema.
+:::
You can ingest arrays in Druid as follows:
@@ -242,5 +246,12 @@ For an example, see [Ingesting arrays: Native batch and streaming ingestion](../
* For SQL-based batch ingestion, include the [query context parameter](../multi-stage-query/reference.md#context-parameters) `"arrayIngestMode": "array"` and reference the relevant array type (`VARCHAR ARRAY`, `BIGINT ARRAY`, or `DOUBLE ARRAY`) in the [EXTEND clause](../multi-stage-query/reference.md#extern-function) that lists the column names and data types.
For examples, see [Ingesting arrays: SQL-based ingestion](../querying/arrays.md#sql-based-ingestion).
- As a best practice, always use the ARRAY data type in your input schema. If you want to ingest MVDs, explicitly wrap the string array in [ARRAY_TO_MV](../querying/sql-functions.md#array_to_mv). For an example, see [Multi-value dimensions: SQL-based ingestion](../querying/multi-value-dimensions.md#sql-based-ingestion).
+## How to ingest MVDs
+
+You can't mix arrays and MVDs in the same column.
+If you have an MVD column and want to continue ingesting MVDs, explicitly wrap the string array in [ARRAY_TO_MV](../querying/sql-functions.md#array_to_mv).
+For an example, see [Multi-value dimensions: SQL-based ingestion](../querying/multi-value-dimensions.md#sql-based-ingestion).
+If you have MVD columns and want to migrate to array columns, [reindex](../data-management/update.md#reindex) your data to update its schema.
+Reindexing overwrites existing data where the source of new data is the existing data itself.
+Follow the same guidance on [How to ingest arrays](#how-to-ingest-arrays).
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org