Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

stuck when Routine Load task used url_decode #45259

Open
egogao123 opened this issue May 8, 2024 · 2 comments
Open

stuck when Routine Load task used url_decode #45259

egogao123 opened this issue May 8, 2024 · 2 comments

Comments

@egogao123
Copy link

image

ERROR 1064 (HY000): Expr evaluate meet error: decode string contains illegal hex chars: 2

When using the urlencode function in a routine load task, if data anomalies cause function parsing to fail, the routine load task will be stuck until the offset expires.

StarRocks version
3.1.7-7e897e2

@rickif
Copy link
Contributor

rickif commented May 8, 2024

@jaogoy PTAL.

@jaogoy
Copy link
Contributor

jaogoy commented May 23, 2024

@egogao123 Can you give the whole Rouitne Load job info?
In my opinion, if url_decode failed to process a string, the row should be recoganized as an Error row if strict_mode = true, or a normal row with a NULL field if strict_mode = false.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants