Wow, fast response! Thanks! Hmm. Which method do you think is best?

And yes, I was the biggest fan of GH. I guess my data elements gave me away

This was my favorite episode(s):

https://www.youtube.com/watch?v=HhHu-sJzMdg

Hello, I have a quick question. What is the best way to handle the situation where there may be NULL values in the list of values used in a NOT IN statement? Here is an example: dbadmin=> select * from names; name ------- Laura (2 rows) dbadmin=> select name from names where 'Luke' not in (select na...

Oh my. Thanks, Jim. I feel stupid I forgot that step...

Hi guys! I am trying to set up the VMart sample database provided by Vertica. I am using Vertica 7.1.1. I know I did this okay back with 6.1.x. So I created the DB and the schema. Then I ran the vmart_gen program: [dbadmin@vertica01 VMart_Schema]$ ./vmart_gen Using default parameters datadirectory =...

Hi, Can someone help me with the following command? I thought I'd be able to get the current value for a database parameter like this: [dbadmin@vertica11 ~]$ admintools -t database_parameters -d test_db -P ActivePartitionCount ERROR 3457: Function ActivePartitionCount(unknown, unknown) does not exis...

Hi all,

Is there an easy way to estimate the size of a catalog? I am looking for how much disk and memory is in use.

Thanks is advance.

Hi,

Can I disable a projection so that it can not be used? I don't want to drop it, just make sure it is not used by a query. I would prefer that another projection set be used during testing.

Thank you