Affects Version/s: 2.3.6, 3.1.1
Fix Version/s: None
Parsing of query fails when we use single or double quotes in from/to string of translate function in 2.3*/3.1.1 version of hive. Parsing of the same query is successful in 2.1.1 version of hive.
Steps to reproduce:
Parsing fails with the following exception:
Parsing is successful when double quote is escaped.
The following query works:
But the behaviour which looks buggy is when the double quote is not escaped in from/to string of translate function, it seems to be interpreting the double quote in from/to string of next translate function as ending quote.
Parsing is successful for the following queries.
The same behaviour exists when we use any other built-in functions or UDFs.