Untitled
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)