phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hadoop QA (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-3841) Phoenix View creation failure with Primary table not found error when we use update_cache_frequency for primary table
Date Wed, 10 May 2017 21:36:04 GMT

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

Hadoop QA commented on PHOENIX-3841:
------------------------------------

{color:red}-1 overall{color}.  Here are the results of testing the latest attachment 
  http://issues.apache.org/jira/secure/attachment/12867398/PHOENIX-3841.v4.patch
  against master branch at commit 37d0a4a038c1f843db2a1d68cfc3b3cfa8c8d537.
  ATTACHMENT ID: 12867398

    {color:green}+1 @author{color}.  The patch does not contain any @author tags.

    {color:red}-1 tests included{color}.  The patch doesn't appear to include any new or modified
tests.
                        Please justify why no new tests are needed for this patch.
                        Also please list what manual steps were performed to verify this patch.

    {color:green}+1 javac{color}.  The applied patch does not increase the total number of
javac compiler warnings.

    {color:red}-1 javadoc{color}.  The javadoc tool appears to have generated 47 warning messages.

    {color:green}+1 release audit{color}.  The applied patch does not increase the total number
of release audit warnings.

    {color:red}-1 lineLengths{color}.  The patch introduces the following lines longer than
100:
    +        "CREATE TABLE "+TABLE_NAME+" (k VARCHAR PRIMARY KEY, v1 VARCHAR, v2 VARCHAR)
UPDATE_CACHE_FREQUENCY=1000000");
+      conn1.createStatement().execute("upsert into "+TABLE_NAME+" values ('row1', 'value1',
'key1')");
+        "CREATE VIEW "+VIEW_NAME+" (v43 VARCHAR) AS SELECT * FROM "+TABLE_NAME+" WHERE v1
= 'value1'");
+            // We need to always get the latest meta data for the parent table of a create
view call to ensure that
+            // that we're copying the current table meta data as of when the view is created.
Once we no longer
+            // copy the parent meta data, but store only the local diffs (PHOENIX-3534),
we will no longer need
+            SingleTableColumnResolver visitor = new SingleTableColumnResolver(connection,
tableNode, true, true);
+          this(connection, tableNode, updateCacheImmediately, 0, new HashMap<String,UDFParseNode>(1),
alwaysHitServer);
+                Map<String, UDFParseNode> udfParseNodes, boolean alwaysHitServer) throws
SQLException {
+            TableRef tableRef = createTableRef(tableNode.getName().getSchemaName(), tableNode,
updateCacheImmediately, alwaysHitServer);

     {color:red}-1 core tests{color}.  The patch failed these unit tests:
     ./phoenix-core/target/failsafe-reports/TEST-org.apache.phoenix.end2end.ClientTimeArithmeticQueryIT
./phoenix-core/target/failsafe-reports/TEST-org.apache.phoenix.end2end.index.MutableIndexFailureIT
./phoenix-core/target/failsafe-reports/TEST-org.apache.phoenix.end2end.TransactionalViewIT

Test results: https://builds.apache.org/job/PreCommit-PHOENIX-Build/856//testReport/
Javadoc warnings: https://builds.apache.org/job/PreCommit-PHOENIX-Build/856//artifact/patchprocess/patchJavadocWarnings.txt
Console output: https://builds.apache.org/job/PreCommit-PHOENIX-Build/856//console

This message is automatically generated.

> Phoenix View creation failure with Primary table not found error when we use update_cache_frequency
for primary table
> ---------------------------------------------------------------------------------------------------------------------
>
>                 Key: PHOENIX-3841
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-3841
>             Project: Phoenix
>          Issue Type: Sub-task
>    Affects Versions: 4.10.0
>            Reporter: Maddineni Sukumar
>            Assignee: Maddineni Sukumar
>            Priority: Minor
>             Fix For: 4.11
>
>         Attachments: PHOENIX-3841.patch, PHOENIX-3841.v2.patch, PHOENIX-3841.v3.patch,
PHOENIX-3841.v4.patch
>
>
> Create VIEW command failing with actual table not found error and next retry failed with
VIEW already exists error..And its continuing like that(first tabelnotfound and then view
already exists)..
> If I create table without UPDATE_CACHE_FREQUENCY then its working fine.
> Create table command:
> create table UpdateCacheViewTestB (k VARCHAR PRIMARY KEY, v1 VARCHAR, v2 VARCHAR) UPDATE_CACHE_FREQUENCY=100000;
> Create View command:
> CREATE VIEW my_view (v43 VARCHAR) AS SELECT * FROM UpdateCacheViewTestB WHERE v1 = 'value1’;
> sqlline Console output:
> 0: jdbc:phoenix:shared-mnds1-1-sfm.ops.sfdc.n> select * from UPDATECACHEVIEWTESTB;
> --------------------------------------------------------------------------------------------------------------------------
> K	V1	V2
> --------------------------------------------------------------------------------------------------------------------------
> 0: jdbc:phoenix:shared-mnds1-1-sfm.ops.sfdc.n> CREATE VIEW my_view (v43 VARCHAR) AS
SELECT * FROM UpdateCacheViewTestB WHERE v1 = 'value1';
> Error: ERROR 1012 (42M03): Table undefined. tableName=UPDATECACHEVIEWTESTB (state=42M03,code=1012)
> 0: jdbc:phoenix:shared-mnds1-1-sfm.ops.sfdc.n> CREATE VIEW my_view (v43 VARCHAR) AS
SELECT * FROM UpdateCacheViewTestB WHERE v1 = 'value1';
> Error: ERROR 1013 (42M04): Table already exists. tableName=MY_VIEW (state=42M04,code=1013)
> 0: jdbc:phoenix:shared-mnds1-1-sfm.ops.sfdc.n> CREATE VIEW my_view (v43 VARCHAR) AS
SELECT * FROM UpdateCacheViewTestB WHERE v1 = 'value1';
> Error: ERROR 1012 (42M03): Table undefined. tableName=UPDATECACHEVIEWTESTB (state=42M03,code=1012)



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message