[
https://issues.apache.org/jira/browse/TRAFODION-197?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14696297#comment-14696297
]
Atanu Mishra commented on TRAFODION-197:
----------------------------------------
Suresh Subbiah (suresh-subbiah) wrote on 2014-06-30: #3
queries that access a Hive table qill not use the query text cache. The max. of
all the file modification timestamps and the number of files that belong to a
table have been added to the cache key. Previously query cache was serving
stale plans since the cache key could not detect that a new source file had
been added to a hive table.
Changed in trafodion:
status: Confirmed → Fix Committed
Weishiun Tsai (wei-shiun-tsai) wrote on 2014-07-01: #4
Verified on the 0629_0930 build. This problem has been fixed:
>>set schema hive.hive;
--- SQL operation complete.
>>invoke myhivetest;
-- Definition of hive table MYHIVETEST
-- Definition current Tue Jul 1 10:41:41 2014
(
A INT
)
--- SQL operation complete.
>>select * from myhivetest;
--- 0 row(s) selected.
>>insert into myhivetest values (1),(2),(3);
--- 3 row(s) inserted.
>>select * from myhivetest;
A
-----------
1
2
3
--- 3 row(s) selected.
Changed in trafodion:
status: Fix Committed → Fix Released
> LP Bug: 1293816 - Hive: Rows do not show up after inserting into a hive table
> -----------------------------------------------------------------------------
>
> Key: TRAFODION-197
> URL: https://issues.apache.org/jira/browse/TRAFODION-197
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-exe
> Reporter: Weishiun Tsai
> Assignee: Suresh Subbiah
> Priority: Critical
> Fix For: 1.0 (pre-incubation)
>
>
> From sqlci, the rows inserted into a hive table wouldn’t show up if the user
> continue to use the same sqlci section. Right now, the user would need to
> quit sqlci and start a new one to see these new rows:
> >>set schema hive.hive;
> --- SQL operation complete.
> >>invoke hivetest;
> -- Definition of hive table HIVETEST
> -- Definition current Mon Mar 17 15:06:33 2014
> (
> A INT
> )
> --- SQL operation complete.
> >>select * from hivetest;
> --- 0 row(s) selected.
> >>insert into hivetest values (1),(2),(3);
> --- 3 row(s) inserted.
> >>select * from hivetest;
> --- 0 row(s) selected.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
