Search found 732 matches

by id10t
Wed Dec 23, 2015 8:46 pm
Forum: Python
Topic: HP Vertica 7.2.0 - Python Client(wheel)
Replies: 1
Views: 16815

HP Vertica 7.2.0 - Python Client(wheel)

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 :? ]
by id10t
Tue Oct 06, 2015 1:17 pm
Forum: Vertica Performance Tuning
Topic: Presentation on Performance Tuning
Replies: 8
Views: 35186

Re: Presentation on Performance Tuning

JimKnicely wrote:#id10t - Try attaching the document when you get a chance.
Try this link
by id10t
Mon Oct 05, 2015 6:26 pm
Forum: Vertica Performance Tuning
Topic: Presentation on Performance Tuning
Replies: 8
Views: 35186

Re: Presentation on Performance Tuning

Image

PerfTuningFiles.zip == 1947998 Bytes == 1.95 Mbytes

check mail.
by id10t
Tue Jul 28, 2015 9:05 am
Forum: New to Vertica SQL
Topic: Calculating difference between two timestamps
Replies: 4
Views: 21402

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...
by id10t
Sun Jul 26, 2015 12:43 pm
Forum: New to Vertica
Topic: Why we need WOS instead of ROS
Replies: 2
Views: 7227

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 ...
by id10t
Sun Jul 26, 2015 8:20 am
Forum: Vertica SQL
Topic: Counting Based on Date between Two Dates
Replies: 5
Views: 12711

Re: Counting Based on Date between Two Dates

Hi!
knicely87 wrote:Maybe a better solution would be to use a date dimension table?
A better solution is - to push on Vertica developers to fix a bug, otherwise it's not a solution, it's a workaround.
by id10t
Sat Jul 25, 2015 5:07 pm
Forum: Vertica SQL
Topic: Counting Based on Date between Two Dates
Replies: 5
Views: 12711

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...

Go to advanced search