Receiving a "Failed to project" error running a query in MetaMatrix
Issue
- The following query gives a "Failed to project" error. I'm sure I'm doing something wrong but I can't figure out what it is:
-
SELECT COUNT(*), SUM(claim_amount), customer_id, YEAR(adjudication_date)AS adjudication_year, MONTH(adjudication_date) AS adjudication_month FROM Common.Audited_Claim WHERE error_type IS NULL GROUP BY customer_id, YEAR(adjudication_date), MONTH(adjudication_date)
-
- Receive "Failed to project" error when executing virtual procedure, but running the same SELECT statement outside of the procedure succeeds
- Executing SELECT statement with function in GROUP BY results in "Failed attempting to project" error:
Failed attempting to project <column> from {...}
Environment
-
MetaMatrix Enterprise Server 5.5.2
-
MetaMatrix Enterprise Server 5.5.3
- SQL statement includes function in GROUP BY
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.
