Reputation
853
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
7 22
Newest
 Enlightened
Impact
~17k people reached

Apr
22
comment How to aggregate table in vertica for last few days, and save the result?
You may be able to use a view. Otherwise, to materialize the result set, consider writing a script which will output the result set to its own table.
Mar
21
comment Size, audit and rowcount of a table in Vertica
This doesn't answer your own question
Mar
10
comment Truncate a decimal field without rounding in VERTICA
What version of Vertica are you using?
Mar
7
comment Why would Vertica let me start a transaction if I can't roll it back?
I get it now. I agree you shouldn't be able to create a transaction if AUTOCOMMIT is enabled.
Mar
7
comment Why would Vertica let me start a transaction if I can't roll it back?
Bad implementation? If AUTO COMMIT was disabled, then you would need a COMMIT after any DDL.
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.
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
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.
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.)
Sep
30
comment Create a new column with sequential days based on start and end dates
@ypercube I support that link
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.
Apr
14
comment SQL Job to be run earlier on last work day of month
+1 for expedited response
Apr
14
comment SQL Job to be run earlier on last work day of month
@AaronBertrand Can you please expedite JCBWS's request?
Oct
3
comment How to query from a linked server via a linked server in sql server?
@kaptan Next time you go to the mechanic, and they ask what's wrong, don't give them any explanations.
Sep
17
comment Keeping rows ordered by counter value
@MaxVernon What's the point of storing relational data in a relational database system?
Sep
1
comment How to architect an analytical BI platform?
You can try browsing around vertica.com or third party vendors for white papers or use cases. If you choose Vertica, architecture could be part of the work. In regards to your earlier comment, I'm pretty sure Vertica has a much lower cost of ownership than other EDW. Feel free to reach out privately (send me a message at vertica.tips) and we can discuss further.