I am trying save all entries of the slow query log output to a table. I started by running:
pt-query-digest slow.log --filter ‘print Dumper $event’ --no-report
which gives a hash output for perl. Is there a way it can generate csv format? or a routine to generate insert statements?
Have you looked at --history and --review options in Percona Toolkit - they insert data into tables directly, without need to specially format it https://www.percona.com/doc/percona-toolkit/LATEST/pt-query-digest.html