[IMPALA-4664] Impala shell can accidentally convert certain literal strings to lowercase

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 2.7.1
• Fix Version/s: Impala 2.12.0
• Component/s: Clients, Infrastructure
• Labels: newbie
• Assignee: Jin Chul Kim
• Reporter: Andre Araujo
• Created: 15/Dec/16 00:41
• Updated: 16/Dec/17 17:51
• Resolved: 16/Dec/17 07:20

Description

Impala shell splits each command into tokens and then converts the first token to lowercase to figure out how it should execute the command.
The splitting is done by spaces only. Thus, if the user types a TAB after the SELECT, the first token after the split becomes the SELECT plus whatever comes after it.

The command is still executed through the default Impala shell method, which sends the full command text to Impala. However, the first piece after the SELECT gets converted to lowercase:

                                     \/\/-------------------this is a TAB
[certtoolkit-permit-2:21000] > select   'DIG' as dim;
Query: select 'dig' as dim
Query submitted at: 2016-12-14 16:15:59 (Coordinator: https://certtoolkit-permit-2.gce.cloudera.com:25000)
Query progress can be monitored at: https://certtoolkit-permit-2.gce.cloudera.com:25000/query_plan?query_id=f14305e9c0893af8:c19255d900000000
+-----+
| dim |
+-----+
| dig |
+-----+
Fetched 1 row(s) in 0.02s

This can easily happen if the user is copying and pasting commands into impala-shell

Issue Links

• duplicates: IMPALA-2640 Capitalization lost from statement name when impala-shell echoes the query