美文网首页
logstash 报错from ASCII-8BIT to UT

logstash 报错from ASCII-8BIT to UT

作者: 零宽度接合 | 来源:发表于2023-01-01 00:45 被阅读0次

    要把对应的列设置成相应字符集

    input {

        stdin {}

        jdbc {

            jdbc_connection_string => "jdbc:seUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull"

            jdbc_user =>

            jdbc_password =>

            jdbc_driver_library => "/usr/local/mysqlDriver/driver/mysql-connector-java-5.1.46.jar"

            jdbc_driver_class => "com.mysql.jdbc.Driver"

            jdbc_paging_enabled => "true"

            jdbc_page_size => "50000"

            jdbc_default_timezone => "Asia/Shanghai"

            statement_filepath => "/usr/local/logstash/sql/oaesProduct.sql"

            schedule => "* * * * *"

            type => "oaes"

            use_column_value => true

            tracking_column => "update_time"

            last_run_metadata_path => "/usr/local/logstash/sql/oalasttime"

            lowercase_column_names => false

            clean_run => true

    columns_charset => {

    "message"=> "UTF-8"

    "name"=> "UTF-8"

    "content"=> "UTF-8"

    }

        }

    }

    相关文章

      网友评论

          本文标题:logstash 报错from ASCII-8BIT to UT

          本文链接:https://www.haomeiwen.com/subject/ndxccdtx.html