ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From minisoft_rm <minisoft...@hotmail.com>
Subject ignite not support expression: EXISTS?
Date Mon, 28 Mar 2016 15:20:02 GMT
dear experts, I knew ignite supports ANSI 99 SQL. but seemed not support
expression: EXISTS... really?
Our company sw uses this keyword lots of times.

My testing sql is:"
select * from products as a where  exists(select * from productslp as b
where a.pk=b.itempk and a.pcode='100124');
"
and ignite throw exception like below:

Caused by: class org.apache.ignite.IgniteException: Unsupported expression:
EXISTS(
    SELECT
        B._KEY,
        B._VAL,
        B.ITEMPK,
        B.ITEMTYPEPK,
        B.LANGPK,
        B.PNAME,
        B.PDESCRIPTION,
        B.PMANUFACTURERTYPEDESCRIPTION,
        B.PSEGMENT,
        B.PARTICLESTATUS,
        B.PSUMMARY,
        B.PSTYLE,
        B.PSIZE,
        B.PCOLOR
    FROM "b2c_accCache".PRODUCTSLP B
        /* "b2c_accCache"."PRIMARY": ITEMPK = A.PK */
    WHERE (A.PCODE = '100124')
        AND (A.PK = B.ITEMPK)) [type=ConditionExists]
	at
org.apache.ignite.internal.processors.query.GridQueryProcessor.queryTwoStep(GridQueryProcessor.java:806)
	at
org.apache.ignite.internal.processors.cache.IgniteCacheProxy.query(IgniteCacheProxy.java:647)
	... 1 more
Caused by: class org.apache.ignite.IgniteCheckedException: Unsupported
expression: EXISTS(
    SELECT
        B._KEY,
        B._VAL,
        B.ITEMPK,
        B.ITEMTYPEPK,
        B.LANGPK,
        B.PNAME,
        B.PDESCRIPTION,
        B.PMANUFACTURERTYPEDESCRIPTION,
        B.PSEGMENT,
        B.PARTICLESTATUS,
        B.PSUMMARY,
        B.PSTYLE,
        B.PSIZE,
        B.PCOLOR
    FROM "b2c_accCache".PRODUCTSLP B
        /* "b2c_accCache"."PRIMARY": ITEMPK = A.PK */
    WHERE (A.PCODE = '100124')
        AND (A.PK = B.ITEMPK)) [type=ConditionExists]
	at
org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:1782)
	at
org.apache.ignite.internal.processors.query.GridQueryProcessor.queryTwoStep(GridQueryProcessor.java:799)
	... 2 more
Caused by: class org.apache.ignite.IgniteException: Unsupported expression:
EXISTS(
    SELECT
        B._KEY,
        B._VAL,
        B.ITEMPK,
        B.ITEMTYPEPK,
        B.LANGPK,
        B.PNAME,
        B.PDESCRIPTION,
        B.PMANUFACTURERTYPEDESCRIPTION,
        B.PSEGMENT,
        B.PARTICLESTATUS,
        B.PSUMMARY,
        B.PSTYLE,
        B.PSIZE,
        B.PCOLOR
    FROM "b2c_accCache".PRODUCTSLP B
        /* "b2c_accCache"."PRIMARY": ITEMPK = A.PK */
    WHERE (A.PCODE = '100124')
        AND (A.PK = B.ITEMPK)) [type=ConditionExists]
	at
org.apache.ignite.internal.processors.query.h2.sql.GridSqlQueryParser.parseExpression0(GridSqlQueryParser.java:648)
	at
org.apache.ignite.internal.processors.query.h2.sql.GridSqlQueryParser.parseExpression(GridSqlQueryParser.java:421)
	at
org.apache.ignite.internal.processors.query.h2.sql.GridSqlQueryParser.parse(GridSqlQueryParser.java:301)
	at
org.apache.ignite.internal.processors.query.h2.sql.GridSqlQueryParser.parse(GridSqlQueryParser.java:372)
	at
org.apache.ignite.internal.processors.query.h2.sql.GridSqlQueryParser.parse(GridSqlQueryParser.java:244)
	at
org.apache.ignite.internal.processors.query.h2.sql.GridSqlQuerySplitter.split(GridSqlQuerySplitter.java:153)
	at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.queryTwoStep(IgniteH2Indexing.java:1055)
	at
org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:801)
	at
org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:799)
	at
org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36)
	at
org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:1764)
	... 3 more



--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/ignite-not-support-expression-EXISTS-tp3711.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.

Mime
View raw message