gianm commented on a change in pull request #9704: Refresh query docs. URL: https://github.com/apache/druid/pull/9704#discussion_r409124465
########## File path: docs/querying/lookups.md ########## @@ -55,21 +56,37 @@ Other lookup types are available as extensions, including: Query Syntax ------------ -In [Druid SQL](sql.html), lookups can be queried using the `LOOKUP` function, for example: +In [Druid SQL](sql.html), lookups can be queried using the [`LOOKUP` function](sql.md#string-functions), for example: +```sql +SELECT + LOOKUP(store, 'store_to_country') AS country, + SUM(revenue) +FROM sales +GROUP BY 1 ``` -SELECT LOOKUP(column_name, 'lookup-name'), COUNT(*) FROM datasource GROUP BY 1 + +They can also be queried using the [JOIN operator](datasource.md#join): Review comment: I don't think so, because the assumption should be you can direct query it (why not!) ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
