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.
DISTINCTconsiders 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!