QSM-01061: illegal query expression

QSM-01061: illegal query expression
Cause: An illegal query was specified. Specifically one of the following criteria was not satisfied: (a) All (non-constant, non-aggregate) SELECT expressions in the query should be made up of group expressions. (b) All column references in the HAVING clause should come from the GROUP BY expressions. (c) If there is an ORDER BY clause, then all column references should come from the GROUP BY or SELECT clause, depending on whether the query selects DISTINCT.
Action: Correct error in the syntax and rerun the query.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

QSM-01061：非法查询表达式,
.原因：指定了非法查询。具体以下条件之一不满足：（a）查询中的所有（非常量，非聚合）SELECT表达式应由组表达式组成。（b）HAVING子句中的所有列引用都来自GROUP BY表达式。（c）如果有ORDER BY子句，则所有列引用应来自GROUP BY或SELECT子句，具体取决于查询是否选择DISTINCT。,
.操作：纠正语法错误并重新运行查询。,
.

aiaiDBA

13718043309

010-86462881

QSM-01061: illegal query expression

1 个回答

相似问题