Hi!
Looks very promised - http://my.vertica.com/docs/7.2.x/HTML/C ... index.html
[deleted, I don't know what Admin don't like in my post, my English is poor ]
Search found 732 matches
- Wed Dec 23, 2015 8:46 pm
- Forum: Python
- Topic: HP Vertica 7.2.0 - Python Client(wheel)
- Replies: 1
- Views: 17063
- Tue Oct 06, 2015 1:17 pm
- Forum: Vertica Performance Tuning
- Topic: Presentation on Performance Tuning
- Replies: 8
- Views: 35700
Re: Presentation on Performance Tuning
Try this linkJimKnicely wrote:#id10t - Try attaching the document when you get a chance.
- Mon Oct 05, 2015 6:26 pm
- Forum: Vertica Performance Tuning
- Topic: Presentation on Performance Tuning
- Replies: 8
- Views: 35700
Re: Presentation on Performance Tuning
PerfTuningFiles.zip == 1947998 Bytes == 1.95 Mbytes
check mail.
- Tue Jul 28, 2015 9:05 am
- Forum: New to Vertica SQL
- Topic: Calculating difference between two timestamps
- Replies: 4
- Views: 21747
Re: Calculating difference between two timestamps
Hi! If I use >= also it is taking only date into consideration not the time. It should So if say test_date >='2015-07-24 12:00:00' i am getting all the data from that day instead of filtering from 12:00:00 on 2015-07-24. Probably implicit data type coercion. If LEFT SIDE(test_date) is from data type...
- Sun Jul 26, 2015 12:43 pm
- Forum: New to Vertica
- Topic: Why we need WOS instead of ROS
- Replies: 2
- Views: 7682
Re: Why we need WOS instead of ROS
Hi! Why we need to go through a process and why can't we pass it always direct pointing to ROS. Depends on your requirements. Data in WOS is a memory-resident data(ROS - on storage), the WOS stores records without data compression or indexing - it's done to support very fast data load speeds. So if ...
- Sun Jul 26, 2015 8:20 am
- Forum: Vertica SQL
- Topic: Counting Based on Date between Two Dates
- Replies: 5
- Views: 12846
Re: Counting Based on Date between Two Dates
Hi!
A better solution is - to push on Vertica developers to fix a bug, otherwise it's not a solution, it's a workaround.knicely87 wrote:Maybe a better solution would be to use a date dimension table?
- Sat Jul 25, 2015 5:07 pm
- Forum: Vertica SQL
- Topic: Counting Based on Date between Two Dates
- Replies: 5
- Views: 12846
Re: Counting Based on Date between Two Dates
Hi! I think the TIMESERIES clause, which provides gap-filling and interpolation (GFI) computation, will help you out. And use it on your own risk, because this functionality is buggy. https://community.dev.hp.com/t5/Vertica-Forum/TIMESERIES-quot-gap-filling-quot-works-not-properly/m-p/209577/highlig...