Reply
Highlighted
New Contributor
Posts: 4
Registered: ‎06-25-2015
Accepted Solution

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

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';

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

| Name              | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time         | Upd                                                       ate_time | Check_time | Collation       | Checksum | Create_options | Comment |

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

| 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

Cloudera Employee
Posts: 679
Registered: ‎07-30-2013

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

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

It might also be fixed in a more recent Hue
New Contributor
Posts: 4
Registered: ‎06-25-2015

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

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

New Contributor
Posts: 4
Registered: ‎06-25-2015

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

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

Announcements