(3586) ERROR: Insufficient projections to answer query

select designed_fault_tolerance from system; 

create table tbl2 as select * from initial_table ksafe 1;  I also say that you need to run DBD tool, this will solve you error

Hello Kannan,

If you run the following command, does the Statistics Types report NONE?

SELECT * FROM PROJECTION_COLUMNS WHERE table_name = '<table name>';

If so, run statistics on the <whichever> column:   

=> SELECT ANALYZE_STATISTICS('trades.<column>');

Once complete, re-run the query on the projection column and it should report as FULL:

SELECT * FROM PROJECTION_COLUMNS WHERE table_name = '<table name>';

Thanks,
Rory