Hive / HCatalog Forum
INSTR with UTF8 String
Using the INSTR fuction to find the posistion of a substring within a string works fine for normal ANSI data but for UTF8 it always returns zero. I saw this issue with a file but it also occurs when using a string constant, for example:
select SUBSTR (‘НАСТРОЕние’, ‘P’) from …
Support from the Experts
A HDP Support Subscription connects you experts with deep experience running Apache Hadoop in production, at-scale on the most demanding workloads.
Become HDP Certified
Real world training designed by the core architects of Hadoop. Scenario-based training courses are available in-classroom or online from anywhere in the world