Search found 527 matches

by NorbertKrupa
Sat Sep 24, 2016 9:08 pm
Forum: Vertica SQL Functions
Topic: Clear audit data?
Replies: 2
Views: 1047

Re: Clear audit data?

Julie wrote:Anyone know if there is a function to clear the LICENSE_AUDITS system table?
Create a new cluster. :lol:
by NorbertKrupa
Mon Sep 12, 2016 6:04 pm
Forum: General
Topic: WTF? Vertica is no longer part of HP?
Replies: 16
Views: 3032

Re: WTF? Vertica is no longer part of HP?

Just remember that Vertica started without HP. It will continue to do fine.
by NorbertKrupa
Fri Aug 12, 2016 4:11 pm
Forum: Vertica Community Edition
Topic: vbr.py
Replies: 2
Views: 639

Re: vbr.py

Not sure what enhancements have been made, but vbr.py was intended for a database level backup/restore. For a table level copy, I would use EXPORT TO VERTICA or COPY FROM VERTICA (note that the table structure does not get copied)
by NorbertKrupa
Sun Jul 24, 2016 10:59 pm
Forum: General
Topic: Vertica Query returns zero records and when re-run returns some records
Replies: 2
Views: 1403

Re: Vertica Query returns zero records and when re-run returns some records

Rows that are being returned are most likely not yet purged.
by NorbertKrupa
Mon Jun 20, 2016 1:07 am
Forum: Vertica SQL
Topic: projection_usage table not all tables got query_start_timestamp
Replies: 2
Views: 1931

Re: projection_usage table not all tables got query_start_timestamp

You can read my post on setting a time based collection policy here.
by NorbertKrupa
Fri May 27, 2016 7:40 pm
Forum: Vertica Database Administration
Topic: Packages installed by default when creating a new DB?
Replies: 1
Views: 775

Re: Packages installed by default when creating a new DB?

Nothing on the surface. You have to dig into the documentation and some things you'll need to guess. Package: AWS - probably loading from S3 Package: idol - probably using flex tables with the IDOL connector Package: kafka - kafka integration Package: flextable - flex table Package: approximate - fo...

Go to advanced search