[IMPALA-261] impala-shell converting multi-line query including literals to lower case

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 0.7
• Fix Version/s: Impala 1.0
• Component/s: Clients
• Labels: shell
• Assignee: Ishaan Joshi
• Reporter: jaideep dhok
• Created: 16/Apr/13 10:56
• Updated: 28/Dec/15 17:43
• Resolved: 23/Apr/13 18:06

Description

When I run the query -
select pq_network_fact.day_key,
sum(pq_network_fact.spend)
from pq_network_fact join impala_account_dim on pq_network_fact.advertiser_account_key = impala_account_dim.account_key join impala_date_dim on pq_network_fact.day_key = impala_date_dim.day_key
where
impala_date_dim.day_key = 1554 and
impala_account_dim.account_name="King.com"
group by pq_network_fact.day_key;

Impala-shell is converting it to -

Query: select pq_network_fact.day_key,
sum(pq_network_fact.spend)
from pq_network_fact join impala_account_dim on pq_network_fact.advertiser_account_key = impala_account_dim.account_key join impala_date_dim on pq_network_fact.day_key = impala_date_dim.day_key
where
impala_date_dim.day_key = 1554 and
impala_account_dim.account_name="king.com" group by pq_network_fact.day_key

This seems to be happening only when there are newlines in the query.