Issue with 'create table as select from'
I am trying to run the follwoing but get [Vertica][VJDBC](4856) ERROR: Syntax error at or near "AS" :-
create table reporting_staging.temp_compSMBmembers2
where year(date) = '2011' and month(date) = '09' ;
It looks like according to the docs it should work?