We have some data that has a backslash (\) and noticed that when loading into Hive, it treats it as an escape character. Is there a way to get around it treating this as an escape character?
I have tried replacing a single backslash with 2 backslashes and it still give me the same result.
The only other thing i could think of doing is just replacing the backslash with the encoded version of that value.
We are loading the data from an external table via the CSVSerde. In the temp table we can view the backslashes, but once we load it into the ORC format via the CSVSerde the backslashes, no matter how many there are, they disappear.
@Shishir Saxena: This link is not working
https://documentation.altiscale.com/using-csv-serde-with-hive It has example of how to use a different escape character.
Can you post the contents of the above link here? or give a different link that works?