Running Commands and SQL Statements in impala-shell

For information on available commands, see impala-shell Command Reference. You can see the full set of available commands by pressing TAB twice:

[impalad-host:21000] >
connect   describe  explain   help      history   insert    quit      refresh   select    set       shell     show      use       version
[impalad-host:21000] >

For example:

[impalad-host:21000] > select * from alltypessmall limit 5
Query: select * from alltypessmall limit 5
Query finished, fetching results ...
2009    3       50      true    0       0       0       0       0       0       03/01/09        0       2009-03-01 00:00:00
2009    3       51      false   1       1       1       10      1.100000023841858       10.1    03/01/09        1       2009-03-01 00:01:00
2009    3       52      true    2       2       2       20      2.200000047683716       20.2    03/01/09        2       2009-03-01 00:02:00.100000000
2009    3       53      false   3       3       3       30      3.299999952316284       30.3    03/01/09        3       2009-03-01 00:03:00.300000000
2009    3       54      true    4       4       4       40      4.400000095367432       40.4    03/01/09        4       2009-03-01 00:04:00.600000000
Returned 5 row(s) in 0.10s
[impalad-host:21000] >