Nice! You would have been my first guess if you weren’t faking us out!

That’s funny!! Maybe Stephen W?

—Sharon

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(...

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

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

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...

> 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...