Does anyone know how to get Talend to create a file delimited by Hive's default field delimiter (Ctrl+A) ?
I have an EXTERNAL hive table pointing to some HDFS directory. I need to write out a file using tFileOutputDelimited to local disk and then use tHDFSPut to move it to the correct directory.
I've tried using '^A', '\001', '\u001', '\u0001' and etc, but nothing works.
If I look at the file that Talend creates, I notice that it is writing out the full \u0001 string, for example, as opposed to the ^A character. In VIM, you can create this character by hitting ctrl+v ctrl+a.
Best regards,
Matthew Moisen
