Indexing a MySQL table containing LONGTEXT field into Elastic Search
27
January 12, 2019, at 03:40 AM
The table contains a LONGTEXT field that has special characters including quotes and commas.
How can I get this table into Elastic Search?
Exporting the table as CSV and then using Logstash could work. But the quotes and spaces cause extra columns to be parsed.
Answer 1
CSV isn't an ideal format for more complex data like that. You could try exporting to another structure like json (example of how to export a table to JSON).
From there, you can insert the data using the bulk API.
POPULAR ONLINE
- search for elements in a list 10638 visits
- In Chrome 55, prevent showing Download button for HTML 5 video 8485 visits
- typescript: tsc is not recognized as an internal or external command, operable program or batch file 6628 visits
- Adding methods to es6 child class 6235 visits
- RxJS5 - error - TypeError: You provided an invalid object where a stream was expected 5895 visits
- Ionic 2 - how to make ion-button with icon and text on two lines? 4815 visits
- Conflict: Multiple assets emit to the same filename 4670 visits
