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

I've connected to hp vertica database 7.1.2 and I want to obtain test data of tables created previously in my hp vertica database

I've installed vsql client and I've connected correctly to hp vertica database with vsql client.

Now I want to obtain data from vertica tables and from vertica projections.

I've executed some SELECT commands and these have fail.

 

vsql> \ select * from <table_name>

 

How could I obtain data from hp vertica projections and from vertica tables?

Which commands have I use to obtain data from vertica projections?

Could anyone indicate some example command to obtain data from tables and projections?

 

Thans in advance

Best regards

Comments

  • 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

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.