phoenix-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Karan Mehta (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (PHOENIX-5054) "look up" the `CREATE TABLE` statement used for a table
Date Wed, 05 Dec 2018 01:32:00 GMT

    [ https://issues.apache.org/jira/browse/PHOENIX-5054?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16709501#comment-16709501
] 

Karan Mehta edited comment on PHOENIX-5054 at 12/5/18 1:31 AM:
---------------------------------------------------------------

[~elserj] [~gjacoby] [~vincentpoon] [~tdsilva]

Do you guys think if we can merge this with PHOENIX-5034? We can just audit the whole history
instead of creating the statement (where we might miss something)? We have an internal tool
that audits the schema and I believe that this will be a good feature to push inside the phoenix-core
as well.

Josh, it might also help you know if there was some accidental mishap done to the schema,
which may not be evident from the final export. For example, we don't allow users to toggle
between namespaces enable/disable, so if a user accidentally does that then we could point
it via the audit history.

The cons here are we need to enable the SYSTEM.LOG feature for this whole thing to work and
is not directly helpful for current live customers until they upgrade.

FYI [~xucang]


was (Author: karanmehta93):
[~elserj] [~gjacoby] [~vincentpoon] [~tdsilva]

Do you guys think if we can merge this with PHOENIX-5034? We can just audit the whole history
instead of creating the statement (where we might miss something)? We have an internal tool
that audits the schema and I believe that this will be a good feature to push inside the phoenix-core
as well.

FYI [~xucang]

> "look up" the `CREATE TABLE` statement used for a table
> -------------------------------------------------------
>
>                 Key: PHOENIX-5054
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-5054
>             Project: Phoenix
>          Issue Type: New Feature
>            Reporter: Josh Elser
>            Priority: Major
>
> This is a super common problem we run into:
>  # User files report/complaint
>  # We ask for DDLs for table and any indexes
>  # We receive the output of `describe <table>` from the HBase shell
> Presumably, we have all of the necessary information inside of {{SYSTEM.CATALOG}}, we
could recreate the {{CREATE TABLE}} statement for a table, no? I think it would be super helpful
to, at a given point in time, obtain the {{CREATE TABLE}} statement to recreate a table as
it currently exists.
> Split points might be the only thing we can't explicitly do via Phoenix, but that's pretty
minor compared to everything else.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message