Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- +------------------+---------------+------+-----+---------+-------+
- | 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 => "shhhhh"
- statement => "select * from Bookinfo"
- }
- }
- output {
- elasticsearch {
- index => "bookinfo"
- document_type => "ISBN-Bookinfo"
- document_id => "%{pid}"
- hosts => "localhost:9200"
- }
- }
Add Comment
Please, Sign In to add comment