Page 1 of 1

Trying to pass a Cntrl A as a delimiter to Hadoop

Posted: Fri Feb 03, 2017 3:04 pm
by JPalatianos
Hi
We are running DataStage 11.5 on Red Hat Linux and we are connecting to Cloudera's version of Hadoop utilizing the File Connector stage. The Hadoop admins are requesting that we use a ctrl-A as a column delimiter. They told us that the physical value is "\001". We tried putting this in the delimiter property but they end up receiving the "\001" between columns.

Is anyone else attempting this?

Thanks - - John

Posted: Fri Feb 03, 2017 5:01 pm
by JRodriguez
Try escaping the back slash.....and format as Unicode character like below

\\u0001