Pattern Match Issue (Unhandled expression type 316)

I am trying to use the Event Series Pattern Matching functionality within Vertica's Analytics tools. After defining at first as many as 9 events and a Pattern to match against the SQL threw an 'Unhandled expression type 316'. I have a great deal of trouble searching out error codes in the online documentation and found nothing, so I paired back down the command to 3 events and a shorter pattern to simplify in an attempt to get it functioning.

I need help with error code so I know how to fix the syntax. I am deriving the events via a subquery (which runs fine) that I get sorted the way I need and then after it runs it is Matched against.. and thats when the error occurs so I know its either in my Match syntax or possibly in the way the data is presented in the subquery but I don't have enough specifics to proceed.

Any help will be appreciated.


  • Options
    Can you provide a sample query  that caused this error.
    Also, a snippet from the vertica.logs when this happens would be useful.

    seems to be a case where vertica could not figure out what the type of the expression.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file