0

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.

Ian Kemp
  • 28,293
  • 19
  • 112
  • 138
markkazanski
  • 439
  • 7
  • 20

1 Answers1

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.

nmur
  • 368
  • 2
  • 6
  • Will having quotes in the text cause problems in JSON, too? – markkazanski Jan 11 '19 at 17:01
  • The documentation mentions that the special characters at escaped with backslashes. I would suggest giving it a try and inspecting the json. – nmur Jan 13 '19 at 01:16