Java Code Examples for org.apache.kylin.rest.response.SQLResponse#setTotalScanCount()

The following examples show how to use org.apache.kylin.rest.response.SQLResponse#setTotalScanCount() . You can vote up the ones you like or vote down the ones you don't like, and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.
Example 1
Source File: QueryMetricsTest.java    From kylin-on-parquet-v2 with Apache License 2.0 4 votes vote down vote up 
@Test
public void testQueryMetrics() throws Exception {
    System.setProperty("kylin.server.query-metrics-enabled", "true");
    QueryMetricsFacade.init();

    SQLRequest sqlRequest = new SQLRequest();
    sqlRequest.setSql("select * from TEST_KYLIN_FACT");
    sqlRequest.setProject("default");

    SQLResponse sqlResponse = new SQLResponse();
    sqlResponse.setDuration(10);
    sqlResponse.setCube("test_cube");
    sqlResponse.setIsException(false);
    sqlResponse.setTotalScanCount(100);
    List<String> list1 = new ArrayList<>();
    list1.add("111");
    list1.add("112");
    List<String> list2 = new ArrayList<>();
    list2.add("111");
    list2.add("112");
    List<List<String>> results = new ArrayList<>();
    results.add(list1);
    results.add(list2);
    sqlResponse.setResults(results);
    sqlResponse.setStorageCacheUsed(true);

    QueryMetricsFacade.updateMetrics(sqlRequest, sqlResponse);

    Thread.sleep(2000);

    Assert.assertEquals(1L, mBeanServer.getAttribute(objectName, "QueryCount"));
    Assert.assertEquals(1L, mBeanServer.getAttribute(objectName, "QuerySuccessCount"));
    Assert.assertEquals(0L, mBeanServer.getAttribute(objectName, "QueryFailCount"));
    Assert.assertEquals(1L, mBeanServer.getAttribute(objectName, "CacheHitCount"));

    Assert.assertEquals(1L, mBeanServer.getAttribute(objectName, "ScanRowCountNumOps"));
    Assert.assertEquals(100.0, mBeanServer.getAttribute(objectName, "ScanRowCountAvgTime"));
    Assert.assertEquals(100.0, mBeanServer.getAttribute(objectName, "ScanRowCountMaxTime"));
    Assert.assertEquals(100.0, mBeanServer.getAttribute(objectName, "ScanRowCountMinTime"));

    Assert.assertEquals(1L, mBeanServer.getAttribute(objectName, "ResultRowCountNumOps"));
    Assert.assertEquals(2.0, mBeanServer.getAttribute(objectName, "ResultRowCountMaxTime"));
    Assert.assertEquals(2.0, mBeanServer.getAttribute(objectName, "ResultRowCountAvgTime"));
    Assert.assertEquals(2.0, mBeanServer.getAttribute(objectName, "ResultRowCountMinTime"));

    Assert.assertEquals(1L, mBeanServer.getAttribute(objectName, "QueryLatencyNumOps"));
    Assert.assertEquals(10.0, mBeanServer.getAttribute(objectName, "QueryLatencyMaxTime"));
    Assert.assertEquals(10.0, mBeanServer.getAttribute(objectName, "QueryLatencyAvgTime"));
    Assert.assertEquals(10.0, mBeanServer.getAttribute(objectName, "QueryLatencyMinTime"));

    SQLResponse sqlResponse2 = new SQLResponse();
    sqlResponse2.setDuration(10);
    sqlResponse2.setCube("test_cube");
    sqlResponse2.setIsException(true);

    QueryMetricsFacade.updateMetrics(sqlRequest, sqlResponse2);

    Thread.sleep(2000);

    Assert.assertEquals(2L, mBeanServer.getAttribute(objectName, "QueryCount"));
    Assert.assertEquals(1L, mBeanServer.getAttribute(objectName, "QuerySuccessCount"));
    Assert.assertEquals(1L, mBeanServer.getAttribute(objectName, "QueryFailCount"));

    System.clearProperty("kylin.server.query-metrics-enabled");
}
Example 2
Source File: QueryMetricsTest.java    From kylin-on-parquet-v2 with Apache License 2.0 4 votes vote down vote up 
@Test
public void testQueryStatisticsResult() throws Exception {
    System.setProperty("kylin.metrics.reporter-query-enabled", "true");
    QueryMetricsFacade.init();

    SQLRequest sqlRequest = new SQLRequest();
    sqlRequest.setSql("select * from TEST_KYLIN_FACT");
    sqlRequest.setProject("default");

    QueryContext context = QueryContextFacade.current();
    
    SQLResponse sqlResponse = new SQLResponse();
    sqlResponse.setDuration(10);
    sqlResponse.setCube("test_cube");
    sqlResponse.setIsException(false);
    sqlResponse.setTotalScanCount(100);
    List<String> list1 = new ArrayList<>();
    list1.add("111");
    list1.add("112");
    List<String> list2 = new ArrayList<>();
    list2.add("111");
    list2.add("112");
    List<List<String>> results = new ArrayList<>();
    results.add(list1);
    results.add(list2);
    sqlResponse.setResults(results);
    sqlResponse.setStorageCacheUsed(true);

    int ctxId = 0;
    context.addContext(ctxId, "OLAP", true);
    context.addRPCStatistics(ctxId, "sandbox", "test_cube", "20100101000000_20150101000000", 3L, 3L, 3L, null, 80L,
            0L, 2L, 2L, 0L, 30L);

    sqlResponse.setCubeSegmentStatisticsList(context.getCubeSegmentStatisticsResultList());

    QueryMetricsFacade.updateMetrics(sqlRequest, sqlResponse);

    Thread.sleep(2000);

    System.clearProperty("kylin.server.query-metrics-enabled");
    System.out.println("------------testQueryStatisticsResult done------------");
}
Example 3
Source File: QueryMetrics2Test.java    From kylin-on-parquet-v2 with Apache License 2.0 4 votes vote down vote up 
@Test
public void testQueryMetrics() throws Exception {
    System.setProperty("kylin.server.query-metrics2-enabled", "true");
    QueryMetrics2Facade.init();
    SQLRequest sqlRequest = new SQLRequest();
    sqlRequest.setSql("select * from TEST_KYLIN_FACT");
    sqlRequest.setProject("default");
    SQLResponse sqlResponse = new SQLResponse();
    sqlResponse.setDuration(10);
    sqlResponse.setCube("test_cube");
    sqlResponse.setIsException(false);
    sqlResponse.setTotalScanCount(100);
    List<String> list1 = new ArrayList<>();
    list1.add("111");
    list1.add("112");
    List<String> list2 = new ArrayList<>();
    list2.add("111");
    list2.add("112");
    List<List<String>> results = new ArrayList<>();
    results.add(list1);
    results.add(list2);
    sqlResponse.setResults(results);
    sqlResponse.setStorageCacheUsed(true);
    Metrics metrics = MetricsFactory.getInstance();
    QueryMetrics2Facade.updateMetrics(sqlRequest, sqlResponse);
    String prefix = buildCubeMetricPrefix(sqlRequest.getProject(), sqlResponse.getCube().replace("=", "->"));
    Thread.sleep(2000);

    Assert.assertEquals(1L,
            metrics.getCounter(MetricsNameBuilder.buildMetricName(prefix, MetricsConstant.QUERY_COUNT)).getCount());
    Assert.assertEquals(1L,
            metrics.getCounter(MetricsNameBuilder.buildMetricName(prefix, MetricsConstant.QUERY_SUCCESS_COUNT))
                    .getCount());
    Assert.assertEquals(0L, metrics
            .getCounter(MetricsNameBuilder.buildMetricName(prefix, MetricsConstant.QUERY_FAIL_COUNT)).getCount());
    Assert.assertEquals(1L, metrics
            .getCounter(MetricsNameBuilder.buildMetricName(prefix, MetricsConstant.QUERY_CACHE_COUNT)).getCount());
    //
    Snapshot queryScanSnapshot = metrics
            .getHistogram(MetricsNameBuilder.buildMetricName(prefix, MetricsConstant.QUERY_SCAN_ROWCOUNT))
            .getSnapshot();
    Assert.assertEquals(100.0, queryScanSnapshot.getMean(), 0);
    Assert.assertEquals(100.0, queryScanSnapshot.getMax(), 0);
    Assert.assertEquals(100.0, queryScanSnapshot.getMin(), 0);

    Snapshot queryResultSnapshot = metrics
            .getHistogram(MetricsNameBuilder.buildMetricName(prefix, MetricsConstant.QUERY_RESULT_ROWCOUNT))
            .getSnapshot();

    Assert.assertEquals(2.0, queryResultSnapshot.getMean(), 0);
    Assert.assertEquals(2.0, queryResultSnapshot.getMax(), 0);
    Assert.assertEquals(2.0, queryResultSnapshot.getMin(), 0);

    Snapshot queryLatencySnapshot = metrics
            .getTimer(MetricsNameBuilder.buildMetricName(prefix, MetricsConstant.QUERY_DURATION)).getSnapshot();
    Assert.assertEquals(TimeUnit.MILLISECONDS.toNanos(10), queryLatencySnapshot.getMean(), 0);
    Assert.assertEquals(TimeUnit.MILLISECONDS.toNanos(10), queryLatencySnapshot.getMax(), 0);
    Assert.assertEquals(TimeUnit.MILLISECONDS.toNanos(10), queryLatencySnapshot.getMin(), 0);

    SQLResponse sqlResponse2 = new SQLResponse();
    sqlResponse2.setDuration(10);
    sqlResponse2.setCube("test_cube");
    sqlResponse2.setIsException(true);

    QueryMetrics2Facade.updateMetrics(sqlRequest, sqlResponse2);
    prefix = buildCubeMetricPrefix(sqlRequest.getProject(), sqlResponse.getCube().replace("=", "->"));
    Assert.assertEquals(2L,
            metrics.getCounter(MetricsNameBuilder.buildMetricName(prefix, MetricsConstant.QUERY_COUNT)).getCount());
    Assert.assertEquals(1L,
            metrics.getCounter(MetricsNameBuilder.buildMetricName(prefix, MetricsConstant.QUERY_SUCCESS_COUNT))
                    .getCount());
    Assert.assertEquals(1L, metrics
            .getCounter(MetricsNameBuilder.buildMetricName(prefix, MetricsConstant.QUERY_FAIL_COUNT)).getCount());
}
Example 4
Source File: QueryService.java    From kylin-on-parquet-v2 with Apache License 2.0 4 votes vote down vote up 
private SQLResponse buildSqlResponse(String projectName, Boolean isPushDown, List<List<String>> results,
        List<SelectedColumnMeta> columnMetas, boolean isException, String exceptionMessage) {

    boolean isPartialResult = false;

    List<String> realizations = Lists.newLinkedList();
    StringBuilder cubeSb = new StringBuilder();
    StringBuilder logSb = new StringBuilder("Processed rows for each storageContext: ");
    QueryContext queryContext = QueryContextFacade.current();
    if (OLAPContext.getThreadLocalContexts() != null) { // contexts can be null in case of 'explain plan for'
        for (OLAPContext ctx : OLAPContext.getThreadLocalContexts()) {
            String realizationName = "NULL";
            int realizationType = -1;
            if (ctx.realization != null) {
                isPartialResult |= ctx.storageContext.isPartialResultReturned();
                if (cubeSb.length() > 0) {
                    cubeSb.append(",");
                }
                cubeSb.append(ctx.realization.getCanonicalName());
                logSb.append(ctx.storageContext.getProcessedRowCount()).append(" ");

                realizationName = ctx.realization.getName();
                realizationType = ctx.realization.getStorageType();

                realizations.add(realizationName);
            }
            queryContext.setContextRealization(ctx.id, realizationName, realizationType);
        }
    }
    logger.info(logSb.toString());

    SQLResponse response = new SQLResponse(columnMetas, results, cubeSb.toString(), 0, isException,
            exceptionMessage, isPartialResult, isPushDown);
    response.setTotalScanCount(queryContext.getScannedRows());
    response.setTotalScanBytes(queryContext.getScannedBytes());
    response.setCubeSegmentStatisticsList(queryContext.getCubeSegmentStatisticsResultList());
    if (getConfig().isQueryCacheSignatureEnabled()) {
        response.setSignature(SQLResponseSignatureUtil.createSignature(getConfig(), response, projectName));
    }
    return response;
}
Example 5
Source File: QueryMetricsTest.java    From kylin with Apache License 2.0 4 votes vote down vote up 
@Test
public void testQueryMetrics() throws Exception {
    System.setProperty("kylin.server.query-metrics-enabled", "true");
    QueryMetricsFacade.init();

    SQLRequest sqlRequest = new SQLRequest();
    sqlRequest.setSql("select * from TEST_KYLIN_FACT");
    sqlRequest.setProject("default");

    SQLResponse sqlResponse = new SQLResponse();
    sqlResponse.setDuration(10);
    sqlResponse.setCube("test_cube");
    sqlResponse.setIsException(false);
    sqlResponse.setTotalScanCount(100);
    List<String> list1 = new ArrayList<>();
    list1.add("111");
    list1.add("112");
    List<String> list2 = new ArrayList<>();
    list2.add("111");
    list2.add("112");
    List<List<String>> results = new ArrayList<>();
    results.add(list1);
    results.add(list2);
    sqlResponse.setResults(results);
    sqlResponse.setStorageCacheUsed(true);

    QueryMetricsFacade.updateMetrics(sqlRequest, sqlResponse);

    Thread.sleep(2000);

    Assert.assertEquals(1L, mBeanServer.getAttribute(objectName, "QueryCount"));
    Assert.assertEquals(1L, mBeanServer.getAttribute(objectName, "QuerySuccessCount"));
    Assert.assertEquals(0L, mBeanServer.getAttribute(objectName, "QueryFailCount"));
    Assert.assertEquals(1L, mBeanServer.getAttribute(objectName, "CacheHitCount"));

    Assert.assertEquals(1L, mBeanServer.getAttribute(objectName, "ScanRowCountNumOps"));
    Assert.assertEquals(100.0, mBeanServer.getAttribute(objectName, "ScanRowCountAvgTime"));
    Assert.assertEquals(100.0, mBeanServer.getAttribute(objectName, "ScanRowCountMaxTime"));
    Assert.assertEquals(100.0, mBeanServer.getAttribute(objectName, "ScanRowCountMinTime"));

    Assert.assertEquals(1L, mBeanServer.getAttribute(objectName, "ResultRowCountNumOps"));
    Assert.assertEquals(2.0, mBeanServer.getAttribute(objectName, "ResultRowCountMaxTime"));
    Assert.assertEquals(2.0, mBeanServer.getAttribute(objectName, "ResultRowCountAvgTime"));
    Assert.assertEquals(2.0, mBeanServer.getAttribute(objectName, "ResultRowCountMinTime"));

    Assert.assertEquals(1L, mBeanServer.getAttribute(objectName, "QueryLatencyNumOps"));
    Assert.assertEquals(10.0, mBeanServer.getAttribute(objectName, "QueryLatencyMaxTime"));
    Assert.assertEquals(10.0, mBeanServer.getAttribute(objectName, "QueryLatencyAvgTime"));
    Assert.assertEquals(10.0, mBeanServer.getAttribute(objectName, "QueryLatencyMinTime"));

    SQLResponse sqlResponse2 = new SQLResponse();
    sqlResponse2.setDuration(10);
    sqlResponse2.setCube("test_cube");
    sqlResponse2.setIsException(true);

    QueryMetricsFacade.updateMetrics(sqlRequest, sqlResponse2);

    Thread.sleep(2000);

    Assert.assertEquals(2L, mBeanServer.getAttribute(objectName, "QueryCount"));
    Assert.assertEquals(1L, mBeanServer.getAttribute(objectName, "QuerySuccessCount"));
    Assert.assertEquals(1L, mBeanServer.getAttribute(objectName, "QueryFailCount"));

    System.clearProperty("kylin.server.query-metrics-enabled");
}
Example 6
Source File: QueryMetricsTest.java    From kylin with Apache License 2.0 4 votes vote down vote up 
@Test
public void testQueryStatisticsResult() throws Exception {
    System.setProperty("kylin.metrics.reporter-query-enabled", "true");
    QueryMetricsFacade.init();

    SQLRequest sqlRequest = new SQLRequest();
    sqlRequest.setSql("select * from TEST_KYLIN_FACT");
    sqlRequest.setProject("default");

    QueryContext context = QueryContextFacade.current();
    
    SQLResponse sqlResponse = new SQLResponse();
    sqlResponse.setDuration(10);
    sqlResponse.setCube("test_cube");
    sqlResponse.setIsException(false);
    sqlResponse.setTotalScanCount(100);
    List<String> list1 = new ArrayList<>();
    list1.add("111");
    list1.add("112");
    List<String> list2 = new ArrayList<>();
    list2.add("111");
    list2.add("112");
    List<List<String>> results = new ArrayList<>();
    results.add(list1);
    results.add(list2);
    sqlResponse.setResults(results);
    sqlResponse.setStorageCacheUsed(true);

    int ctxId = 0;
    context.addContext(ctxId, "OLAP", true);
    context.addRPCStatistics(ctxId, "sandbox", "test_cube", "20100101000000_20150101000000", 3L, 3L, 3L, null, 80L,
            0L, 2L, 2L, 0L, 30L);

    sqlResponse.setCubeSegmentStatisticsList(context.getCubeSegmentStatisticsResultList());

    QueryMetricsFacade.updateMetrics(sqlRequest, sqlResponse);

    Thread.sleep(2000);

    System.clearProperty("kylin.server.query-metrics-enabled");
    System.out.println("------------testQueryStatisticsResult done------------");
}
Example 7
Source File: QueryMetrics2Test.java    From kylin with Apache License 2.0 4 votes vote down vote up 
@Test
public void testQueryMetrics() throws Exception {
    System.setProperty("kylin.server.query-metrics2-enabled", "true");
    QueryMetrics2Facade.init();
    SQLRequest sqlRequest = new SQLRequest();
    sqlRequest.setSql("select * from TEST_KYLIN_FACT");
    sqlRequest.setProject("default");
    SQLResponse sqlResponse = new SQLResponse();
    sqlResponse.setDuration(10);
    sqlResponse.setCube("test_cube");
    sqlResponse.setIsException(false);
    sqlResponse.setTotalScanCount(100);
    List<String> list1 = new ArrayList<>();
    list1.add("111");
    list1.add("112");
    List<String> list2 = new ArrayList<>();
    list2.add("111");
    list2.add("112");
    List<List<String>> results = new ArrayList<>();
    results.add(list1);
    results.add(list2);
    sqlResponse.setResults(results);
    sqlResponse.setStorageCacheUsed(true);
    Metrics metrics = MetricsFactory.getInstance();
    QueryMetrics2Facade.updateMetrics(sqlRequest, sqlResponse);
    String prefix = buildCubeMetricPrefix(sqlRequest.getProject(), sqlResponse.getCube().replace("=", "->"));
    Thread.sleep(2000);

    Assert.assertEquals(1L,
            metrics.getCounter(MetricsNameBuilder.buildMetricName(prefix, MetricsConstant.QUERY_COUNT)).getCount());
    Assert.assertEquals(1L,
            metrics.getCounter(MetricsNameBuilder.buildMetricName(prefix, MetricsConstant.QUERY_SUCCESS_COUNT))
                    .getCount());
    Assert.assertEquals(0L, metrics
            .getCounter(MetricsNameBuilder.buildMetricName(prefix, MetricsConstant.QUERY_FAIL_COUNT)).getCount());
    Assert.assertEquals(1L, metrics
            .getCounter(MetricsNameBuilder.buildMetricName(prefix, MetricsConstant.QUERY_CACHE_COUNT)).getCount());
    //
    Snapshot queryScanSnapshot = metrics
            .getHistogram(MetricsNameBuilder.buildMetricName(prefix, MetricsConstant.QUERY_SCAN_ROWCOUNT))
            .getSnapshot();
    Assert.assertEquals(100.0, queryScanSnapshot.getMean(), 0);
    Assert.assertEquals(100.0, queryScanSnapshot.getMax(), 0);
    Assert.assertEquals(100.0, queryScanSnapshot.getMin(), 0);

    Snapshot queryResultSnapshot = metrics
            .getHistogram(MetricsNameBuilder.buildMetricName(prefix, MetricsConstant.QUERY_RESULT_ROWCOUNT))
            .getSnapshot();

    Assert.assertEquals(2.0, queryResultSnapshot.getMean(), 0);
    Assert.assertEquals(2.0, queryResultSnapshot.getMax(), 0);
    Assert.assertEquals(2.0, queryResultSnapshot.getMin(), 0);

    Snapshot queryLatencySnapshot = metrics
            .getTimer(MetricsNameBuilder.buildMetricName(prefix, MetricsConstant.QUERY_DURATION)).getSnapshot();
    Assert.assertEquals(TimeUnit.MILLISECONDS.toNanos(10), queryLatencySnapshot.getMean(), 0);
    Assert.assertEquals(TimeUnit.MILLISECONDS.toNanos(10), queryLatencySnapshot.getMax(), 0);
    Assert.assertEquals(TimeUnit.MILLISECONDS.toNanos(10), queryLatencySnapshot.getMin(), 0);

    SQLResponse sqlResponse2 = new SQLResponse();
    sqlResponse2.setDuration(10);
    sqlResponse2.setCube("test_cube");
    sqlResponse2.setIsException(true);

    QueryMetrics2Facade.updateMetrics(sqlRequest, sqlResponse2);
    prefix = buildCubeMetricPrefix(sqlRequest.getProject(), sqlResponse.getCube().replace("=", "->"));
    Assert.assertEquals(2L,
            metrics.getCounter(MetricsNameBuilder.buildMetricName(prefix, MetricsConstant.QUERY_COUNT)).getCount());
    Assert.assertEquals(1L,
            metrics.getCounter(MetricsNameBuilder.buildMetricName(prefix, MetricsConstant.QUERY_SUCCESS_COUNT))
                    .getCount());
    Assert.assertEquals(1L, metrics
            .getCounter(MetricsNameBuilder.buildMetricName(prefix, MetricsConstant.QUERY_FAIL_COUNT)).getCount());
}
Example 8
Source File: QueryService.java    From kylin with Apache License 2.0 4 votes vote down vote up 
private SQLResponse buildSqlResponse(String projectName, Boolean isPushDown, List<List<String>> results,
        List<SelectedColumnMeta> columnMetas, boolean isException, String exceptionMessage) {

    boolean isPartialResult = false;

    List<String> realizations = Lists.newLinkedList();
    StringBuilder cubeSb = new StringBuilder();
    StringBuilder logSb = new StringBuilder("Processed rows for each storageContext: ");
    QueryContext queryContext = QueryContextFacade.current();
    if (OLAPContext.getThreadLocalContexts() != null) { // contexts can be null in case of 'explain plan for'
        for (OLAPContext ctx : OLAPContext.getThreadLocalContexts()) {
            String realizationName = "NULL";
            int realizationType = -1;
            if (ctx.realization != null) {
                isPartialResult |= ctx.storageContext.isPartialResultReturned();
                if (cubeSb.length() > 0) {
                    cubeSb.append(",");
                }
                cubeSb.append(ctx.realization.getCanonicalName());
                logSb.append(ctx.storageContext.getProcessedRowCount()).append(" ");

                realizationName = ctx.realization.getName();
                realizationType = ctx.realization.getStorageType();

                realizations.add(realizationName);
            }
            queryContext.setContextRealization(ctx.id, realizationName, realizationType);
        }
    }
    logger.info(logSb.toString());

    SQLResponse response = new SQLResponse(columnMetas, results, cubeSb.toString(), 0, isException,
            exceptionMessage, isPartialResult, isPushDown);
    response.setTotalScanCount(queryContext.getScannedRows());
    response.setTotalScanBytes(queryContext.getScannedBytes());
    response.setCubeSegmentStatisticsList(queryContext.getCubeSegmentStatisticsResultList());
    if (getConfig().isQueryCacheSignatureEnabled()) {
        response.setSignature(SQLResponseSignatureUtil.createSignature(getConfig(), response, projectName));
    }
    return response;
}
Example 9
Source File: QueryService.java    From Kylin with Apache License 2.0 4 votes vote down vote up 
/**
 * @param sql
 * @param sqlRequest
 * @return
 * @throws Exception
 */
private SQLResponse execute(String sql, SQLRequest sqlRequest) throws Exception {
    Connection conn = null;
    Statement stat = null;
    ResultSet resultSet = null;
    List<List<String>> results = new LinkedList<List<String>>();
    List<SelectedColumnMeta> columnMetas = new LinkedList<SelectedColumnMeta>();

    try {
        conn = getOLAPDataSource(sqlRequest.getProject()).getConnection();

        if (sqlRequest instanceof PrepareSqlRequest) {
            PreparedStatement preparedState = conn.prepareStatement(sql);

            for (int i = 0; i < ((PrepareSqlRequest) sqlRequest).getParams().length; i++) {
                setParam(preparedState, i + 1, ((PrepareSqlRequest) sqlRequest).getParams()[i]);
            }

            resultSet = preparedState.executeQuery();
        } else {
            stat = conn.createStatement();
            resultSet = stat.executeQuery(sql);
        }

        ResultSetMetaData metaData = resultSet.getMetaData();
        int columnCount = metaData.getColumnCount();

        // Fill in selected column meta
        for (int i = 1; i <= columnCount; ++i) {
            columnMetas.add(new SelectedColumnMeta(metaData.isAutoIncrement(i), metaData.isCaseSensitive(i), metaData.isSearchable(i), metaData.isCurrency(i), metaData.isNullable(i), metaData.isSigned(i), metaData.getColumnDisplaySize(i), metaData.getColumnLabel(i), metaData.getColumnName(i), metaData.getSchemaName(i), metaData.getCatalogName(i), metaData.getTableName(i), metaData.getPrecision(i), metaData.getScale(i), metaData.getColumnType(i), metaData.getColumnTypeName(i), metaData.isReadOnly(i), metaData.isWritable(i), metaData.isDefinitelyWritable(i)));
        }

        List<String> oneRow = new LinkedList<String>();

        // fill in results
        while (resultSet.next()) {
            for (int i = 0; i < columnCount; i++) {
                oneRow.add((resultSet.getString(i + 1)));
            }

            results.add(new LinkedList<String>(oneRow));
            oneRow.clear();
        }
    } finally {
        close(resultSet, stat, conn);
    }

    boolean isPartialResult = false;
    String cube = "";
    long totalScanCount = 0;
    if (OLAPContext.getThreadLocalContexts() != null) { // contexts can be null in case of 'explain plan for'
        for (OLAPContext ctx : OLAPContext.getThreadLocalContexts()) {
            isPartialResult |= ctx.storageContext.isPartialResultReturned();
            cube = ctx.realization.getName();
            totalScanCount += ctx.storageContext.getTotalScanCount();
        }
    }

    SQLResponse response = new SQLResponse(columnMetas, results, cube, 0, false, null, isPartialResult);
    response.setTotalScanCount(totalScanCount);

    return response;
}