Skip to content

Query UUID of PostgreSQL failed #638

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.

Sign up for GitHub

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

Jump to bottom
Closed
grieve54706 opened this issue Jun 28, 2024 · 2 comments · Fixed by #646
Closed

Query UUID of PostgreSQL failed #638

grieve54706 opened this issue Jun 28, 2024 · 2 comments · Fixed by #646
Labels
bug Something isn't working

Comments

@grieve54706
Copy link
Contributor

When getting data with UUID from PostgreSQL, the system will raise an exception when Pandas Dataframe to JSON.
Unsupported UTF-8 sequence length when encoding string or UnicodeDecodeError: 'utf-8' codec can't decode byte 0xa1 in position 183: invalid start byte
@grieve54706 grieve54706 added the bug Something isn't working label Jun 28, 2024
@grieve54706
Copy link
Contributor Author

Follow pandas-dev/pandas#59132

@goldmedal goldmedal mentioned this issue Jul 3, 2024
Merged
@grieve54706
Copy link
Contributor Author

grieve54706 commented Jul 3, 2024 •
edited
Loading

Using df.to_dict and orjson to serialize UUID. b79185d

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug Something isn't working
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Add data source ClickHouse Canner/wren-engine
1 participant
@grieve54706