[teiid-issues] [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