src/main/resources/dcs-webapps/master/queryPlan.jsp

<!-- @@@ START COPYRIGHT @@@                                                         -->
<!--                                                                                 -->
<!-- (C) Copyright 2015 Hewlett-Packard Development Company, L.P.                    -->
<!--                                                                                 -->
<!-- Licensed under the Apache License, Version 2.0 (the "License");                 -->
<!-- you may not use this file except in compliance with the License.                -->
<!-- You may obtain a copy of the License at                                         -->
<!--                                                                                 -->
<!--      http://www.apache.org/licenses/LICENSE-2.0                                 -->
<!--                                                                                 -->
<!-- Unless required by applicable law or agreed to in writing, software             -->
<!-- distributed under the License is distributed on an "AS IS" BASIS,               -->
<!-- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.        -->
<!-- See the License for the specific language governing permissions and             -->
<!-- limitations under the License.                                                  -->
<!--                                                                                 -->
<!-- @@@ END COPYRIGHT @@@                                                           -->
<%@ page contentType="text/html;charset=UTF-8"
  import="java.io.*"
  import="java.util.*"
  import="org.apache.hadoop.conf.Configuration"
  import="org.trafodion.dcs.master.DcsMaster"
  import="org.trafodion.dcs.util.DcsConfiguration"
  import="org.trafodion.dcs.Constants"
  import="org.trafodion.dcs.util.Bytes"
  import="org.codehaus.jettison.json.JSONArray"
  import="org.codehaus.jettison.json.JSONException"
  import="org.codehaus.jettison.json.JSONObject"
  import="org.trafodion.dcs.master.QueryPlanModel"
  import="org.trafodion.dcs.master.QueryPlanResponse"
  import="org.codehaus.jackson.JsonGenerationException"
  import="org.codehaus.jackson.map.JsonMappingException"
  import="org.codehaus.jackson.map.ObjectMapper"
 %>
<% 
  try {
      DcsMaster master = (DcsMaster)getServletContext().getAttribute(DcsMaster.MASTER);
      Configuration conf = master.getConfiguration();
  
      BufferedReader br = new BufferedReader(new InputStreamReader(request.getInputStream()));
      String json = "";
      if(br != null) {
          json = br.readLine();
      }
  
      JSONObject jsonObject = new JSONObject(json);
      String sQuery = jsonObject.getString("sQuery");
      String sControlStmts = jsonObject.getString("sControlStmts");
  
      if(sQuery == null || sQuery.trim().length() < 1) {
          response.setContentType("text/plain");
          response.setStatus(response.SC_INTERNAL_SERVER_ERROR);
          response.getWriter().print("The query text cannot be empty");
          return;
      }
 
      QueryPlanModel qpm = new QueryPlanModel();
      qpm.GeneratePlan(master.getServerManager().getJdbcT4Util(),sQuery, sControlStmts);
      QueryPlanResponse qpr = qpm.getQueryPlanResponse();
      ObjectMapper mapper = new ObjectMapper();
      JSONObject queryPlanJson = null;
      queryPlanJson = new JSONObject(mapper.writeValueAsString(qpr));
      response.setContentType("application/json");
      response.getWriter().print(queryPlanJson);
  } catch (Exception e) {
       response.setContentType("text/plain");
       response.setStatus(response.SC_INTERNAL_SERVER_ERROR);
       response.getWriter().print(e.getMessage());
  }
  %>