Hi Lu,
Please find faq page:
http://carbondata.apache.org/docs/latest/faq.htmlI think you should add option 'BAD_RECORDS_ACTION'='FORCE' to load sql.
e.g. load data ... options( 'BAD_RECORDS_ACTION'='FORCE')
Best Regards
David QiangCai
Best Regards
David Cai