Untitled

 avatar
user_1382934795
plain_text
2 years ago
1.7 kB
0
Indexable
Never
SELECT SUM("New_View"."AMOUNT_SOLD") AS "sum:AMOUNT_SOLD:ok",
SUM("New_View"."COST_OF_GOODS") AS "sum:COST_OF_GOODS:ok",
CORR("New_View"."AMOUNT_SOLD", "New_View"."COST_OF_GOODS") AS "usr:Calculation_140456073647910928:ok",
COVAR_SAMP("New_View"."COST_OF_GOODS", "New_View"."AMOUNT_SOLD") AS "usr:Calculation_140456073654411282:ok",
COVAR_POP("New_View"."AMOUNT_SOLD", "New_View"."COST_OF_GOODS") AS "usr:Calculation_140456073655603219:ok",
CAST(TRUNC(EXTRACT(YEAR FROM "New_View"."TIME_ID")) AS INTEGER) AS "yr:TIME_ID:ok"
FROM "Sales_BSCH"."New_View" "New_View"
GROUP BY 6

failed to calculate result:  [com.incorta.sqlinterface.net.traffic.command.ExecuteCommand.executeQuery]
java.lang.UnsupportedOperationException: Unsupported feature: ["New_View"."AMOUNT_SOLD", "New_View"."COST_OF_GOODS"] must appear in GROUP BY
at com.incorta.sqlinterface.executor.engine.NessyQueryExecutor.handleUnsupportedQuery(NessyQueryExecutor.java:136)
at com.incorta.sqlinterface.executor.engine.NessyQueryExecutor.getData(NessyQueryExecutor.java:72)
at com.incorta.sqlinterface.executor.engine.EngineQueryExecutor.getData(EngineQueryExecutor.java:46)
at com.incorta.sqlinterface.net.traffic.command.AbstractQueryCommand.getResult(AbstractQueryCommand.java:345)
at com.incorta.sqlinterface.net.traffic.command.AbstractQueryCommand.executeQuery(AbstractQueryCommand.java:155)
at com.incorta.sqlinterface.net.traffic.command.ExecuteCommand.process(ExecuteCommand.java:103)
at com.incorta.sqlinterface.net.traffic.command.PG_COMMAND.execute(PG_COMMAND.java:42)
at com.incorta.sqlinterface.net.traffic.TrafficCop.processLoop(TrafficCop.java:225)
at com.incorta.sqlinterface.net.traffic.TrafficCop.run(TrafficCop.java:143)