Basic details about vertica

Moderator: NorbertKrupa

Post Reply
Amit
Newbie
Newbie
Posts: 4
Joined: Tue Jul 07, 2015 1:04 pm

Basic details about vertica

Post by Amit » Fri Jul 10, 2015 9:43 pm

Hi,

I am new to vertica.Can anyone help me out for below queries.

i. when i do profile <query> it give me the complete output of the query.Is there is setting to see an the transaction and statement details which are required rather then the o/p. i don't want to see the o/p.

ii. in VSQL, for a select query only small portion of data is displayed, need to press enter or space bar to see rest of results.how can we increase the no of rows to be displayed.

iii. in VSql, we use /d <table>,/dt <table> to see the table structure. I have connected vertica using 3rd party tool- SqL workbench. In SqL workbench how can we see the table structure.

Post Reply

Return to “New to Vertica”