I hope this can be answered quickly. I know there's someone out there that would know this...
I am having an error with Impala because of a non-ascii character(s) in a SQL statement trying to execute in the audit service.
[NavigatorServer-4949170]: Incorrect string value: '\xEF\xBF\xBDCOM...' for column 'OPERATION_TEXT' at row 1
I have fixed this issue before by converting the character set of the target audit table (for example,
IMPALA_AUDIT_EVENTS_2019_07_19) to utf8mb4.
Also, converted the OPERATION_TEXT column to utf8mb4 character set as well...
Where can I see the full SQL statement?
NOTE: The statement in error does not show up in the CM interface for Impala under the Queries tab.