Affects Version/s: 1.1.0, 2.3.6
Fix Version/s: None
Cloudera 5.15.1 Hive 1.1.0
beeline and Impala
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:
- beeline>!run test.sql
- create another file test_select.sql with the below content:
- beeline>!run test_select.sql
- No results will be returned back