11:02 a.m.
Dynamically Defined Materialized Views
--------------------------------------
Key: TEIID-1822
URL: https://issues.jboss.org/browse/TEIID-1822
Project: Teiid
Issue Type: Feature Request
Reporter: Mark Addleman
Assignee: Steven Hawkins
I'd like to be able to query a dynamically defined materialized view. For example,
suppose I issue the query
/* mat-view */ SELECT * FROM blah WHERE x='abc'
Optionally (probably based on a hint), I'd like the following query to execute against
the data set returned by the previous query rather than going back to the data source:
/* use-mat-view */ SELECT * FROM (SELECT * FROM blah WHERE x='abc') GROUP BY a
To make this truly useful, I'd like to define indexes. Something like:
/* mat-view(index-on:a,b,c) */ SELECT * FROM blah WHERE x='abc'
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:14 a.m.
[
https://issues.jboss.org/browse/TEIID-1822?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-1822:
---------------------------------------
At what scope is this happening? If these are user queries it seems like you should be
using a session temp table. Temp tables support primary key indexes. The only thing
missing is the ability to issue an alter to add an arbitrary index.
Dynamically Defined Materialized Views
--------------------------------------
Key: TEIID-1822
URL: https://issues.jboss.org/browse/TEIID-1822
Project: Teiid
Issue Type: Feature Request
Reporter: Mark Addleman
Assignee: Steven Hawkins
I'd like to be able to query a dynamically defined materialized view. For example,
suppose I issue the query
/* mat-view */ SELECT * FROM blah WHERE x='abc'
Optionally (probably based on a hint), I'd like the following query to execute
against the data set returned by the previous query rather than going back to the data
source:
/* use-mat-view */ SELECT * FROM (SELECT * FROM blah WHERE x='abc') GROUP BY
a
To make this truly useful, I'd like to define indexes. Something like:
/* mat-view(index-on:a,b,c) */ SELECT * FROM blah WHERE x='abc'
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
12:04 p.m.
[
https://issues.jboss.org/browse/TEIID-1822?page=com.atlassian.jira.plugin...
]
Mark Addleman edited comment on TEIID-1822 at 11/11/11 1:03 PM:
----------------------------------------------------------------
Potentially this is across users but, for our use case, the only downside to scoping by
user is additional storage requirements.
I hadn't considered using temp tables. I'll reread the docs and think about
whether they satisfy our needs.
Thanks
was (Author: markaddleman):
Potentially, this is across users but, for our use case, the only downside to scoping
by user is additional storage requirements.
I hadn't considered using temp tables. I'll reread the docs and think about
whether they satisfy our needs.
Thanks
Dynamically Defined Materialized Views
--------------------------------------
Key: TEIID-1822
URL: https://issues.jboss.org/browse/TEIID-1822
Project: Teiid
Issue Type: Feature Request
Reporter: Mark Addleman
Assignee: Steven Hawkins
I'd like to be able to query a dynamically defined materialized view. For example,
suppose I issue the query
/* mat-view */ SELECT * FROM blah WHERE x='abc'
Optionally (probably based on a hint), I'd like the following query to execute
against the data set returned by the previous query rather than going back to the data
source:
/* use-mat-view */ SELECT * FROM (SELECT * FROM blah WHERE x='abc') GROUP BY
a
To make this truly useful, I'd like to define indexes. Something like:
/* mat-view(index-on:a,b,c) */ SELECT * FROM blah WHERE x='abc'
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
12:04 p.m.
[
https://issues.jboss.org/browse/TEIID-1822?page=com.atlassian.jira.plugin...
]
Mark Addleman commented on TEIID-1822:
--------------------------------------
Potentially, this is across users but, for our use case, the only downside to scoping by
user is additional storage requirements.
I hadn't considered using temp tables. I'll reread the docs and think about
whether they satisfy our needs.
Thanks
Dynamically Defined Materialized Views
--------------------------------------
Key: TEIID-1822
URL: https://issues.jboss.org/browse/TEIID-1822
Project: Teiid
Issue Type: Feature Request
Reporter: Mark Addleman
Assignee: Steven Hawkins
I'd like to be able to query a dynamically defined materialized view. For example,
suppose I issue the query
/* mat-view */ SELECT * FROM blah WHERE x='abc'
Optionally (probably based on a hint), I'd like the following query to execute
against the data set returned by the previous query rather than going back to the data
source:
/* use-mat-view */ SELECT * FROM (SELECT * FROM blah WHERE x='abc') GROUP BY
a
To make this truly useful, I'd like to define indexes. Something like:
/* mat-view(index-on:a,b,c) */ SELECT * FROM blah WHERE x='abc'
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:29 a.m.
[
https://issues.jboss.org/browse/TEIID-1822?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-1822:
---------------------------------------
To elaborate more on a temporary table approach, I think this enhancement could be
expressed as adding limited support for global temporary tables and expanded create table
syntax.
If we added the ability to use create table AS clause, the IF NOT EXISTS clause (since it
would be non-durable), and index definition in the create statement, then a single CREATE
GLOBAL TEMPORARY TABLE IF NOT EXISTS tbl ... AS SELECT ... statement would be sufficient
to define a temporary table that fits your needs. We could also allow the matview cache
hint to apply to the statement so that you could control the memory preference and ttl.
For simplicity the table would be non-updatable, but the matview update procedure could
apply. Global temporary tables would be visible in user queries, but would not be visible
in views or procedures.
Dynamically Defined Materialized Views
--------------------------------------
Key: TEIID-1822
URL: https://issues.jboss.org/browse/TEIID-1822
Project: Teiid
Issue Type: Feature Request
Reporter: Mark Addleman
Assignee: Steven Hawkins
I'd like to be able to query a dynamically defined materialized view. For example,
suppose I issue the query
/* mat-view */ SELECT * FROM blah WHERE x='abc'
Optionally (probably based on a hint), I'd like the following query to execute
against the data set returned by the previous query rather than going back to the data
source:
/* use-mat-view */ SELECT * FROM (SELECT * FROM blah WHERE x='abc') GROUP BY
a
To make this truly useful, I'd like to define indexes. Something like:
/* mat-view(index-on:a,b,c) */ SELECT * FROM blah WHERE x='abc'
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
7:05 a.m.
[
https://issues.jboss.org/browse/TEIID-1822?page=com.atlassian.jira.plugin...
]
Mark Addleman commented on TEIID-1822:
--------------------------------------
I think this fits our needs almost exactly. I'm curious: would there be a way to
bring in external materialization? It's not very important but we occasionally get
requests that would be better served by EM.
Dynamically Defined Materialized Views
--------------------------------------
Key: TEIID-1822
URL: https://issues.jboss.org/browse/TEIID-1822
Project: Teiid
Issue Type: Feature Request
Reporter: Mark Addleman
Assignee: Steven Hawkins
I'd like to be able to query a dynamically defined materialized view. For example,
suppose I issue the query
/* mat-view */ SELECT * FROM blah WHERE x='abc'
Optionally (probably based on a hint), I'd like the following query to execute
against the data set returned by the previous query rather than going back to the data
source:
/* use-mat-view */ SELECT * FROM (SELECT * FROM blah WHERE x='abc') GROUP BY
a
To make this truly useful, I'd like to define indexes. Something like:
/* mat-view(index-on:a,b,c) */ SELECT * FROM blah WHERE x='abc'
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
12:54 p.m.
[
https://issues.jboss.org/browse/TEIID-1822?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-1822:
---------------------------------------
In light of discussions on http://community.jboss.org/thread/174886, is a global table
still needed? Or does TEIID-196 become the dominant issue?
Dynamically Defined Materialized Views
--------------------------------------
Key: TEIID-1822
URL: https://issues.jboss.org/browse/TEIID-1822
Project: Teiid
Issue Type: Feature Request
Reporter: Mark Addleman
Assignee: Steven Hawkins
I'd like to be able to query a dynamically defined materialized view. For example,
suppose I issue the query
/* mat-view */ SELECT * FROM blah WHERE x='abc'
Optionally (probably based on a hint), I'd like the following query to execute
against the data set returned by the previous query rather than going back to the data
source:
/* use-mat-view */ SELECT * FROM (SELECT * FROM blah WHERE x='abc') GROUP BY
a
To make this truly useful, I'd like to define indexes. Something like:
/* mat-view(index-on:a,b,c) */ SELECT * FROM blah WHERE x='abc'
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:13 p.m.
[
https://issues.jboss.org/browse/TEIID-1822?page=com.atlassian.jira.plugin...
]
Mark Addleman commented on TEIID-1822:
--------------------------------------
I think we can close this feature request out. I'm pretty sure that we can implement
everything we need by plugging into the AuthorizationValidator interface. Of course, at
some point, we'll end up asking that it be made a stable API :)
Dynamically Defined Materialized Views
--------------------------------------
Key: TEIID-1822
URL: https://issues.jboss.org/browse/TEIID-1822
Project: Teiid
Issue Type: Feature Request
Reporter: Mark Addleman
Assignee: Steven Hawkins
I'd like to be able to query a dynamically defined materialized view. For example,
suppose I issue the query
/* mat-view */ SELECT * FROM blah WHERE x='abc'
Optionally (probably based on a hint), I'd like the following query to execute
against the data set returned by the previous query rather than going back to the data
source:
/* use-mat-view */ SELECT * FROM (SELECT * FROM blah WHERE x='abc') GROUP BY
a
To make this truly useful, I'd like to define indexes. Something like:
/* mat-view(index-on:a,b,c) */ SELECT * FROM blah WHERE x='abc'
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
10:29 a.m.
[
https://issues.jboss.org/browse/TEIID-1822?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-1822.
-----------------------------------
Resolution: Rejected
Feature as described is not needed. Will still look at enhancing the create temporary
table statement to add additional features.
Dynamically Defined Materialized Views
--------------------------------------
Key: TEIID-1822
URL: https://issues.jboss.org/browse/TEIID-1822
Project: Teiid
Issue Type: Feature Request
Reporter: Mark Addleman
Assignee: Steven Hawkins
I'd like to be able to query a dynamically defined materialized view. For example,
suppose I issue the query
/* mat-view */ SELECT * FROM blah WHERE x='abc'
Optionally (probably based on a hint), I'd like the following query to execute
against the data set returned by the previous query rather than going back to the data
source:
/* use-mat-view */ SELECT * FROM (SELECT * FROM blah WHERE x='abc') GROUP BY
a
To make this truly useful, I'd like to define indexes. Something like:
/* mat-view(index-on:a,b,c) */ SELECT * FROM blah WHERE x='abc'
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:24 p.m.
[
https://issues.jboss.org/browse/TEIID-1822?page=com.atlassian.jira.plugin...
]
Steven Hawkins closed TEIID-1822.
---------------------------------
Dynamically Defined Materialized Views
--------------------------------------
Key: TEIID-1822
URL: https://issues.jboss.org/browse/TEIID-1822
Project: Teiid
Issue Type: Feature Request
Reporter: Mark Addleman
Assignee: Steven Hawkins
I'd like to be able to query a dynamically defined materialized view. For example,
suppose I issue the query
/* mat-view */ SELECT * FROM blah WHERE x='abc'
Optionally (probably based on a hint), I'd like the following query to execute
against the data set returned by the previous query rather than going back to the data
source:
/* use-mat-view */ SELECT * FROM (SELECT * FROM blah WHERE x='abc') GROUP BY
a
To make this truly useful, I'd like to define indexes. Something like:
/* mat-view(index-on:a,b,c) */ SELECT * FROM blah WHERE x='abc'
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
5247
days inactive
5266
days old
9 comments
6 participants
participants (6)
-
Mark Addleman (Commented) (JIRA) -
Mark Addleman (Created) (JIRA)
-
Mark Addleman (Issue Comment Edited) (JIRA)
-
Steven Hawkins (Closed) (JIRA)
-
Steven Hawkins (Commented) (JIRA)
-
Steven Hawkins (Resolved) (JIRA)