That should be there already, but that doesn't help the existing 4.x
release lines (which, I assume, would be what Mich cares about).
On 4/14/20 11:59 AM, Sukumar Maddineni wrote:
How about a simple idea of redirecting all DDL statements to SYSTEM.LOG
by default which will be useful for logging+auditing purposes and also
for recreating table if needed.
--
Sukumar
On Tue, Apr 14, 2020 at 8:49 AM Geoffrey Jacoby <gjac...@salesforce.com
<mailto:gjac...@salesforce.com>> wrote:
This is a frequent feature request we unfortunately haven't
implemented yet -- see PHOENIX-4286 and PHOENIX-5054, one of which I
filed and the other one Josh did. :-)
I agree with Josh, I'd love to see an implementation of this if
someone has bandwidth.
Geoffrey Jacoby
On Tue, Apr 14, 2020 at 8:01 AM Josh Elser <els...@apache.org
<mailto:els...@apache.org>> wrote:
Yeah, I don't have anything handy.
I'll happily review and commit such a utility if you happen to
write one
(even if flawed).
On 4/12/20 1:31 AM, Simon Mottram wrote:
> Best I can offer is
>
> "SELECT * FROM SYSTEM.CATALOG where table_name = '" +
tableName + "'
> and table_schem = '" +schemaName + "'"
>
> S
>
------------------------------------------------------------------------
> *From:* Mich Talebzadeh <mich.talebza...@gmail.com
<mailto:mich.talebza...@gmail.com>>
> *Sent:* Sunday, 12 April 2020 1:36 AM
> *To:* user <user@phoenix.apache.org
<mailto:user@phoenix.apache.org>>
> *Subject:* Reverse engineer a phoneix table definition
> Hi,
>
> I was wondering if anyone has a handy script to reverse
engineer an
> existing table schema.
>
> I guess one can get the info from system.catalog table to
start with.
> However, I was wondering if there is a shell script already
or I have to
> write my own.
>
> Thanks,
>
> Dr Mich Talebzadeh
>
> LinkedIn
>
/https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw/
>
> http://talebzadehmich.wordpress.com
>
>
> *Disclaimer:* Use it at your own risk.Any and all
responsibility for any
> loss, damage or destruction of data or any other property
which may
> arise from relying on this email's technical content is
explicitly
> disclaimed. The author will in no case be liable for any
monetary
> damages arising from such loss, damage or destruction.
>
--
<https://smart.salesforce.com/sig/smaddineni//us_mb/default/link.html>
