Maddineni Sukumar created PHOENIX-3841:
------------------------------------------
Summary: 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
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)
