minor, save query result by form submit request
Project: http://git-wip-us.apache.org/repos/asf/kylin/repo Commit: http://git-wip-us.apache.org/repos/asf/kylin/commit/f8e8d43d Tree: http://git-wip-us.apache.org/repos/asf/kylin/tree/f8e8d43d Diff: http://git-wip-us.apache.org/repos/asf/kylin/diff/f8e8d43d Branch: refs/heads/2.1.x Commit: f8e8d43d843296e2bc5cb08ba335a6529598ba89 Parents: 8009c2f Author: Roger Shi <rogershijich...@hotmail.com> Authored: Tue Jul 25 14:55:33 2017 +0800 Committer: Roger Shi <rogershijich...@hotmail.com> Committed: Tue Jul 25 15:30:23 2017 +0800 ---------------------------------------------------------------------- .../kylin/rest/controller2/QueryControllerV2.java | 12 +++++++++--- 1 file changed, 9 insertions(+), 3 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/kylin/blob/f8e8d43d/server-base/src/main/java/org/apache/kylin/rest/controller2/QueryControllerV2.java ---------------------------------------------------------------------- diff --git a/server-base/src/main/java/org/apache/kylin/rest/controller2/QueryControllerV2.java b/server-base/src/main/java/org/apache/kylin/rest/controller2/QueryControllerV2.java index 7a74765..5809d6e 100644 --- a/server-base/src/main/java/org/apache/kylin/rest/controller2/QueryControllerV2.java +++ b/server-base/src/main/java/org/apache/kylin/rest/controller2/QueryControllerV2.java @@ -20,7 +20,9 @@ package org.apache.kylin.rest.controller2; import java.io.IOException; import java.sql.SQLException; +import java.text.SimpleDateFormat; import java.util.ArrayList; +import java.util.Date; import java.util.HashMap; import java.util.List; import java.util.Map; @@ -45,6 +47,7 @@ import org.slf4j.Logger; import org.slf4j.LoggerFactory; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.beans.factory.annotation.Qualifier; +import org.springframework.http.MediaType; import org.springframework.security.core.context.SecurityContextHolder; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.PathVariable; @@ -153,14 +156,17 @@ public class QueryControllerV2 extends BasicController { } @RequestMapping(value = "/query/format/{format}", method = RequestMethod.POST, produces = { - "application/vnd.apache.kylin-v2+json" }) + "application/vnd.apache.kylin-v2+json" }, consumes = MediaType.APPLICATION_FORM_URLENCODED_VALUE) @ResponseBody - public void downloadQueryResultV2(@PathVariable String format, @RequestBody SQLRequest sqlRequest, + public void downloadQueryResultV2(@PathVariable String format, SQLRequest sqlRequest, HttpServletResponse response) { SQLResponse result = queryService.doQueryWithCache(sqlRequest); + + SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMddHHmmssSSS"); + String nowStr = sdf.format(new Date()); response.setContentType("text/" + format + ";charset=utf-8"); - response.setHeader("Content-Disposition", "attachment; filename=\"result." + format + "\""); + response.setHeader("Content-Disposition", "attachment; filename=\"" + nowStr + ".result." + format + "\""); ICsvListWriter csvWriter = null; try {