Istvan Toth created PHOENIX-6720:
------------------------------------

             Summary: show create table can't recreate column encoded tables 
that had columns dropped
                 Key: PHOENIX-6720
                 URL: https://issues.apache.org/jira/browse/PHOENIX-6720
             Project: Phoenix
          Issue Type: Bug
          Components: core
            Reporter: Istvan Toth


For column encoded tables, show create table will simply list the columns in 
order.

When the original table had some columns removed, or swapped around, then the 
column qualifers in the table are not guarenteed to start from 0 and increase 
by 1 for each column, based on the ordering of columns.

This means that when we load a data table via HBase, and then execute the DDL 
created by the show create table, the column_qualifiers on the new table are 
going to point to the wrong Hbase cell.

We need to include the COLUMN_QUALIFIERs in the show create table output for 
column encoded tables, (and we need to accept those as well, if don't already 
do that.)



--
This message was sent by Atlassian Jira
(v8.20.7#820007)

Reply via email to