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 of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
