Skip to content

Cannot execute hive sql include chinese characters in CDH-5.9.0-1.cdh5.9.0.p0.23 #470

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

Closed
binyan17 opened this issue Jan 5, 2017 · 4 comments

Comments

@binyan17
Copy link

binyan17 commented Jan 5, 2017

hi,buddy,
We found the same bug in CDH-5.9.0-1.cdh5.9.0.p0.23.
We cannot execute sql in hue.
Can you tell me any solution ,thanks!

Error logs as follow:

[05/Jan/2017 20:16:08 +0800] decorators ERROR Error running <function get_logs at 0x7fa85d805320>
Traceback (most recent call last):
File "/opt/cloudera/parcels/CDH-5.9.0-1.cdh5.9.0.p0.23/lib/hue/desktop/libs/notebook/src/notebook/decorators.py", line 81, in decorator
try:
File "/opt/cloudera/parcels/CDH-5.9.0-1.cdh5.9.0.p0.23/lib/hue/desktop/libs/notebook/src/notebook/api.py", line 276, in get_logs

UnicodeEncodeError: 'ascii' codec can't encode characters in position 147-148: ordinal not in range(128)

@romainr
Copy link
Contributor

romainr commented Jan 7, 2017

Please, could you share your query so that we can try ti reproduce it?

@romainr romainr closed this as completed Feb 2, 2017
@wemersoncesar
Copy link

Hi guys,

I'm getting the same error with portuguese caracters :

ERROR:

select * from product p where p.name = "CAPITALIZAÇÃO" limit 100;
decorators ERROR Error running <function get_logs at 0x7fb80571ce60>
Traceback (most recent call last):
File "/opt/cloudera/parcels/CDH-5.9.0-1.cdh5.9.0.p0.23/lib/hue/desktop/libs/notebook/src/notebook/decorators.py", line 81, in decorator
return func(*args, **kwargs)
File "/opt/cloudera/parcels/CDH-5.9.0-1.cdh5.9.0.p0.23/lib/hue/desktop/libs/notebook/src/notebook/api.py", line 276, in get_logs
full_log = str(request.POST.get('full_log', ''))
UnicodeEncodeError: 'ascii' codec can't encode characters in position 162-163: ordinal not in range(128)

@romainr
Copy link
Contributor

romainr commented Feb 7, 2017

https://issues.cloudera.org/browse/HUE-4815 Fixed in Hue 3.12 or CDH5.10

@wemersoncesar
Copy link

Hi!
If you are using CDH-5.9.0, to avoid this problem just click on Cloudera Manager => Hue => Configuration, type default_site_encoding and change to UTF-8 or another.
Romainr, Thanks!

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

No branches or pull requests

3 participants