Hi man, Great question. I believe that projection data is stored in one file per node unless the projection's anchor table was created using the PARTITION clause... in that case, there will be one file for each partition. When you create a table with the PARTITION clause then all projections based o...

Navin: I like the way you used the LIMIT command! I didn't think of that! I'm an old Oracle guy and we didn't have the LIMIT command so we had to use the WHERE 1=2 trick, but I like your way better! Examples: dbadmin=> create table test1 (col1 int, col2 varchar(100)); CREATE TABLE dbadmin=> insert i...

Hi,

As the site grows and the member list increases I'll definitely be looking for some folks to help out! Thanks for the interest!

Jim

You are welcome! I hope the answer made sense!

If you don't mind me asking, how are you using the TIME_SLICE function? Someone else asked me what the applicable use for this function is in the real world.

Hi, Vertica has provided several built in time stamp key words for our convenience: Examples: dbadmin=> select timestamp 'today' midnight_today, dbadmin-> timestamp 'yesterday' midnight_yesterday, dbadmin-> timestamp 'tomorrow' midnight_tomorrow, dbadmin-> time 'allballs' midnight_utc_time; midnight...

Thanks for driving me crazy the last few days while I thought about an answer to your question! :) I was also very confused by your example at first, but I think this is how it all works out: 1) Time slices appear to be relative to the smallest (oldest) time stamp in Vertica which I believe is the t...

The White House recognizes the Big Data is getting BIGGER!

• http://www.whitehouse.gov/sites/default ... elease.pdf