3 Replies Latest reply on Aug 29, 2016 2:32 AM by siyang.teo

    Error with raw sql: percentile_cont function

    siyang.teo

      Hi, I tried to use a raw sql function to pass to my database in Vertica, but it kept prompting an error.

       

      The statement is:

      RAWSQLAGG_REAL("PERCENTILE_CONT (0.20) WITHIN GROUP (ORDER BY %1 ASC)", [SPEED])

       

      And the error message is given below, which refers to the ending bracket of the above statement.

      Does anyone know what's wrong?

       

      2.JPG