how to obtain data from hp vertica tables and from vertica projections?

Vertica's SELECT statements are pretty standard SQL. It would be helpful to know the errors with your SELECT statements. I'm also not sure why you are starting your query with a leading backslash \ ?

Is there a specific reason you want to select data from a projection, rather than the underlying table and letting Vertica deal with it?

Hi ,

Your table (f its being created ) existing on some schema , to access the table , you need to specified the schema name as prefix to your query 

Like select * from <Your Schema Name>.<table_name>

No avoid providing the schema as a prefix you can set you session search_path to reflect your schema name .

To see what is your existing search_path setting  run the below command 

SHOW SEARCH_PATH; 

try to select data dictionary 

select * from v_catalog.projections - to observe all created projections

select * from v_catalog.tables - for tables