logstash

input {
elasticsearch {
    hosts => "127.0.0.1"
    index => "index"
    size  => 10000
    scroll=> "20m"
  }       
}

filter{
  mutate{
    remove_field => ["@version","@timestamp","risktype"]
  }
}
 
output {
  file{
    path=>"E:/json/index.json"
  }

}

input {
  jdbc {
    jdbc_driver_library => "jar/sqlite-jdbc-3.27.2.1.jar"
    jdbc_driver_class => "org.sqlite.JDBC"
    jdbc_connection_string => "jdbc:sqlite:C:/Users/User/Desktop/ttttt.db"
    jdbc_user => "root"
    jdbc_password => "root"
    statement => "SELECT * FROM bbq"
    ##jdbc_paging_enabled => "true"
    ##jdbc_page_size => "100000"
  }
}
 
filter {
   json {
        source => "message"
        remove_field => ["message"]
    }
}
 
output {
  elasticsearch {
    hosts => "127.0.0.1"
    index => "bbq"
    document_type => "bbq"
  }       
}

[Mysql]
com.mysql.cj.jdbc.Driver
jdbc:mysql://localhost:3306/test?serverTimezone=UTC
jdbc:mysql://172.xx.xx.xx:3306/test?useUnicode=true&characterEncoding=gbk&useSSL=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=Hongkong

#serverTimezone=Hongkong		-时区  Asia/Shanghai
#useServerPrepStmts=false  
#rewriteBatchedStatements=true  
#useCompression=true  
#defaultFetchSize=500
#useCursorFetch=false

[Mysqld]
default-time-zone='+8:00'

[Sqlite]
org.sqlite.JDBC
jdbc:sqlite:D:\PycharmProjects\1\1.db3