connect storage engine unable to read escape character in quote from CSV

create table audit_log (

    logtime char(17),  

    serverhost varchar(128), 

    username varchar(128), 

    host varchar(128), 

    connectionid int unsigned,  

    queryid int unsigned,  

    operation varchar(128), 

    databasename varchar(128), 

    object varchar(512), 

    retcode int unsigned

)  

    engine=CONNECT table_type=CSV 

    file_name='/home/mysql/test/server_audit.log' 

    data_charset='utf8' QCHAR='''' quoted=1;

 20161102 10:24:41,luovm1,root,localhost,5,17,QUERY,,'load data infile \'discounts.csv\'',1046

> select * from audit_log limit 20;

ERROR 1296 (HY000): Got error 122 'Missing field 9 in audit_log1 line 20' from CONNECT