search

cloudera / hue

Open source SQL Query Assistant service for Databases/Warehouses
https://cloudera.com
Apache License 2.0
1.17k stars 366 forks source link

Hue3.6.0 non-ascii character hive query error #85

Closed clive82 closed 10 years ago

clive82 commented 10 years ago

When Hive query string includes non-ascii character ,e.g select count(*) from wvs_of_surprise where version='中文查询'; HUE reports below error: (1366, "Incorrect string value: '\xE4\xB8\xAD\xE6\x96\x87...' for column 'query' at row 1")

romainr commented 10 years ago

This works on demo.gethue.com/beeswax/ with CDH5.0. Which distribution are you using?

select count(*) from sample_07 where description='中文查询';

clive82 commented 10 years ago

tallball release-3.6.0 i notes that it's ok for mysql 5.0.77,wrong for 5.6.10-enterprise-commercial

romainr commented 10 years ago

MySql does not matter here as it would either be a Hive or Impala query. What are theses versions?