No rows in PROJECTION_COLUMNS after ANALYZE_STATISTICS

priya1cvr

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

SruthiA

Hi,

 

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

 

 

-Regards,

 Sruthi

[Deleted User]

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

priya1cvr

Thanks , its working now .