[
https://issues.apache.org/jira/browse/KYLIN-1472?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15184330#comment-15184330
]
Zhong,Jason edited comment on KYLIN-1472 at 3/8/16 3:37 AM:
------------------------------------------------------------
Hi [~nichunen]
I think this patch is duplicated with
https://issues.apache.org/jira/browse/KYLIN-1373
for sql like "select count(*) from KYLIN_SALES WHERE LSTG_FORMAT_NAME not in
('2013&2014')"
the special character '&' will cause export failed.
to solve all these same issues, I suggest use encodeURIComponent
http://xkr.us/articles/javascript/encode-compare/
was (Author: zhongjian):
Hi [~nichunen]
I think this patch is duplicated with
https://issues.apache.org/jira/browse/KYLIN-1373
for sql like "select count(*) from KYLIN_SALES WHERE LSTG_FORMAT_NAME not in
('2013&2014')"
the special character '&' will cause export failed.
to solve all these same issues, I suggest use encodeURIComponentin
http://xkr.us/articles/javascript/encode-compare/
> Export csv get error when there is a plus sign in the sql
> ---------------------------------------------------------
>
> Key: KYLIN-1472
> URL: https://issues.apache.org/jira/browse/KYLIN-1472
> Project: Kylin
> Issue Type: Bug
> Components: Web
> Affects Versions: v2.0, v1.2
> Reporter: nichunen
> Assignee: Zhong,Jason
> Fix For: v2.1, v1.4
>
> Attachments: KYLIN-1472-FOR1X.patch, KYLIN-1472-FOR2X.patch
>
>
> For example, query the sample cube with "select max(price)+min(price) from
> KYLIN_SALES", get the result on the web window. But click the "export" button
> get an error message "Encountered \"min\" at line 1, column 19. Was expecting
> one of...".
> This is because the export button visit the api url directly, in the url, the
> plus sign is treated as blank, so kylin server get sql "select max(price)
> min(price) from KYLIN_SALES" which is an invalid sql.
> I will submit two patches for 1.x and 2.x.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
