Search found 2 matches

by bwu@apptio.com
Thu Feb 20, 2014 8:44 am
Forum: Vertica SQL
Topic: how to implement group by grouping sets
Replies: 3
Views: 9198

Re: how to implement group by grouping sets

Not that I know of - but if you had to implement something like that and you are concerned with multiple table scans, one way to mitigate that is to do a group by on "a,b" first, put the result in a tmp table then the subsequent scans can be performed on that tmp table directly. If the cardinality g...
by bwu@apptio.com
Thu Feb 20, 2014 8:30 am
Forum: Vertica Database Development
Topic: Errors while running DBD
Replies: 4
Views: 24154

Re: Errors while running DBD

I think @sKwa is referring to the limits.conf at OS layer. If you are using Linux, search Google using keywords "Linux limits.conf" you should be able to find examples of how to increase the resource you needed to finish DBD. For example: http://linux.die.net/man/5/limits.conf However, Vertica insta...

Go to advanced search