[
https://issues.apache.org/jira/browse/PHOENIX-6720?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Istvan Toth updated PHOENIX-6720:
---------------------------------
Release Note:
PHOENIX now supports the COLUMN_QUALIFIER_COUNTER table option and the
ENCODED_QUALIFIER qualifier keyword for columns to set the "QUALIFIER_COUNTER"
and "COLUMN_QUALIFIER" columns respectively in SYSTEM.CATALOG for the table.
The CREATE TABLE statement and SchemaTool will now use the above features when
generating the DDL for column encoded tables with discontinuous qualifiers.
This enables re-generating the Phoenix metadata for tables that have
discontinous encoded column qualifers, so that the re-generated Phoenix tables
will work on copied or replicated HBase data tables from the source database.
For such tables, the generated CREATE TABLE statements will only be executable
for Phoenix versions having this patch. However, systems that do not have this
fix cannot correctly re-generate the table metadata. On older systems the only
way to achieve HBase data table level compatibility is to manually edit
SYSTEM.CATALOG.
> 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
> Affects Versions: 5.2.0, 5.1.3
> Reporter: Istvan Toth
> Assignee: Aron Attila Meszaros
> Priority: Blocker
>
> For column encoded tables,create table generate column qualifier order.
> When moving data between instances, and the original table had some columns
> removed, or swapped around, then the column qualifers in the table are not
> guarenteed to start from the expected value and increase by 1 for each
> column, based on the ordering of columns.
> This means that when we load a data table via HBase (i.e from a snaphsot),
> and then execute the DDL created by the show create table, or by other means,
> the column_qualifiers on the new table are going to point to the wrong Hbase
> cell.
> We need to accept and use COLUMN_QUALIFIER properties for columns, and
> include them in in the show create table output for column encoded tables.
> We also need to accept and generate QUALIFIER_COUNTER for the tables.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
