In this post, we will see how to resolve Get an error when using DISTINCT in SELECT Statement
Question:
I have this query:ParseException: Syntax error in line 605:undefined: DISTINCT fact.order_id AS ORDER_ID ^ Encountered: DISTINCT Expected: CASE, CAST, DEFAULT, EXISTS, FALSE, IF, INTERVAL, LEFT, NOT, NULL, REPLACE, RIGHT, TRUNCATE, TRUE, IDENTIFIER CAUSED BY: Exception: Syntax error
I need the ORDER_ID only once, although it can exist multiple times in the table FACT, because I need to count it afterwards.
Thanks for the help.
Best Answer:
DISTINCT
considers all the columns in the SELECT statement, not just the specified column; and so the error. So, to filter DISTINCT order_id
; you can use group by ORDER_ID
:If you have better answer, please add a comment about this, thank you!
Source: Stackoverflow.com