[teiid-issues] [JBoss JIRA] Created: (TEIID-936) Query never returns from processing

[Paul Nittel (JIRA)]

Query never returns from processing
-----------------------------------

                 Key: TEIID-936
                 URL: https://jira.jboss.org/jira/browse/TEIID-936
             Project: Teiid
          Issue Type: Bug
          Components: Query Engine
    Affects Versions: 7.0
         Environment: fedora 12, Teiid build 1/19/2010, OpenJDK Server VM (build 14.0-b16, mixed mode)
            Reporter: Paul Nittel
            Assignee: Steven Hawkins


I'm executing TPCR Query #16. It processes correctly, and very quickly, in Designer, which is using an older Teiid query engine. The current Teiid, running via AdminShell, never returns from this query. Both are using the same VDB.

Two tables are involved PART (200,000 rows) and PARTSUPP (800,000 rows). The output will contain 18,314 rows.

The transformation query is:
SELECT 
		P_BRAND, P_TYPE, P_SIZE, COUNT(DISTINCT PS_SUPPKEY) AS supplier_cnt 
FROM 
		TPCR.PARTSUPP, TPCR.PART 
WHERE 
		(P_PARTKEY = PS_PARTKEY) AND (P_BRAND <> 'Brand#45') AND (P_TYPE NOT LIKE 'MEDIUM POLISHED%') AND (P_SIZE IN (49, 14, 23, 45, 19, 3, 36, 9)) AND (PS_SUPPKEY NOT IN (SELECT S_SUPPKEY FROM TPCR.SUPPLIER WHERE S_COMMENT LIKE '%Customer%Complaints%')) 
GROUP BY P_BRAND, P_TYPE, P_SIZE

The query being executed is: select * from vTpcr.Q16 ORDER BY supplier_cnt desc, p_brand, p_type, p_size

I have tried to execute shorter version of the transformation query in AdminShell to no avail. This query: SELECT P_BRAND, P_TYPE, P_SIZE FROM TPCR.PARTSUPP, TPCR.PART WHERE (P_PARTKEY = PS_PARTKEY) AND (P_BRAND <> 'Brand#45') AND (P_TYPE NOT LIKE 'MEDIUM POLISHED%'); did not return in a reasonable time. 

Teiid seems to use a fair percentage of the CPU for a while, then usage drops to ~0.1%

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira