Im wondering if you found out a workaround for this issue. I use SELECT INTO a lot and its quite useful with the WITH Clause.
As say before by other members , seems like WITH syntax it’s not supported syntax for SELECT INTO .
However , WITH is a very good syntax with regard to performances if it can materialized its content , Vertica by default do not materialized WITH part .
Simple workaround can be , by simply write your query using inline view as below :
(SELECT * FROM users) as aa ;
I hope this is answering the question