Elasticsearch: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| Line 27: | Line 27: | ||
== Create the index == | == Create the index == | ||
Elasticsearch: [https://www.elastic.co/guide/en/elasticsearch/reference/current/indices-create-index.html#mappings Create index API | Elasticsearch Guide [8.15] | Elastic] | Elasticsearch: [https://www.elastic.co/guide/en/elasticsearch/reference/current/indices-create-index.html#mappings Create index API | Elasticsearch Guide [8.15] | Elastic]<ref>[https://opster.com/guides/elasticsearch/search-apis/elasticsearch-strings-keyword-vs-text-vs-wildcard/ Elasticsearch Keyword VS. Text - Strings Types Explained]</ref> | ||
<pre> | <pre> | ||
PUT /MY_INXEX | PUT /MY_INXEX | ||
| Line 33: | Line 33: | ||
"mappings": { | "mappings": { | ||
"properties": { | "properties": { | ||
"id": { "type": "keyword" }, | |||
"field1": { "type": "text" } | "field1": { "type": "text" } | ||
} | } | ||
| Line 47: | Line 48: | ||
) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci; | ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci; | ||
</pre> | </pre> | ||
== References == | == References == | ||
Revision as of 15:32, 15 October 2024
Count the number of documents
Elasticsearch: Count API | Elasticsearch Guide [8.15 Elastic]
GET /MY_INXEX/_count
MySQL MySQL :: MySQL 8.4 Reference Manual :: 5.3.4.8 Counting Rows
SELECT COUNT(*) FROM MY_TABLE
Truncate the index
Elasticsearch: Delete API | Elasticsearch Guide [8.15 | Elastic][1]
DELETE /MY_INXEX/
MySQL MySQL :: MySQL 8.4 Reference Manual :: 15.1.37 TRUNCATE TABLE Statement
TRUNCATE MY_TABLE
Create the index
Elasticsearch: Create index API | Elasticsearch Guide [8.15 | Elastic][2]
PUT /MY_INXEX
{
"mappings": {
"properties": {
"id": { "type": "keyword" },
"field1": { "type": "text" }
}
}
}
MySQL MySQL :: MySQL 8.4 Reference Manual :: 15.1.20 CREATE TABLE Statement
CREATE TABLE MY_TABLE ( id INT AUTO_INCREMENT PRIMARY KEY, field1 TEXT ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;