No rows in PROJECTION_COLUMNS after ANALYZE_STATISTICS

Hi ,

 

Could some one help me solve the below problem  :

 

I ran

focus_owner=> SELECT ANALYZE_STATISTICS('focus.fixture_details.Fixture_Id' ) ;
 ANALYZE_STATISTICS
--------------------
                  0

 

focus_owner=> select * from PROJECTION_COLUMNS WHERE table_name ='focus.fixture_details' ;
(No rows)

 

 

Why even after collecting stats on a column for a table the PROJECTION_COLUMNS gives no rows .

 

Thanks in advance .

Priyabrat

Comments

  • SruthiASruthiA Vertica Employee Administrator

    Hi,

     

       Does a projection exist for the table fixture_details? Did you create one?

     

     

    -Regards,

     Sruthi

  • In the table you don't need to put the schema, there is a separated field for the schema

     

     

    focus_owner=> select * from PROJECTION_COLUMNS WHERE table_name ='focus.fixture_details'

     

    try like this

     

      select * from PROJECTION_COLUMNS WHERE anchor_table_name ilike '%fixture_details%'

     

    Hope this helps.

     

    Eugenia

  • Thanks , its working now .

Leave a Comment

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