GitHub user selvaganesang opened a pull request:
https://github.com/apache/incubator-trafodion/pull/287
[TRAFODION-1779] Non-optimal plan chosen for a query against the creaâ¦
â¦ted table
in the same session
The CQD TRAF_RELOAD_NATABLE_CACHE can be turned on to invalidate the cache
entry.
The usage will be as follows:
create table t1 ..
load into table t1 .. -->This adds the table t1 to NATable cache with
estimated row count as 100
cqd traf_reload_natable_cache 'on' ;
select * from t1 -->The non-metadata table accessed by this query will be
invalidated from
the NATable cache and reloaded
cqd traf_reload_natable_cache 'off'
Also removed the use of this CQD in the DDL portion of the codes because it
was never used.
This CQD was used prior to introduction of query invalidation feature.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/selvaganesang/incubator-trafodion
trafodion-1779
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/287.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #287
----
commit 91031ce94ea16ddb2e64f7c18ae3647f6e958583
Author: selvaganesang <[email protected]>
Date: 2016-01-27T01:27:01Z
[TRAFODION-1779] Non-optimal plan chosen for a query against the created
table
in the same session
The CQD TRAF_RELOAD_NATABLE_CACHE can be turned on to invalidate the cache
entry.
The usage will be as follows:
create table t1 ..
load into table t1 .. -->This adds the table t1 to NATable cache with
estimated row count as 100
cqd traf_reload_natable_cache 'on' ;
select * from t1 -->The non-metadata table accessed by this query will be
invalidated from
the NATable cache and reloaded
cqd traf_reload_natable_cache 'off'
Also removed the use of this CQD in the DDL portion of the codes because it
was never used.
This CQD was used prior to introduction of query invalidation feature.
----
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at [email protected] or file a JIRA ticket
with INFRA.
---
