in:
  type: file
  path_prefix: '/mysql/data/test1.csv'
  parser:
    charset: UTF-8
    newline: CRLF
    type: csv
    delimiter: ','
    quote: ''
    columns:
    - {name: id, type: string}
    - {name: int_item, type: long}
    - {name: varchar_item, type: string}
out:
    type: mysql
    host: #host#
    database: #database#
    user: #user#
    password: #password#
    table: test1
    mode: truncate_insert
    before_load: "insert into test1 values('C001', 0, 'x')"