Mailing-List: contact dev-help@phoenix.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@phoenix.apache.org
Date: Tue, 9 May 2017 22:40:04 +0000 (UTC)
From: "Maddineni Sukumar (JIRA)" <jira@apache.org>
To: dev@phoenix.apache.org
Message-ID: <JIRA.13070443.1494341414000.170441.1494369604168@Atlassian.JIRA>
In-Reply-To: <JIRA.13070443.1494341414000@Atlassian.JIRA>
References: <JIRA.13070443.1494341414000@Atlassian.JIRA> <JIRA.13070443.1494341414335@jira-lw-us.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
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
archived-at: Tue, 09 May 2017 22:40:09 -0000


    [ https://issues.apache.org/jira/browse/PHOENIX-3841?page=3Dcom.atlassi=
an.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=3D16=
003685#comment-16003685 ]=20

Maddineni Sukumar commented on PHOENIX-3841:
--------------------------------------------

Yes it fixed the issue I was facing because it got latest values for parent=
 table from server along with timestamp, earlier when we read from cache we=
 were getting values with timestamp -1(QueryConstants.UNSET_TIMESTAMP).=20
Attaching v3 with comments.

Thanks [~jamestaylor]

> 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-3=
841.v3.patch
>
>
> Create VIEW command failing with actual table not found error and next re=
try failed with VIEW already exists error..And its continuing like that(fir=
st 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=3D100000;
> Create View command:
> CREATE VIEW my_view (v43 VARCHAR) AS SELECT * FROM UpdateCacheViewTestB W=
HERE v1 =3D 'value1=E2=80=99;
> sqlline Console output:
> 0: jdbc:phoenix:shared-mnds1-1-sfm.ops.sfdc.n> select * from UPDATECACHEV=
IEWTESTB;
> -------------------------------------------------------------------------=
-------------------------------------------------
> K=09V1=09V2
> -------------------------------------------------------------------------=
-------------------------------------------------
> 0: jdbc:phoenix:shared-mnds1-1-sfm.ops.sfdc.n> CREATE VIEW my_view (v43 V=
ARCHAR) AS SELECT * FROM UpdateCacheViewTestB WHERE v1 =3D 'value1';
> Error: ERROR 1012 (42M03): Table undefined. tableName=3DUPDATECACHEVIEWTE=
STB (state=3D42M03,code=3D1012)
> 0: jdbc:phoenix:shared-mnds1-1-sfm.ops.sfdc.n> CREATE VIEW my_view (v43 V=
ARCHAR) AS SELECT * FROM UpdateCacheViewTestB WHERE v1 =3D 'value1';
> Error: ERROR 1013 (42M04): Table already exists. tableName=3DMY_VIEW (sta=
te=3D42M04,code=3D1013)
> 0: jdbc:phoenix:shared-mnds1-1-sfm.ops.sfdc.n> CREATE VIEW my_view (v43 V=
ARCHAR) AS SELECT * FROM UpdateCacheViewTestB WHERE v1 =3D 'value1';
> Error: ERROR 1012 (42M03): Table undefined. tableName=3DUPDATECACHEVIEWTE=
STB (state=3D42M03,code=3D1012)


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