You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Roberto Coluccio (Jira)" <ji...@apache.org> on 2021/05/05 09:43:00 UTC
[jira] [Commented] (IMPALA-7664) Flag to tell imapala-shell to
don't try to escape anything with -q/-o
[ https://issues.apache.org/jira/browse/IMPALA-7664?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17339556#comment-17339556 ]
Roberto Coluccio commented on IMPALA-7664:
------------------------------------------
+1
Did you put in place any workarounds meanwhile?
> 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
> Priority: Minor
>
> 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
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org