[jira] [Commented] (TRAFODION-27) Time consuming compilation for queries of BLOB with JOINs

["Anoop Sharma (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/TRAFODION-27?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14621692#comment-14621692 ] 

Anoop Sharma commented on TRAFODION-27:
---------------------------------------

One minor clarification. 

For this release, we have not externalized full BLOB support.
The syntax BLOB is internally converted to VARCHAR(100000).
So the issue being discussed in this JIRA will show up for any large
varchar column that is part of a nested/probe_cache join and
not just for a BLOB column.



> 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)