question Receiving Error "Incorrect string value: '\xC5\x9F\xC4\xB1k ...' for column 'query' at row1 in Archives of Support Questions (Read Only)

Receiving Error "Incorrect string value: '\xC5\x9F\xC4\xB1k ...' for column 'query' at row1

Chaitanya_hadoop — Tue, 21 Apr 2026 13:46:56 GMT

Hi All,

While running query in hive query editor from HUE I am getting the below error, tried changed the collation to UTF8 but still getting the same error.

"Incorrect string value: '\xC5\x9F\xC4\xB1k ...' for column 'query' at row 1"

Mysql version: 5.6

HUE version: 3.9

mysql> show table status like 'desktop_document2';

+-------------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---- ---------+------------+-----------------+----------+----------------+---------+

| desktop_document2 | InnoDB | 10 | Compact | 94 | 39217 | 3686400 | 0 | 114688 | 4194304 | 50193 | 2017-04-06 16:56:23 | NUL L | NULL | utf8_general_ci | NULL | | |

1 row in set (0.00 sec)

Thanks

Chaitanya

Re: Receiving Error "Incorrect string value: '\xC5\x9F\xC4\xB1k ...' for column 'query' at row1

Romainr — Sat, 08 Apr 2017 14:48:22 GMT

Is the trace coming from Hue or when Hue access the DB?

It might also be fixed in a more recent Hue

Re: Receiving Error "Incorrect string value: '\xC5\x9F\xC4\xB1k ...' for column 'query' at row1

Chaitanya_hadoop — Mon, 10 Apr 2017 05:43:34 GMT

Hi Romainr,

This is i got from hue when accessing data by hive query editor but, I am able to get the result from hive cli as expected.

"It might also be fixed in a more recent Hue" -- As infomed that there is fix in newer versions could you pls help me, how can I upgrade.

I am using Hue 3.9 tarbal, Please help me how can I upgrade to new version, In additon to that please help me how can i get import the workflows,coordinatos and bundles in to new version of hue [ as i see 84 tables in the hue database and it is 78 earlier].

Thanks in advance

Regards

Chaitanya

Re: Receiving Error "Incorrect string value: '\xC5\x9F\xC4\xB1k ...' for column 'query' at row1

Chaitanya_hadoop — Wed, 19 Apr 2017 05:08:36 GMT

Hi Romainr,

As suggested, I switch to new version of HUE 3.12. After changing the below character set, those are working as expected. Thanks for your suggestion.

mysql> ALTER TABLE desktop_document2 modify column name varchar(255) CHARACTER SET utf8;
Query OK, 4 rows affected (0.26 sec)
Records: 4 Duplicates: 0 Warnings: 0

mysql> ALTER TABLE desktop_document2 modify column description longtext CHARACTER SET utf8;
Query OK, 4 rows affected (0.16 sec)
Records: 4 Duplicates: 0 Warnings: 0

mysql> ALTER TABLE desktop_document2 modify column search longtext CHARACTER SET utf8;
Query OK, 4 rows affected (0.15 sec)
Records: 4 Duplicates: 0 Warnings: 0

Regards

Chaitanya