Reputation
839
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
6 21
Impact
~15k people reached

2d
awarded  Popular Question
Jan
22
comment Vertica performance on select from view with union
Well, Vertica doesn't have indexes. The only sensible approach is for us to see the actual (anonymized) query.
Jan
14
answered Is Vertica's COPY atomic?
Nov
21
comment Set Default Maximum Rows for Export
@Audrey In the implementations I've seen, compliance was usually fine with being able to audit the requests table. An audit could have just been checking if there was any query run without a LIMIT, for example.
Nov
20
comment Set Default Maximum Rows for Export
Is this an audit/compliance issue?
Nov
20
comment Set Default Maximum Rows for Export
Your use case doesn't make much sense to me. Vertica will still have to do the same processing to run the query. Your LIMIT will come at the end.
Nov
20
answered Set Default Maximum Rows for Export
Nov
17
comment Vertica INSERT speed highly depends on server load
@woot I wouldn't use COPY for a single row. We'll have to agree to disagree.
Nov
14
answered Vertica INSERT speed highly depends on server load
Oct
13
comment Vertica 6.1: vsql creashes with large resultset
Look at queuetimeout in resource_pools.
Oct
13
comment Vertica 6.1: vsql creashes with large resultset
You're still not giving any information on the environment. Is there a connection timeout on the pool?
Oct
12
comment Vertica 6.1: vsql creashes with large resultset
It would be helpful to know your environment (nodes, specs, network, etc.)
Oct
11
answered Vertica 6.1: vsql creashes with large resultset
Sep
30
comment Create a new column with sequential days based on start and end dates
@ypercube I support that link
Sep
24
awarded  Nice Answer
Aug
10
awarded  Yearling
Aug
3
awarded  Caucus
Aug
3
awarded  Constituent
Jul
22
comment Why does the Tuple Mover in C-Store consider only rows older than LWM?
@JayDee The first part of the epoch values being used for movement is correct. The second part can also be true.
Jul
21
answered Why does the Tuple Mover in C-Store consider only rows older than LWM?