Search found 4 matches
- Fri Jul 10, 2015 9:43 pm
- Forum: New to Vertica
- Topic: Basic details about vertica
- Replies: 0
- Views: 4951
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...
- 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: 28043
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...
- 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: 28043
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
- 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: 28043
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
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