Search found 301 matches
- Thu Apr 13, 2017 12:41 pm
- Forum: General
- Topic: Vertica - All in!
- Replies: 4
- Views: 1279
Re: Vertica - All in!
Nice! You would have been my first guess if you weren’t faking us out!
- Wed Apr 12, 2017 10:04 pm
- Forum: General
- Topic: Vertica - All in!
- Replies: 4
- Views: 1279
Re: Vertica - All in!
That’s funny!! Maybe Stephen W?
—Sharon
—Sharon
- Fri Mar 31, 2017 3:08 am
- Forum: Vertica Data Load
- Topic: Parse Json from Vertica VARCHAR column
- Replies: 3
- Views: 1393
Re: Parse Json from Vertica VARCHAR column
Hi PJ, You can parse json stored in a column without using a flex table. Here are two examples: First storing the json in a varbinary column as a vmap. This would be ideal if queries are executed repeatedly on the same json so that you only generate the vmap once. create table t(vmap long varbinary(...
- Wed Oct 12, 2016 1:56 pm
- Forum: Vertica SQL
- Topic: Running Count Distinct
- Replies: 4
- Views: 1160
Re: Running Count Distinct
I just submitted this exact request a few weeks ago through Product Management. The more customers who request it, the more likely it is to be implemented. Open a ticket asking for it.
—Sharon
—Sharon
- Wed Sep 21, 2016 1:08 pm
- Forum: Vertica SQL Functions
- Topic: Clear audit data?
- Replies: 2
- Views: 1362
Re: Clear audit data?
I would hope that there’s no way to clear it. Otherwise HP would have no way to know if you’ve been within your license limit.
I see from the LICENSE_AUDITS view definition that it’s basedon vs_license_audits rather than a dc table which could be flushed.
—Sharon
I see from the LICENSE_AUDITS view definition that it’s basedon vs_license_audits rather than a dc table which could be flushed.
—Sharon
- Mon Sep 19, 2016 2:18 am
- Forum: Vertica SQL
- Topic: Overlapping time intervals
- Replies: 2
- Views: 1196
Re: Overlapping time intervals
Something like this? create table activity(userid integer, login_ts timestamp); insert into activity values(1, '1/12/2016 03:24:12'); insert into activity values(1, '2/5/2016 12:43:40'); insert into activity values(1, '1/13/2016 09:00'); insert into activity values(1, '1/23/2016 09:00'); insert into...
- Mon Jul 25, 2016 12:30 pm
- Forum: General
- Topic: Vertica Query returns zero records and when re-run returns some records
- Replies: 2
- Views: 1624
Re: Vertica Query returns zero records and when re-run returns some records
> Rows that are being returned are most likely not yet purged. Rows that have been deleted won’t be returned in the result set. SELECT statements default to being executed on the latest epoch, which won’t include the deleted records. Whether or not deleted records have been purged is irrelevant, sin...