Support Questions
Find answers, ask questions, and share your expertise
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Impala Shell Intereactive mode question -CDH 5.13


Impala Shell Intereactive mode question -CDH 5.13

Hi sir,


I'm using impala-shell in CDH 5.13 & typing some queries in the shell.But I cannot move forward & backward in the shell to get the last typed command.pls find the below screen shot for your refrence.How to enable the user friendly  mode in impala to get the commands which i typed last or any other commands.When i press the keys it gives like this quickstart.cloudera:21000] > ^[[A^[[A^[[A^[[A^[[A^[[A.please help me on this.


[cloudera@quickstart ~]$ impala-shell
Starting Impala Shell without Kerberos authentication
Connected to quickstart.cloudera:21000
Server version: impalad version 2.11.0-cdh5.14.2 RELEASE (build ed85dce709da9557aeb28be89e8044947708876c)
Welcome to the Impala shell.
(Impala Shell v2.10.0-cdh5.13.0 (2511805) built on Wed Oct  4 10:55:37 PDT 2017)

You can change the Impala daemon that you're connected to by using the CONNECT
command.To see how Impala will plan to run your query without actually executing
it, use the EXPLAIN command. You can change the level of detail in the EXPLAIN
output by setting the EXPLAIN_LEVEL query option.
[quickstart.cloudera:21000] > show databases;
Query: show databases
| name             | comment                                      |
| _impala_builtins | System database for Impala builtin functions |
| default          | Default Hive database                        |
| shopping         | stores all shopping basket data              |
| toys             |                                              |
Fetched 4 row(s) in 0.11s
[quickstart.cloudera:21000] > use tables'
                            > ;
                            > ^C

[quickstart.cloudera:21000] > use toys;
Query: use toys
[quickstart.cloudera:21000] > show tables;
Query: show tables
| name           |
| canada_facts   |
| canada_regions |
Fetched 2 row(s) in 0.11s
[quickstart.cloudera:21000] > select * from canada_facts;
Query: select * from canada_facts
Query submitted at: 2018-06-10 23:03:05 (Coordinator: http://quickstart.cloudera:25000)
Query progress can be monitored at: http://quickstart.cloudera:25000/query_plan?query_id=3a4a34ab6b187c7b:469e490700000000
Fetched 0 row(s) in 0.22s
[quickstart.cloudera:21000] > ^[[A^[[A^[[A^[[A^[[A^[[A