+------------------+---------------+------+-----+---------+-------+
| Field            | Type          | Null | Key | Default | Extra |
+------------------+---------------+------+-----+---------+-------+
| ISBN13           | varchar(13)   | NO   | PRI | NULL    |       |
| BookName         | varchar(255)  | YES  |     | NULL    |       |
| Author           | varchar(255)  | YES  |     | NULL    |       |
| Genre            | varchar(255)  | YES  |     | NULL    |       |
| ShortDescription | varchar(1024) | YES  |     | NULL    |       |
| LongDecription   | longtext      | YES  |     | NULL    |       |
| Publisher        | varchar(45)   | YES  |     | NULL    |       |
| Flag             | tinyint(1)    | YES  |     | NULL    |       |
| PubDate          | varchar(45)   | YES  |     | NULL    |       |
| inGoogle         | bit(1)        | NO   |     | NULL    |       |
| Skipped          | bit(1)        | NO   |     | b'0'    |       |
| SmallThumb       | text          | YES  |     | NULL    |       |
| LargeThumb       | text          | YES  |     | NULL    |       |
| ISBN10           | char(10)      | YES  |     | NULL    |       |
+------------------+---------------+------+-----+---------+-------+
14 rows in set (0.00 sec)


input {
  jdbc {
    jdbc_driver_library => "/opt/mysql-connector-java-5.1.38/mysql-connector-java-5.1.38-bin$
    jdbc_driver_class => "com.mysql.jdbc.Driver"
    jdbc_connection_string => "jdbc:mysql://localhost:3306/ISBN"
    jdbc_user => "root"
    jdbc_password => "m0on!ightz0ne!"
    statement => "select * from Bookinfo"
  }
}
output {
    elasticsearch {
        index => "bookinfo"
        document_type => "ISBN-Bookinfo"
        document_id => "%{pid}"
        hosts => "localhost:9200"
    }
}