Search found 4 matches

by Amit
Fri Jul 10, 2015 9:43 pm
Forum: New to Vertica
Topic: Basic details about vertica
Replies: 0
Views: 4955

Basic details about vertica

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 selec...
by Amit
Wed Jul 08, 2015 8:54 am
Forum: Vertica Performance Tuning
Topic: How to know if my partition is getting hit in vertica
Replies: 4
Views: 28058

Re: How to know if my partition is getting hit in vertica

Hi, below is the table structure. CREATE TABLE test.AMIT ( Store_Cd char(5), Tm_Frame_Cd char(5), Hour_Nr int, Rptg_Dt date NOT NULL, Company_Cd char(5), Store_Hour_Ind char(1), Product_Desc varchar(100), Product_Sub_Desc varchar(100), CY_Bookings_Dollar numeric(18,2), CY_Bookings_Local numeric(18,2...
by Amit
Tue Jul 07, 2015 2:43 pm
Forum: Vertica Performance Tuning
Topic: How to know if my partition is getting hit in vertica
Replies: 4
Views: 28058

Re: How to know if my partition is getting hit in vertica

small correction :- i cud not see any information regarding it in explain/profile
by Amit
Tue Jul 07, 2015 2:42 pm
Forum: Vertica Performance Tuning
Topic: How to know if my partition is getting hit in vertica
Replies: 4
Views: 28058

How to know if my partition is getting hit in vertica

Hi ALL,

I have created a table with partition date field.Total 21 number of partition will be created.
However i am not able to figure out if the partition is actually getting hit.
I cud see any information in explain/profile.

Please let me know how to identify it

Go to advanced search