Vertica_Curtis
Employee
Vertica_Curtis Employee
Reactions
-
Re: Has anyone benchmarked/compared loading using AVRO (versus NATIVE )
This is an odd comparison. Loading a NATIVE filetype is a complex endeavor, and would result in a very fast load, though the amount of work required to get it into that format might be cumbersome. I'… (View Post)1 -
Re: Can I put a limit on number of projections per table
Sounds like more of a process problem than a technical one. :) In general, I would suggest that having multiple projections isn't really an issue, especially if the table is small. Lots of projection… (View Post)1 -
Re: Can I put a limit on number of projections per table
There's nothing configurable that would control how many projections get created. Are you finding yourself in a position where people are creating a lot of projections? Can you elaborate a little on … (View Post)1 -
Re: pivot or get dummies ?
What is TF_NAME? And it's also not clear to me what you would need a MIN() around a DECODE()? Try removing the MIN(). Can you share a snippet of the actual table data, and an example output of what y… (View Post)1 -
Re: ANALYZE_STATISTICS_PARTITION
I'm not sure Vertica cares which command you run. It's going to identify applicable partitions, and run stats on those partitions. So, I suspect they are functionally equivalent. I'm not sure what yo… (View Post)1