Details
-
Bug
-
Status: Open
-
Major
-
Resolution: Unresolved
-
1.1.0, 2.3.6
-
None
-
None
-
Cloudera 5.15.1 Hive 1.1.0
beeline and Impala
Description
I have a table in hive with a column having special character like £. When I try to a query as simple as 'SELECT * FROM TABLE WHERE COL = "£"; ', the query does not come back with any result.
The table data is UTF-8 encoded. The sql file that contains the above sql and run via beeline is also UTF-8 encoded.
Interestingly, if I try to create the run the same query using impala against the same table, I get back the columns containing the £ symbol.
Also when the data from the table is exported (SELECT * FROM THE TABLE and save the output to csv file) the column with special character is shown as NULL.
Steps to replicate:
- create test.sql file with the below content:
CREATE TABLE T1 (test String); INSERT INTO T1 VALUES('£');
- beeline>!run test.sql
- create another file test_select.sql with the below content:
SELECT * FROM T1 WHERE test='£';
- beeline>!run test_select.sql
- No results will be returned back