Funny characters in output file from Impala shell

MartinEK — Fri, 16 Sep 2022 09:22:12 GMT

Hi,

I want to output the results of some queries passed to impala-shell (in the real scenario read from an input file) to an output file. I have observed that when I redirect the output of impala-shell to a file in the normal bash way, there are some funny characters printed at the beginning of each result block ^[[?1034h (please see screenshot below):

impala-shell --quiet -i server:port -d database -q "select count(*) as cnt from table1" > output.txt

When the following syntax is used, the funny characters are not printed:

impala-shell --quiet -i server:port -d database -q "select count(*) as cnt from table1" -o output.txt

Is this a bug in impala-shell or how would I stop those funny characters from appearing? For some other reasons I need to use the standard redirection to a file rather than the -o option.

Thanks,

Martin

Re: Funny characters in output file from Impala shell

athtsang — Mon, 23 Feb 2015 02:25:28 GMT

This is by design. I forgot the rationale. It can be avoided by setting env variable TERM to linux

(for bash and friends)

export TERM=linux

Re: Funny characters in output file from Impala shell

MartinEK — Mon, 23 Feb 2015 03:34:19 GMT

This fixes the issue. Thanks a lot for quick reply!

question Funny characters in output file from Impala shell in Archives of Support Questions (Read Only)

Funny characters in output file from Impala shell

Re: Funny characters in output file from Impala shell

Re: Funny characters in output file from Impala shell