Search found 61 matches

by Jbaskin
Mon Aug 10, 2015 3:57 pm
Forum: Announcements, Events and Activities
Topic: That Rubic's Cube Guy?
Replies: 5
Views: 13821

Re: That Rubic's Cube Guy?

Hah! Julie, yeah that guy was amazing. Jim, I can't make it this year, so can you please post some more pics from the event? Last year you said you were going to print some vertica forums t-shirts. Did you for this year? If so, can I get one?
by Jbaskin
Fri Jul 31, 2015 4:46 pm
Forum: Vertica and the Operating System
Topic: YUM install Error
Replies: 1
Views: 13164

YUM install Error

Hello, I am at a client site and trying to use YUM to install NTP. Anyone know how to work around this issue below? [root@temp]# yum install ntp Loaded plugins: fastestmirror, security Loading mirror speeds from cached hostfile Error: Cannot retrieve metalink for repository: epel. Please verify its ...
by Jbaskin
Mon Jul 27, 2015 4:58 pm
Forum: New to Vertica Database Administration
Topic: Do NULL values count against my license?
Replies: 2
Views: 1203

Re: Do NULL values count against my license?

Awesome, thanks! BTW, I did t his simple test to confirm: dbadmin=> select audit('test'); audit ------- 0 (1 row) dbadmin=> insert into test select null; OUTPUT -------- 1 (1 row) dbadmin=> select audit('test'); audit ------- 0 (1 row) dbadmin=> insert into test select 1; OUTPUT -------- 1 (1 row) d...
by Jbaskin
Mon Jul 27, 2015 3:36 pm
Forum: New to Vertica Database Administration
Topic: Do NULL values count against my license?
Replies: 2
Views: 1203

Do NULL values count against my license?

Hi all,

Anyone know if NULL values in tables count against the Vertica license's raw data size?

Thank you
by Jbaskin
Thu Sep 26, 2013 1:01 pm
Forum: New to Vertica Database Administration
Topic: When was a sequence created?
Replies: 3
Views: 1063

Re: When was a sequence created?

Thanks. This is odd, huh? I wonder why it's not easy for us to determine when a sequence was created. Oh well. Maybe in the next release? They just have to add a create_time column to the sequences table :!:
by Jbaskin
Thu Sep 26, 2013 12:58 pm
Forum: Vertica Data Load
Topic: COPY DIRECT vs AUTO with ROLLBACK
Replies: 2
Views: 1209

Re: COPY DIRECT vs AUTO with ROLLBACK

Hi sKwa,

The load is happening at night when there aren't too many users online. I am just trying to get make sure I get the fastest rollback method so that I can fix what ever is wrong and reload the data as quickly as possible.

Thanks for your input!
by Jbaskin
Thu Sep 26, 2013 12:56 pm
Forum: Vertica Data Load
Topic: GET_NUM_REJECTED and ACCEPTED_ROWS by Session or Statement?
Replies: 2
Views: 1267

Re: GET_NUM_REJECTED and ACCEPTED_ROWS by Session or Stateme

Cool, thanks for explaining, sKwa!

Go to advanced search