You can override the lookup query for a relational lookup. You can add a WHERE clause and transform the lookup data before it is cached.
You can use reserved words and forward slashes in table names and column names.
You can enter a query to override the default lookup query completely. Or, you view and edit the default lookup query. The default lookup query includes the lookup ports, output ports, and the return port.
When you use an SQL override, the query appends the clause ORDER BY 1. The clause orders the data to reliably provide first and last values for other clauses.
You can manually validate the SQL by running the following query in a Hive command line utility:
CREATE VIEW <table name> (<port list>) AS <SQL>
where:
<table name>
is a name of your choice
<port list>
is the comma-delimited list of ports in the source