Question
Hi,I am trying to calculate the so called calendar week of a date-attribute in the course of a transformation. The function to be used is CALENDAR_WEEK; however, I get an error message: "Execution error: Function CALENDAR_WEEK is not supported".
Hi,
I am trying to calculate the so called calendar week of a date-attribute in the course of a transformation. The function to be used is CALENDAR_WEEK; however, I get an error message: "Execution error: Function CALENDAR_WEEK is not supported". Why?
+4Are you using CALENDAR_WEEK in the Data Jobs/ Data Transformations ?
You can try DAYOFWEEK ( date ) which is a vertica sql function, I am asuming that you are mixing the PQL with Vertica SQL and hence the above error.
Hope this helps!
Hi Abhishek, yes it does! Thank you!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.