Hi Experts
I'm on a hive requirement to have my output with a particular
delimiter. My hive tables are with '\t' as the field delimiter and there are
nearly 10 of them doing the job well in production systems. As a new
requirement, we need the delimiter as a multi character string, I did a little
investigation on the same which leads to a solution like
1. Create a new target table with the required multi character fileld
delimiter using regex
2. Load the result using HQL from the source tables to this target
custom delimited table
3. Use HQL and LOAD the contents into a directory from the target table
I'd like to have a few clarifications here
1. Isn't there any solution without creating a target table? ie Is
there any hive config parameter though which we could control the output
delimiter?
2. If I have to follow the solution with the creation of a new table,
then could some one please help me with the syntax and the regex to accommodate
multiple character delimiter support in hive. My delimiter would be like ' "~"
'(a tilde character surrounded by double quotes)
Thanks in advance
Regards
Bejoy.K.S
