Elasticsearch - Revision history

Planetoid: Planetoid moved page Elastic search to Elasticsearch

2024-10-15T08:46:44Z

Planetoid moved page Elastic search to Elasticsearch

← Older revision	Revision as of 16:46, 15 October 2024
(No difference)

Planetoid: /* Select particular data from index or table (exact match) */

2024-10-15T08:44:58Z

Select particular data from index or table (exact match)

@@ Line 123: / Line 123: @@
 == Select particular data from index or table (exact match) ==
 Elasticsearch<ref>[https://www.elastic.co/guide/en/elasticsearch/reference/current/indices-get-index.html Get index API | Elasticsearch Guide [8.15] | Elastic]</ref>
 <pre>
 GET /MY_INDEX/_search/?q=_id:1
@@ Line 134: / Line 133: @@
 FROM MY_TABLE
 WHERE id = 1
 </pre>

Planetoid: /* Select particular data from index or table (exact search) */

2024-10-15T08:32:30Z

Select particular data from index or table (exact search)

← Older revision		Revision as of 16:32, 15 October 2024
Line 121:		Line 121:
	</pre>		</pre>

	== Select particular data from index or table (exact ~~search~~) ==		== Select particular data from index or table (exact match) ==
	Elasticsearch<ref>[https://www.elastic.co/guide/en/elasticsearch/reference/current/indices-get-index.html Get index API \| Elasticsearch Guide [8.15] \| Elastic]</ref>		Elasticsearch<ref>[https://www.elastic.co/guide/en/elasticsearch/reference/current/indices-get-index.html Get index API \| Elasticsearch Guide [8.15] \| Elastic]</ref>

Planetoid: /* Select particular data from index or table */

2024-10-15T08:31:33Z

Select particular data from index or table

← Older revision		Revision as of 16:31, 15 October 2024
Line 121:		Line 121:
	</pre>		</pre>

	== Select particular data from index or table ==		== Select particular data from index or table (exact search) ==
	Elasticsearch<ref>[https://www.elastic.co/guide/en/elasticsearch/reference/current/indices-get-index.html Get index API \| Elasticsearch Guide [8.15] \| Elastic]</ref>		Elasticsearch<ref>[https://www.elastic.co/guide/en/elasticsearch/reference/current/indices-get-index.html Get index API \| Elasticsearch Guide [8.15] \| Elastic]</ref>

Planetoid: /* Select all data from index or table */

2024-10-15T08:31:07Z

Select all data from index or table

@@ Line 119: / Line 119: @@
 SELECT *
 FROM MY_TABLE
 </pre>

Planetoid at 08:04, 15 October 2024

2024-10-15T08:04:06Z

← Older revision		Revision as of 16:04, 15 October 2024
Line 1:		Line 1:

			== Concept mapping ==

			<table class="wikisort" border="1">
			<tr>
			<th>MySQL (RDBMS)</th>
			<th>Elasticsearch</th>
			<th>Excel</th>
			<th>Example Value (Bookstore)</th>
			</tr>
			<tr>
			<td>Table</td>
			<td>Index</td>
			<td>Worksheet</td>
			<td>books</td>
			</tr>
			<tr>
			<td>Row</td>
			<td>Document</td>
			<td>Row</td>
			<td class="code">{ "id": 1, "title": "The Great Gatsby", "author": "F. Scott Fitzgerald", "price": 9.99 }</td>
			</tr>
			<tr>
			<td>Field</td>
			<td>Field</td>
			<td>Column</td>
			<td>title</td>
			</tr>
			<tr>
			<td>Schema</td>
			<td>Mapping</td>
			<td>Column Headers</td>
			<td class="code"><pre>{
			"properties": {
			"title": { "type": "text" },
			"author": { "type": "keyword" },
			"price": { "type": "float" }
			}
			}</pre></td>
			</tr>
			<tr>
			<td>SQL</td>
			<td>DSL</td>
			<td>Formulas/Filters</td>
			<td class="code">SQL: SELECT * FROM books WHERE author = 'F. Scott Fitzgerald'
			DSL: { "query": { "term": { "author": "F. Scott Fitzgerald" } } }
			Excel: Filter column "author" for "F. Scott Fitzgerald"</td>
			</tr>
			</table>

	== Count the number of documents ==		== Count the number of documents ==

Planetoid: /* Select the data from index or table */

2024-10-15T07:52:23Z

Select the data from index or table

← Older revision		Revision as of 15:52, 15 October 2024
Line 49:		Line 49:


	== Select ~~the~~ data from index or table ==		== Select all data from index or table ==
	Elasticsearch<ref>[https://www.elastic.co/guide/en/elasticsearch/reference/current/indices-get-index.html Get index API \| Elasticsearch Guide [8.15] \| Elastic]</ref>		Elasticsearch<ref>[https://www.elastic.co/guide/en/elasticsearch/reference/current/indices-get-index.html Get index API \| Elasticsearch Guide [8.15] \| Elastic]</ref>

Line 63:		Line 63:
	FROM MY_TABLE		FROM MY_TABLE
	LIMIT 1000		LIMIT 1000
			</pre>

			or

			<pre>
			SELECT *
			FROM MY_TABLE
	</pre>		</pre>

Planetoid: /* Create the index or table */

2024-10-15T07:49:30Z

Create the index or table

← Older revision		Revision as of 15:49, 15 October 2024
Line 26:		Line 26:

	== Create the index or table ==		== Create the index or table ==
	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><ref>[https://www.elastic.co/guide/en/elasticsearch/reference/current/mapping-types.html Field data types \| Elasticsearch Guide [8.15] \| Elastic]</ref>		Elasticsearch<ref>[https://www.elastic.co/guide/en/elasticsearch/reference/current/indices-create-index.html#mappings Create index API \| Elasticsearch Guide [8.15] \| Elastic]</ref><ref>[https://opster.com/guides/elasticsearch/search-apis/elasticsearch-strings-keyword-vs-text-vs-wildcard/ Elasticsearch Keyword VS. Text - Strings Types Explained]</ref><ref>[https://www.elastic.co/guide/en/elasticsearch/reference/current/mapping-types.html Field data types \| Elasticsearch Guide [8.15] \| Elastic]</ref>
	<pre>		<pre>
	PUT /MY_INXEX		PUT /MY_INXEX
Line 39:		Line 39:
	</pre>		</pre>

	MySQL [https://dev.mysql.com/doc/refman/8.4/en/create-table.html MySQL :: MySQL 8.4 Reference Manual :: 15.1.20 CREATE TABLE Statement]		MySQL<ref>[https://dev.mysql.com/doc/refman/8.4/en/create-table.html MySQL :: MySQL 8.4 Reference Manual :: 15.1.20 CREATE TABLE Statement]</ref>

	<pre>		<pre>
Line 46:		Line 46:
	field1 TEXT		field1 TEXT
	) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;		) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
			</pre>


			== Select the data from index or table ==
			Elasticsearch<ref>[https://www.elastic.co/guide/en/elasticsearch/reference/current/indices-get-index.html Get index API \| Elasticsearch Guide [8.15] \| Elastic]</ref>

			<pre>
			GET /MY_INDEX/_search/?size=1000&pretty=true
			</pre>


			MySQL<ref>[https://dev.mysql.com/doc/refman/8.4/en/selecting-all.html MySQL :: MySQL 8.4 Reference Manual :: 5.3.4.1 Selecting All Data]</ref>

			<pre>
			SELECT *
			FROM MY_TABLE
			LIMIT 1000
	</pre>		</pre>

Planetoid: /* Create the index */

2024-10-15T07:45:04Z

Create the index

← Older revision		Revision as of 15:45, 15 October 2024
Line 25:		Line 25:
	</pre>		</pre>

	== Create the index ==		== Create the index or table ==
	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><ref>[https://www.elastic.co/guide/en/elasticsearch/reference/current/mapping-types.html Field data types \| Elasticsearch Guide [8.15] \| Elastic]</ref>		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><ref>[https://www.elastic.co/guide/en/elasticsearch/reference/current/mapping-types.html Field data types \| Elasticsearch Guide [8.15] \| Elastic]</ref>
	<pre>		<pre>

Planetoid: /* Truncate the index */

2024-10-15T07:44:48Z

Truncate the index

← Older revision		Revision as of 15:44, 15 October 2024
Line 13:		Line 13:
	</pre>		</pre>

	== Truncate the index ==		== Truncate the index or table ==
	Elasticsearch: [https://www.elastic.co/guide/en/elasticsearch/reference/current/docs-delete.html Delete API \| Elasticsearch Guide [8.15] \| Elastic]<ref>[https://stackoverflow.com/questions/31929695/truncate-index-in-elasticsearch python - Truncate index in elasticsearch - Stack Overflow]</ref>		Elasticsearch: [https://www.elastic.co/guide/en/elasticsearch/reference/current/docs-delete.html Delete API \| Elasticsearch Guide [8.15] \| Elastic]<ref>[https://stackoverflow.com/questions/31929695/truncate-index-in-elasticsearch python - Truncate index in elasticsearch - Stack Overflow]</ref>

Line 24:		Line 24:
	TRUNCATE MY_TABLE		TRUNCATE MY_TABLE
	</pre>		</pre>


	== Create the index ==		== Create the index ==