[
https://issues.apache.org/jira/browse/IGNITE-682?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14481044#comment-14481044
]
Dmitriy Setrakyan commented on IGNITE-682:
------------------------------------------
{code}
Exception in thread "main" javax.cache.CacheException: class
org.apache.ignite.IgniteException: Syntax error in SQL statement "SELECT
_VAL __C0,
COUNT(_VAL) __C1
FROM ""words"".STRING
GROUP BY __C0
ORDER BY =COUNT(_VAL) AS[*] CNT DESC LIMIT 10" [42000-175]
at
org.apache.ignite.internal.processors.cache.IgniteCacheProxy.query(IgniteCacheProxy.java:457)
at
org.apache.ignite.examples.java8.streaming.wordcount.QueryWords.main(QueryWords.java:60)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:483)
at com.intellij.rt.execution.application.AppMain.main(AppMain.java:140)
Caused by: class org.apache.ignite.IgniteException: Syntax error in SQL
statement "SELECT
_VAL __C0,
COUNT(_VAL) __C1
FROM ""words"".STRING
GROUP BY __C0
ORDER BY =COUNT(_VAL) AS[*] CNT DESC LIMIT 10" [42000-175]
at
org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.query(GridReduceQueryExecutor.java:276)
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.queryTwoStep(IgniteH2Indexing.java:714)
at
org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.queryTwoStep(IgniteH2Indexing.java:805)
at
org.apache.ignite.internal.processors.query.GridQueryProcessor.queryTwoStep(GridQueryProcessor.java:515)
at
org.apache.ignite.internal.processors.cache.IgniteCacheProxy.query(IgniteCacheProxy.java:448)
... 6 more
Caused by: class org.apache.ignite.IgniteCheckedException: Syntax error in SQL
statement "SELECT
_VAL __C0,
COUNT(_VAL) __C1
FROM ""words"".STRING
GROUP BY __C0
ORDER BY =COUNT(_VAL) AS[*] CNT DESC LIMIT 10" [42000-175]
at
org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.createFunctionTable(GridReduceQueryExecutor.java:491)
at
org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.query(GridReduceQueryExecutor.java:273)
... 10 more
Caused by: org.h2.message.DbException: Syntax error in SQL statement "SELECT
_VAL __C0,
COUNT(_VAL) __C1
FROM ""words"".STRING
GROUP BY __C0
ORDER BY =COUNT(_VAL) AS[*] CNT DESC LIMIT 10" [42000-175]
at org.h2.message.DbException.get(DbException.java:172)
at org.h2.message.DbException.get(DbException.java:149)
at org.h2.message.DbException.getSyntaxError(DbException.java:184)
at org.h2.command.Parser.getSyntaxError(Parser.java:508)
at org.h2.command.Parser.prepare(Parser.java:222)
at org.h2.engine.Session.prepare(Session.java:403)
at
org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.createFunctionTable(GridReduceQueryExecutor.java:484)
... 11 more
Caused by: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SELECT
_VAL __C0,
COUNT(_VAL) __C1
FROM ""words"".STRING
GROUP BY __C0
ORDER BY =COUNT(_VAL) AS[*] CNT DESC LIMIT 10" [42000-175]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:332)
... 18 more
{code}
> Field aliases are not supported in Ignite SQL
> ---------------------------------------------
>
> Key: IGNITE-682
> URL: https://issues.apache.org/jira/browse/IGNITE-682
> Project: Ignite
> Issue Type: Improvement
> Components: SQL
> Reporter: Dmitriy Setrakyan
> Assignee: Sergi Vladykin
> Priority: Blocker
> Fix For: sprint-3
>
>
> Attached is the coding example to reproduce (requires java8)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
