[
https://issues.apache.org/jira/browse/TRAFODION-27?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14624919#comment-14624919
]
ASF GitHub Bot commented on TRAFODION-27:
-----------------------------------------
Github user zellerh commented on a diff in the pull request:
https://github.com/apache/incubator-trafodion/pull/25#discussion_r34482736
--- Diff: core/sql/generator/GenProbeCache.cpp ---
@@ -361,6 +361,38 @@ short ProbeCache::codeGen(Generator *generator)
// that there is room enough for one row.
}
+ double memoryLimitPerCpu =
+
ActiveSchemaDB()->getDefaults().getAsLong(EXE_MEMORY_FOR_PROBE_CACHE_IN_MB) *
1024 * 1024;
+ double estimatedMemory;
+
+ if (numInnerTuples_ > 0) {
+ estimatedMemory = numInnerTuples_ * innerRecLength;
+ if (estimatedMemory > memoryLimitPerCpu) {
+ numInnerTuples_ = memoryLimitPerCpu / innerRecLength;
--- End diff --
Should we make sure that numInnerTuples_ is at least 1?
> Time consuming compilation for queries of BLOB with JOINs
> ----------------------------------------------------------
>
> Key: TRAFODION-27
> URL: https://issues.apache.org/jira/browse/TRAFODION-27
> Project: Apache Trafodion
> Issue Type: Bug
> Environment: Trafodion 1.2, HDP 2.2, CentOS 6
> Reporter: Haifeng Li
> Priority: Minor
> Attachments: trafodion27_qry.sql, trafodion27_setup.sql
>
>
> It takes 3 ~ 5 seconds to compile a query that returns a BLOB field by
> joining two tables. If a query is cached and subsequent queries are 'similar'
> to
> the initial query, those subsequence compilation times will usually be
> much faster. However, sometimes we observe that subsequent queries with
> literal difference still take long time in sqlci.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
