Indexing a MySQL table containing LONGTEXT field into Elastic Search

53
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.

LAST QUESTIONS
All questions
POPULAR ONLINE
jQuery Categories

Searching through a file based on user input?

select to multiply tables for print mysqli_num_rows

Running JDK between Tomcat Server and project [duplicate]

N:M or 1:N relationship?

It works local with xampp. The login works live, but the register does not

READ ALSO
how to set collation_server and character_set_ server from utf8 to utf8mb4 and utf8mb4_unicode_ci?
MySQL

how to set collation_server and character_set_ server from utf8 to utf8mb4 and utf8mb4_unicode_ci?

I have tried following this website https://mathiasbynensbe/notes/mysql-utf8mb4#utf8-to-utf8mb4, but i can't able to find collation_server which is in my

 57
How to Import Products using API to database / Realtime [on hold]
MySQL

How to Import Products using API to database / Realtime [on hold]

 40
How to concat_ws primarykey(id) and date in a new column on same table?(MySQL)
MySQL

How to concat_ws primarykey(id) and date in a new column on same table?(MySQL)

I need add a new column named date_id by using concat_ws('-', curdate,id) on a same table, the id is a primarykey and auto_incrementHow to do this?

 37
mysqldump fails with “Skipping dump data for table 'table1', it has no fields”
MySQL

mysqldump fails with “Skipping dump data for table 'table1', it has no fields”

I'm running mysqldump from an older mysql databaseThe mysqldump is part of a mariadb distribution if it matters

 38