ChinmaySKulkarni commented on a change in pull request #599: Create columns in SYSCAT and fields in PTable.proto for view TTL support URL: https://github.com/apache/phoenix/pull/599#discussion_r350969937
########## File path: phoenix-core/src/it/java/org/apache/phoenix/end2end/ViewTTLIT.java ########## @@ -0,0 +1,397 @@ +/* + * Licensed to the Apache Software Foundation (ASF) under one + * or more contributor license agreements. See the NOTICE file + * distributed with this work for additional information + * regarding copyright ownership. The ASF licenses this file + * to you under the Apache License, Version 2.0 (the + * "License"); you may not use this file except in compliance + * with the License. You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + */ + +package org.apache.phoenix.end2end; + +import com.google.common.collect.Lists; +import org.apache.hadoop.hbase.HConstants; +import org.apache.hadoop.hbase.client.Result; +import org.apache.hadoop.hbase.client.ResultScanner; +import org.apache.hadoop.hbase.client.Scan; +import org.apache.hadoop.hbase.client.Table; +import org.apache.hadoop.hbase.filter.BinaryComparator; +import org.apache.hadoop.hbase.filter.CompareFilter; +import org.apache.hadoop.hbase.filter.FilterList; +import org.apache.hadoop.hbase.filter.QualifierFilter; +import org.apache.hadoop.hbase.filter.RowFilter; +import org.apache.hadoop.hbase.filter.SubstringComparator; +import org.apache.hadoop.hbase.util.Bytes; +import org.apache.phoenix.exception.SQLExceptionCode; +import org.apache.phoenix.jdbc.PhoenixDatabaseMetaData; +import org.apache.phoenix.query.PhoenixTestBuilder; +import org.apache.phoenix.query.PhoenixTestBuilder.SchemaBuilder.TableOptions; +import org.apache.phoenix.query.PhoenixTestBuilder.SchemaBuilder.TenantViewOptions; +import org.apache.phoenix.query.PhoenixTestBuilder.SchemaBuilder.TenantViewIndexOptions; +import org.apache.phoenix.query.QueryConstants; +import org.apache.phoenix.schema.PTableType; +import org.apache.phoenix.util.SchemaUtil; +import org.apache.phoenix.util.TestUtil; +import org.junit.Test; +import org.slf4j.Logger; +import org.slf4j.LoggerFactory; + +import java.io.IOException; +import java.sql.Connection; +import java.sql.DriverManager; +import java.sql.ResultSet; +import java.sql.SQLException; +import java.sql.Statement; + +import static org.apache.phoenix.util.PhoenixRuntime.TENANT_ID_ATTRIB; +import static org.junit.Assert.assertEquals; +import static org.junit.Assert.fail; + +public class ViewTTLIT extends ParallelStatsDisabledIT { + + private static final Logger LOGGER = LoggerFactory.getLogger(ViewTTLIT.class); + private static final String ORG_ID_FMT = "00D0x000%s"; + private static final String ID_FMT = "00A0y000%07d"; + private static final String VIEW_TTL_HEADER_SQL = "SELECT VIEW_TTL FROM SYSTEM.CATALOG " + + "WHERE %s AND TABLE_SCHEM = '%s' AND TABLE_NAME = '%s' AND TABLE_TYPE = '%s'"; + + private static final String ALTER_VIEW_TTL_SQL = "ALTER VIEW %s.%s set VIEW_TTL=%d"; + + // Scans the HBase rows directly for the view ttl related header rows column and asserts + private void assertViewHeaderRowsHaveViewTTLRelatedCells(String schemaName, long minTimestamp, + boolean rawScan, int expectedRows) throws IOException, SQLException { + + FilterList filterList = new FilterList(FilterList.Operator.MUST_PASS_ALL); + RowFilter schemaNameFilter = new RowFilter( + CompareFilter.CompareOp.EQUAL, + new SubstringComparator(schemaName) + ); + QualifierFilter viewTTLQualifierFilter = new QualifierFilter(CompareFilter.CompareOp.EQUAL, + new BinaryComparator(PhoenixDatabaseMetaData.VIEW_TTL_BYTES)); + filterList.addFilter(schemaNameFilter); + filterList.addFilter(viewTTLQualifierFilter); + try (Table tbl = driver.getConnectionQueryServices(getUrl(), TestUtil.TEST_PROPERTIES) + .getTable(PhoenixDatabaseMetaData.SYSTEM_CATALOG_NAME_BYTES)) { + + Scan allRows = new Scan(); + allRows.setRaw(rawScan); + allRows.setTimeRange(minTimestamp, HConstants.LATEST_TIMESTAMP); + allRows.setFilter(filterList); + ResultScanner scanner = tbl.getScanner(allRows); + int numMatchingRows = 0; + for (Result result = scanner.next(); result != null; result = scanner.next()) { + numMatchingRows += + result.containsColumn(QueryConstants.DEFAULT_COLUMN_FAMILY_BYTES, + PhoenixDatabaseMetaData.VIEW_TTL_BYTES) ? 1 : 0; + } + assertEquals(String.format("Expected rows do not match for table = %s at timestamp %d", + Bytes.toString(PhoenixDatabaseMetaData.SYSTEM_CATALOG_NAME_BYTES), minTimestamp), expectedRows, numMatchingRows); + } + + } + + private void assertSyscatHaveViewTTLRelatedColumns(String tenantId, String schemaName, String tableName, String tableType, long ttlValueExpected) + throws SQLException { + + try (Connection connection = DriverManager.getConnection(getUrl())) { + Statement stmt = connection.createStatement(); + String tenantClause = tenantId == null || tenantId.isEmpty() ? "TENANT_ID IS NULL" : String.format("TENANT_ID = '%s'", tenantId); + String sql = String.format(VIEW_TTL_HEADER_SQL, tenantClause, schemaName, tableName, tableType); + stmt.execute(sql); + ResultSet rs = stmt.getResultSet() ; + long actualTTLValueReturned = rs.next() ? rs.getLong(1) : 0; + + assertEquals(String.format("Expected rows do not match for schema = %s, table = %s", + schemaName, tableName), ttlValueExpected, actualTTLValueReturned); + } + } + + private String stripQuotes(String name) { + return name.replace("\"", ""); + } + + + /** + * ----------------- + * Test methods + * ----------------- + */ + + @Test + public void testWithBasicGlobalViewWithNoViewTTLDefined() throws Exception { + + long startTime = System.currentTimeMillis(); + + // Define the test schema. + // 1. Table with default columns => (ORG_ID, KP, COL1, COL2, COL3), PK => (ORG_ID, KP) + // 2. GlobalView with default columns => (ID, COL4, COL5, COL6), PK => (ID) + final PhoenixTestBuilder.SchemaBuilder schemaBuilder = new PhoenixTestBuilder.SchemaBuilder(getUrl()); + schemaBuilder + .withTableDefaults() + .withGlobalViewDefaults() + .build(); + + // Expected 2 rows - one for Table and GlobalView each. + // Since the VIEW_TTL property values are not being set, we expect the view header columns to show up in raw scans only. + assertViewHeaderRowsHaveViewTTLRelatedCells(schemaBuilder.getTableOptions().getSchemaName(), startTime, true, 2); + } + + + + @Test + public void testViewTTLWithTableLevelTTLFails() throws Exception { + + // Define the test schema. + // 1. Table with default columns => (ORG_ID, KP, COL1, COL2, COL3), PK => (ORG_ID, KP) + // 2. Tenant with default columns => (ZID, COL7, COL8, COL9), PK => (ZID) + final PhoenixTestBuilder.SchemaBuilder schemaBuilder = new PhoenixTestBuilder.SchemaBuilder(getUrl()); + + TableOptions tableOptions = TableOptions.withDefaults(); + tableOptions.setTableProps("COLUMN_ENCODED_BYTES=0,MULTI_TENANT=true,TTL=100"); + + TenantViewOptions tenantViewOptions = TenantViewOptions.withDefaults(); + tenantViewOptions.setTableProps("VIEW_TTL=1000"); + try { + schemaBuilder + .withTableOptions(tableOptions) + .withTenantViewOptions(tenantViewOptions) + .buildNewView(); + fail(); + } catch (SQLException e) { + assertEquals(SQLExceptionCode.CANNOT_SET_OR_ALTER_VIEW_TTL_FOR_TABLE_WITH_TTL.getErrorCode(), e.getErrorCode()); + } + } + + @Test + public void testViewTTLWithViewIndexFails() throws Exception { + + // Define the test schema. + // 1. Table with default columns => (ORG_ID, KP, COL1, COL2, COL3), PK => (ORG_ID, KP) + // 2. Tenant with default columns => (ZID, COL7, COL8, COL9), PK => (ZID) + final PhoenixTestBuilder.SchemaBuilder schemaBuilder = new PhoenixTestBuilder.SchemaBuilder(getUrl()); + + TableOptions tableOptions = TableOptions.withDefaults(); + tableOptions.setTableProps("COLUMN_ENCODED_BYTES=0,MULTI_TENANT=true"); + + TenantViewIndexOptions tenantViewIndexOptions = TenantViewIndexOptions.withDefaults(); + tenantViewIndexOptions.setIndexProps("VIEW_TTL=1000"); + try { + schemaBuilder + .withTableOptions(tableOptions) + .withTenantViewDefaults() + .withTenantViewIndexOptions(tenantViewIndexOptions) + .buildNewView(); + fail(); + } catch (SQLException e) { + assertEquals(SQLExceptionCode.VIEW_TTL_SUPPORTED_FOR_VIEWS_ONLY.getErrorCode(), e.getErrorCode()); + } + } + + @Test + public void testViewTTLForLevelOneView() throws Exception { + long startTime = System.currentTimeMillis(); + + // Define the test schema. + // 1. Table with default columns => (ORG_ID, KP, COL1, COL2, COL3), PK => (ORG_ID, KP) + // 2. Tenant with default columns => (ZID, COL7, COL8, COL9), PK => (ZID) + final PhoenixTestBuilder.SchemaBuilder schemaBuilder = new PhoenixTestBuilder.SchemaBuilder(getUrl()); + + TableOptions tableOptions = TableOptions.withDefaults(); + tableOptions.setTableProps("COLUMN_ENCODED_BYTES=0,MULTI_TENANT=true"); + + TenantViewOptions tenantViewOptions = TenantViewOptions.withDefaults(); + tenantViewOptions.setTableProps("VIEW_TTL=1000"); + schemaBuilder + .withTableOptions(tableOptions) + .withTenantViewOptions(tenantViewOptions) + .withTenantViewIndexDefaults() + .buildNewView(); + + String tenantId = schemaBuilder.getDataOptions().getTenantId(); + String schemaName = stripQuotes(SchemaUtil.getSchemaNameFromFullName(schemaBuilder.getEntityTenantViewName())); + String tenantViewName = stripQuotes(SchemaUtil.getTableNameFromFullName(schemaBuilder.getEntityTenantViewName())); + String indexOnTenantViewName = String.format("IDX_%s", stripQuotes(schemaBuilder.getEntityKeyPrefix())); + + // Expected 2 rows - one for TenantView and ViewIndex each. + // Since the VIEW_TTL property values are being set, we expect the view header columns to show up in regular scans too. + assertViewHeaderRowsHaveViewTTLRelatedCells(schemaBuilder.getTableOptions().getSchemaName(), startTime, false, 2); + // Since the VIEW_TTL property values are not being overriden, we expect the TTL value to be different from the global view. + assertSyscatHaveViewTTLRelatedColumns(tenantId, schemaName, tenantViewName, PTableType.VIEW.getSerializedValue(), 1000); + assertSyscatHaveViewTTLRelatedColumns(tenantId, schemaName, indexOnTenantViewName, PTableType.INDEX.getSerializedValue(), 1000); + + } + + @Test + public void testViewTTLForLevelTwoView() throws Exception { + long startTime = System.currentTimeMillis(); + + // Define the test schema. + // 1. Table with default columns => (ORG_ID, KP, COL1, COL2, COL3), PK => (ORG_ID, KP) + // 2. GlobalView with default columns => (ID, COL4, COL5, COL6), PK => (ID) + // 3. Tenant with default columns => (ZID, COL7, COL8, COL9), PK => (ZID) + final PhoenixTestBuilder.SchemaBuilder schemaBuilder = new PhoenixTestBuilder.SchemaBuilder(getUrl()); + + TableOptions tableOptions = TableOptions.withDefaults(); + tableOptions.setTableProps("COLUMN_ENCODED_BYTES=0,MULTI_TENANT=true"); + + PhoenixTestBuilder.SchemaBuilder.GlobalViewOptions + globalViewOptions = PhoenixTestBuilder.SchemaBuilder.GlobalViewOptions.withDefaults(); + globalViewOptions.setTableProps("VIEW_TTL=300000"); + + PhoenixTestBuilder.SchemaBuilder.GlobalViewIndexOptions + globalViewIndexOptions = + PhoenixTestBuilder.SchemaBuilder.GlobalViewIndexOptions.withDefaults(); + globalViewIndexOptions.setLocal(false); + + TenantViewOptions tenantViewWithOverrideOptions = TenantViewOptions.withDefaults(); + tenantViewWithOverrideOptions.setTableProps("VIEW_TTL=1000"); + schemaBuilder + .withTableOptions(tableOptions) + .withGlobalViewOptions(globalViewOptions) + .withGlobalViewIndexOptions(globalViewIndexOptions) + .withTenantViewOptions(tenantViewWithOverrideOptions) + .withTenantViewIndexDefaults() + .buildWithNewTenant(); + + String tenantId = schemaBuilder.getDataOptions().getTenantId(); + String schemaName = stripQuotes(SchemaUtil.getSchemaNameFromFullName(schemaBuilder.getEntityTenantViewName())); + String globalViewName = stripQuotes(SchemaUtil.getTableNameFromFullName(schemaBuilder.getEntityGlobalViewName())); + String tenantViewName = stripQuotes(SchemaUtil.getTableNameFromFullName(schemaBuilder.getEntityTenantViewName())); + String indexOnGlobalViewName = String.format("IDX_%s", globalViewName); + String indexOnTenantViewName = String.format("IDX_%s", stripQuotes(schemaBuilder.getEntityKeyPrefix())); + + + + // Expected 4 rows - one for GlobalView, one for TenantView and ViewIndex each. + // Since the VIEW_TTL property values are being set, we expect the view header columns to show up in regular scans too. + assertViewHeaderRowsHaveViewTTLRelatedCells(schemaBuilder.getTableOptions().getSchemaName(), startTime, false, 4); + assertSyscatHaveViewTTLRelatedColumns("", schemaName, globalViewName, PTableType.VIEW.getSerializedValue(), 300000); + assertSyscatHaveViewTTLRelatedColumns("", schemaName, indexOnGlobalViewName, PTableType.INDEX.getSerializedValue(), 300000); + // Since the VIEW_TTL property values are not being overriden, we expect the TTL value to be different from the global view. + assertSyscatHaveViewTTLRelatedColumns(tenantId, schemaName, tenantViewName, PTableType.VIEW.getSerializedValue(), 1000); + assertSyscatHaveViewTTLRelatedColumns(tenantId, schemaName, indexOnTenantViewName, PTableType.INDEX.getSerializedValue(), 1000); + + // Without override + startTime = System.currentTimeMillis(); + + TenantViewOptions tenantViewWithoutOverrideOptions = TenantViewOptions.withDefaults(); + schemaBuilder + .withTableOptions(tableOptions) + .withGlobalViewOptions(globalViewOptions) + .withGlobalViewIndexOptions(globalViewIndexOptions) + .withTenantViewOptions(tenantViewWithoutOverrideOptions) + .withTenantViewIndexDefaults() + .buildWithNewTenant(); + + tenantId = schemaBuilder.getDataOptions().getTenantId(); + schemaName = stripQuotes(SchemaUtil.getSchemaNameFromFullName(schemaBuilder.getEntityTenantViewName())); + globalViewName = stripQuotes(SchemaUtil.getTableNameFromFullName(schemaBuilder.getEntityGlobalViewName())); + tenantViewName = stripQuotes(SchemaUtil.getTableNameFromFullName(schemaBuilder.getEntityTenantViewName())); + indexOnGlobalViewName = String.format("IDX_%s", globalViewName); + indexOnTenantViewName = String.format("IDX_%s", stripQuotes(schemaBuilder.getEntityKeyPrefix())); + + + // Expected 2 rows - one for TenantView and ViewIndex each. + // Since the VIEW_TTL property values are being set, we expect the view header columns to show up in regular scans too. + assertViewHeaderRowsHaveViewTTLRelatedCells(schemaBuilder.getTableOptions().getSchemaName(), startTime, false, 2); + assertSyscatHaveViewTTLRelatedColumns("", schemaName, globalViewName, PTableType.VIEW.getSerializedValue(), 300000); + assertSyscatHaveViewTTLRelatedColumns("", schemaName, indexOnGlobalViewName, PTableType.INDEX.getSerializedValue(), 300000); + // Since the VIEW_TTL property values are not being overriden, we expect the TTL value to be same as the global view. + assertSyscatHaveViewTTLRelatedColumns(tenantId, schemaName, tenantViewName, PTableType.VIEW.getSerializedValue(), 300000); + assertSyscatHaveViewTTLRelatedColumns(tenantId, schemaName, indexOnTenantViewName, PTableType.INDEX.getSerializedValue(), 300000); + } + + @Test + public void testViewTTLForWhenTTLIsZero() throws Exception { + long startTime = System.currentTimeMillis(); + + // Define the test schema. + // 1. Table with default columns => (ORG_ID, KP, COL1, COL2, COL3), PK => (ORG_ID, KP) + // 2. Tenant with default columns => (ZID, COL7, COL8, COL9), PK => (ZID) + final PhoenixTestBuilder.SchemaBuilder schemaBuilder = new PhoenixTestBuilder.SchemaBuilder(getUrl()); + + TableOptions tableOptions = TableOptions.withDefaults(); + tableOptions.setTableProps("COLUMN_ENCODED_BYTES=0,MULTI_TENANT=true"); + + TenantViewOptions tenantViewOptions = TenantViewOptions.withDefaults(); + tenantViewOptions.setTableProps("VIEW_TTL=0"); + schemaBuilder + .withTableOptions(tableOptions) + .withTenantViewOptions(tenantViewOptions) + .withTenantViewIndexDefaults() + .buildNewView(); + + String tenantId = schemaBuilder.getDataOptions().getTenantId(); + String schemaName = stripQuotes(SchemaUtil.getSchemaNameFromFullName(schemaBuilder.getEntityTenantViewName())); + String tenantViewName = stripQuotes(SchemaUtil.getTableNameFromFullName(schemaBuilder.getEntityTenantViewName())); + String indexOnTenantViewName = String.format("IDX_%s", stripQuotes(schemaBuilder.getEntityKeyPrefix())); + + // Expected 3 deleted rows - one for Table, one for TenantView and ViewIndex each. + // Since the VIEW_TTL property values are not being set or being set to zero, + // we expect the view header columns to show up in raw scans only. + assertViewHeaderRowsHaveViewTTLRelatedCells(schemaBuilder.getTableOptions().getSchemaName(), startTime, true, 3); + // Since the VIEW_TTL property values are not being overriden, we expect the TTL value to be different from the global view. + assertSyscatHaveViewTTLRelatedColumns(tenantId, schemaName, tenantViewName, PTableType.VIEW.getSerializedValue(), 0); + assertSyscatHaveViewTTLRelatedColumns(tenantId, schemaName, indexOnTenantViewName, PTableType.INDEX.getSerializedValue(), 0); + + } + + @Test + public void testViewTTLWithAlterView() throws Exception { + long startTime = System.currentTimeMillis(); + + // Define the test schema. + // 1. Table with default columns => (ORG_ID, KP, COL1, COL2, COL3), PK => (ORG_ID, KP) + // 2. Tenant with default columns => (ZID, COL7, COL8, COL9), PK => (ZID) + final PhoenixTestBuilder.SchemaBuilder schemaBuilder = new PhoenixTestBuilder.SchemaBuilder(getUrl()); + + TableOptions tableOptions = TableOptions.withDefaults(); + tableOptions.setTableProps("COLUMN_ENCODED_BYTES=0,MULTI_TENANT=true"); + + TenantViewOptions tenantViewOptions = TenantViewOptions.withDefaults(); + tenantViewOptions.setTableProps("VIEW_TTL=0"); Review comment: same here ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services
