Search found 2 matches
- Thu Feb 20, 2014 8:44 am
- Forum: Vertica SQL
- Topic: how to implement group by grouping sets
- Replies: 3
- Views: 9261
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...
- Thu Feb 20, 2014 8:30 am
- Forum: Vertica Database Development
- Topic: Errors while running DBD
- Replies: 4
- Views: 25076
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...