Aaron Baff created IMPALA-7664:
----------------------------------
Summary: Flag to tell imapala-shell to don't try to escape
anything with -q/-o
Key: IMPALA-7664
URL: https://issues.apache.org/jira/browse/IMPALA-7664
Project: IMPALA
Issue Type: Improvement
Components: Frontend
Affects Versions: Impala 2.11.0
Environment: CentOS Linux release 7.4.1708
CDH 5.14.4
Reporter: Aaron Baff
I'm running into a real pain point where I'm assembling a SQL query to store
into our RDBMS, and some of the data contains a double-quote in it. When I run
it in impala-shell with -o output file option, it turns the double quote into 2
double quotes, and double quotes around the entire string.
While I understand this is technically the correct way to go about a double
quote in a tab/comma delimited file, this is the opposite of what I want since
it's only a single field, and in the SQL query it's already properly enclosed
in a single quoted string.
So it'd be really nice to have a option or variable setting to have
impala-shell NOT do this behavior. Just take whatever the value of the field
and output as is, ignoring any attempts to escape/quote the value. Maybe this
is an extreme corner case, but I imagine some other folks have probably hit it.
As it is, I'm going to have to figure out a work-around which is probably going
to be some kind of sed on the output file.
Since this is on CDH, here's the full version info:
Shell version: Impala Shell v2.11.0-cdh5.14.4 (20e6356) built on Tue Jun 12
03:43:08 PDT 2018
Server version: impalad version 2.11.0-cdh5.14.4 RELEASE (build
20e635646a13347800fad36a7d0b1da25ab32404)
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
