Haifeng Li created TRAFODION-27:
-----------------------------------
Summary: 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
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)
