I have a question on quoted hive query when executed with 'hive -e'. The command I ran looks like:
> hive -e "select regexp_extract(col1, '\\d+') from A where col2='some value' limit 5"
When the query get passed into hive, it is interpreted as
> select regexp_extract(col1, \d+') from A where col2='some value' limit 5
As you can see, the regex patten is translated from '\\d+' to '\d+' due to the escape character.
By using single quote at the outer level and double quotes within query itself, I can get around this problem. It also works by putting the query in a file and running with 'hive -f'. But both approaches needs amendments to the application and sounds a little tactical.
My questions are
1) Does hive handle escaping or the linux shell interprete it before passing to hive.
2) Other than the 2 workarounds I mentioned, is there any other option?
Thank you for your feedback in advance.