We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


how to obtain data from hp vertica tables and from vertica projections? — Vertica Forum

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