Querying Chinese Characters in Apache Drill
Nobody has claimed this yet.
Assessment
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Newbie friendliness
- 30/100
Research direction
Start by reproducing the shown SELECT query with Chinese identifiers and literals, then review the Apache Drill character-set configuration and JDBC connection-string settings mentioned in the report. Compare the query before and after processing; done means Chinese characters are preserved rather than emitted as Unicode escape sequences.
Written by the indexing model from the issue text.
Description
Dear Apache Drill Community,
I've encountered an issue when querying Chinese characters in Apache Drill. It seems that whenever I execute a query containing Chinese characters, they are automatically converted to Unicode. For example, when I execute the query:
go
SELECT name FROM `mysql`.`demo`.`表a` WHERE name = '张三'
The result returns:
go
SELECT `name` FROM `demo`.`表a` WHERE `name` = u&'\5f20\4e09'
Instead of returning the expected Chinese characters, they are represented as Unicode escape sequences.
I've tried adjusting the character set settings in Apache Drill's configuration files and JDBC connection strings, but the issue persists. Is there a specific configuration or workaround to prevent Apache Drill from automatically converting Chinese characters to Unicode?
Any assistance or guidance on resolving this issue would be greatly appreciated.
Thank you
- Dominant language
- Java
- Stars
- 2k
- Forks
- 989
- Avg merge
- 1d 14h
- Merged PRs (30d)
- 4
Getting set up
- Ships a Dockerfile or Docker Compose file
- Has a pull request template
- No contributing guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from apache/drill
-
Difficulty 5/5 Over a week Newbie friendliness 35/100
-
bug
Difficulty 4/5 3-5 days Newbie friendliness 35/100
-
bug
Difficulty 4/5 3-5 days Newbie friendliness 28/100
-
bug
Difficulty 4/5 3-5 days Newbie friendliness 35/100
-
Difficulty 4/5 3-5 days Newbie friendliness 35/100
Similar issues
-
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
objectionary/eo#9182 ·
Maintainers usually reply within 1 day
-
Difficulty 2/5 1-3 hours Newbie friendliness 88/100
objectionary/hone-maven-plugin#1293 ·
Maintainers usually reply within 1 day
-
1.severity: security
Difficulty 2/5 1-3 hours Newbie friendliness 62/100
NixOS/nixpkgs#569828 · 1 reaction ·
Maintainers usually reply within 1 day
-
Difficulty 2/5 1-3 hours Newbie friendliness 88/100
Maintainers usually reply within 1 day
-
Difficulty 2/5 1-3 hours Newbie friendliness 88/100
MaikuB/flutter_appauth#683 ·