(3586) ERROR: Insufficient projections to answer query

I have created a projection and its buddy for a table. But they are showing as [UptoDate: No] [Stats: No] . I did the start_refresh() . Is there anything I am missing ??


  • Options
     On how many nodes you ran this ? 
    Steps in solving 3586 error:
    1- verify that all the columns in your query are present on a valid projection 
    2- make sure your k-safety is not 0 
    select designed_fault_tolerance from system; 
    Run this to recrete your table in a ksafe 1 mode
    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
  • Options
    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>';

  • Options
    Hi Guys,

    I was able to load the data finally. Instead of giving paramters in the select refresh(), i gave the empty command and it picked the projections and refreshed. Some how the parameters were not working. 

    Thanks a lot for your replies !!!!!
  • Options
    You're welcome, Kannan!

Leave a Comment

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