You can pip install impala-shell from github: $ pip install git+git://github.com/dknupp/impala-shell.git afterwards you can run impala-shell to connect to your cluster:   $ impala-shell -i my_impalad.foo.cloudera.com   For more information go to: https://github.com/dknupp/impala-shell ... View more

Impala does not support backslashes/quotes to avoid interpretation of format letters. To get the desired format, you can do something like this: select regexp_replace(from_unixtime(unix_timestamp('2017-04-13 08:10:11'),'yyyy-MM-ddTHH'), 'T', 'H'); ... View more