Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Issue with 'create table as select from'

Hi,

 

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
("col1" integer, 
col2 varchar(20)
)
AS
select col1,col2
from table
where year(date) = '2011' and month(date) = '09' ;

 

It looks like according to the docs it should work?

 

Any ideas?

 

Thanks,

Comments

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.