Indexing a MySQL table containing LONGTEXT field into Elastic Search
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.
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.
-
2:40
How do you combine Java and jxbrowser processes into a single custom named process?
-
2:30
-
2:20
Why does IntelliJ give me osgi-related warnings for a project that doesn't use a manifest file?
-
2:10
-
2:00
How do I add external FXML from another package to my tab with netbeans
-
1:50
How to create a pipeline to publish a jar file to sharepoint?
-
1:40
-
1:20
-
1:10
- search for elements in a list 13299 visits
- Adding methods to es6 child class 12124 visits
- In Chrome 55, prevent showing Download button for HTML 5 video 9648 visits
- typescript: tsc is not recognized as an internal or external command, operable program or batch file 8067 visits
- RxJS5 - error - TypeError: You provided an invalid object where a stream was expected 7078 visits
- Conflict: Multiple assets emit to the same filename 5886 visits
- Ionic 2 - how to make ion-button with icon and text on two lines? 5811 visits
