6:38 p.m.
Include an example of the LOOKUP function in the Ref Guide
----------------------------------------------------------
Key: TEIID-1692
URL: https://issues.jboss.org/browse/TEIID-1692
Project: Teiid
Issue Type: Feature Request
Components: Documentation
Affects Versions: 7.4
Environment: All
Reporter: Paul Nittel
Assignee: Steven Hawkins
Once again I confused myself while trying to use the LOOKUP function. The first three
arguments are all quoted strings. A simple example might help demonstrate this to the
reader. I believe this may work as it follows the descriptive text.
SELECT LOOKUP('ModelName.StatePostalCodes', 'StateDisplayName',
'PostalCode', Table.WhatStateMatchesThisPostalCode) AS LookedUpStateName FROM
Table
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
7:02 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1692) Include an example of the LOOKUP function in the Ref Guide
[
https://issues.jboss.org/browse/TEIID-1692?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-1692:
---------------------------------------
How about a pointer over to the caching guide?
Include an example of the LOOKUP function in the Ref Guide
----------------------------------------------------------
Key: TEIID-1692
URL: https://issues.jboss.org/browse/TEIID-1692
Project: Teiid
Issue Type: Feature Request
Components: Documentation
Affects Versions: 7.4
Environment: All
Reporter: Paul Nittel
Assignee: Steven Hawkins
Once again I confused myself while trying to use the LOOKUP function. The first three
arguments are all quoted strings. A simple example might help demonstrate this to the
reader. I believe this may work as it follows the descriptive text.
SELECT LOOKUP('ModelName.StatePostalCodes', 'StateDisplayName',
'PostalCode', Table.WhatStateMatchesThisPostalCode) AS LookedUpStateName FROM
Table
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
7:36 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1692) Include an example of the LOOKUP function in the Ref Guide
[
https://issues.jboss.org/browse/TEIID-1692?page=com.atlassian.jira.plugin...
]
Paul Nittel commented on TEIID-1692:
------------------------------------
Pointers from one doc to another can be highly annoying to someone who just wants the
answer. I still think an example is best.
BTW, the example in the Caching guide is wrong. ;-)
lookup(‘ISOCountryCodes, ‘CountryName’, ‘CountryCode’, ‘US’)
It's missing the end quote for the first argument and the 4th argument should not be a
quoted literal.
Since both docs may wind up with examples, having the same example might save some time.
Include an example of the LOOKUP function in the Ref Guide
----------------------------------------------------------
Key: TEIID-1692
URL: https://issues.jboss.org/browse/TEIID-1692
Project: Teiid
Issue Type: Feature Request
Components: Documentation
Affects Versions: 7.4
Environment: All
Reporter: Paul Nittel
Assignee: Steven Hawkins
Once again I confused myself while trying to use the LOOKUP function. The first three
arguments are all quoted strings. A simple example might help demonstrate this to the
reader. I believe this may work as it follows the descriptive text.
SELECT LOOKUP('ModelName.StatePostalCodes', 'StateDisplayName',
'PostalCode', Table.WhatStateMatchesThisPostalCode) AS LookedUpStateName FROM
Table
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
7:58 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1692) Include an example of the LOOKUP function in the Ref Guide
[
https://issues.jboss.org/browse/TEIID-1692?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-1692:
---------------------------------------
Yes, it's missing a quote. Can you explain why the 4th argument should not be quoted?
Or would you just prefer a larger example that shows use of a column reference?
Just to reiterate, as the caching guide covers it is almost in all ways better to use a
materialized view rather than the lookup function. The lookup function at this point is
really just legacy that probably should be deprecated.
Include an example of the LOOKUP function in the Ref Guide
----------------------------------------------------------
Key: TEIID-1692
URL: https://issues.jboss.org/browse/TEIID-1692
Project: Teiid
Issue Type: Feature Request
Components: Documentation
Affects Versions: 7.4
Environment: All
Reporter: Paul Nittel
Assignee: Steven Hawkins
Once again I confused myself while trying to use the LOOKUP function. The first three
arguments are all quoted strings. A simple example might help demonstrate this to the
reader. I believe this may work as it follows the descriptive text.
SELECT LOOKUP('ModelName.StatePostalCodes', 'StateDisplayName',
'PostalCode', Table.WhatStateMatchesThisPostalCode) AS LookedUpStateName FROM
Table
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:14 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1692) Include an example of the LOOKUP function in the Ref Guide
[
https://issues.jboss.org/browse/TEIID-1692?page=com.atlassian.jira.plugin...
]
Paul Nittel commented on TEIID-1692:
------------------------------------
Ramesh and I discussed this and agree that materialized views are a much better approach
to looking up static data.
As for the 4th argument and quotes, it certainly works fine when the 4th arg is a literal
value to be looked up. I quoted the column being looked up and the query returned nulls as
the returned value. I imagine most uses of LOOKUP would be against a column rather than a
literal value.
Include an example of the LOOKUP function in the Ref Guide
----------------------------------------------------------
Key: TEIID-1692
URL: https://issues.jboss.org/browse/TEIID-1692
Project: Teiid
Issue Type: Feature Request
Components: Documentation
Affects Versions: 7.4
Environment: All
Reporter: Paul Nittel
Assignee: Steven Hawkins
Once again I confused myself while trying to use the LOOKUP function. The first three
arguments are all quoted strings. A simple example might help demonstrate this to the
reader. I believe this may work as it follows the descriptive text.
SELECT LOOKUP('ModelName.StatePostalCodes', 'StateDisplayName',
'PostalCode', Table.WhatStateMatchesThisPostalCode) AS LookedUpStateName FROM
Table
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:59 p.m.
New subject: [JBoss JIRA] Resolved: (TEIID-1692) Include an example of the LOOKUP function in the Ref Guide
[
https://issues.jboss.org/browse/TEIID-1692?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-1692.
-----------------------------------
Fix Version/s: 7.4.1
7.5
Resolution: Done
Updated both the caching guide and the reference lookup function docs to use the same
example.
Include an example of the LOOKUP function in the Ref Guide
----------------------------------------------------------
Key: TEIID-1692
URL: https://issues.jboss.org/browse/TEIID-1692
Project: Teiid
Issue Type: Feature Request
Components: Documentation
Affects Versions: 7.4
Environment: All
Reporter: Paul Nittel
Assignee: Steven Hawkins
Fix For: 7.4.1, 7.5
Once again I confused myself while trying to use the LOOKUP function. The first three
arguments are all quoted strings. A simple example might help demonstrate this to the
reader. I believe this may work as it follows the descriptive text.
SELECT LOOKUP('ModelName.StatePostalCodes', 'StateDisplayName',
'PostalCode', Table.WhatStateMatchesThisPostalCode) AS LookedUpStateName FROM
Table
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
3:54 p.m.
New subject: [JBoss JIRA] (TEIID-1692) Include an example of the LOOKUP function in the Ref Guide
[
https://issues.jboss.org/browse/TEIID-1692?page=com.atlassian.jira.plugin...
]
Steven Hawkins closed TEIID-1692.
---------------------------------
Include an example of the LOOKUP function in the Ref Guide
----------------------------------------------------------
Key: TEIID-1692
URL: https://issues.jboss.org/browse/TEIID-1692
Project: Teiid
Issue Type: Feature Request
Components: Documentation
Affects Versions: 7.4
Environment: All
Reporter: Paul Nittel
Assignee: Steven Hawkins
Fix For: 7.4.1, 7.5
Once again I confused myself while trying to use the LOOKUP function. The first three
arguments are all quoted strings. A simple example might help demonstrate this to the
reader. I believe this may work as it follows the descriptive text.
SELECT LOOKUP('ModelName.StatePostalCodes', 'StateDisplayName',
'PostalCode', Table.WhatStateMatchesThisPostalCode) AS LookedUpStateName FROM
Table
--
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
4499
days inactive
4709
days old
6 comments
2 participants
participants (2)
-
Paul Nittel (JIRA) -
Steven Hawkins (JIRA)