suneet-s commented on a change in pull request #9704: Refresh query docs. URL: https://github.com/apache/druid/pull/9704#discussion_r409133275
########## 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: ^ fair point, this documentation makes me think there are only 2 ways to query a lookup, but maybe it's because I'm biased because I've tried in the past and have not been able to query it before that PR :) ---------------------------------------------------------------- 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: us...@infra.apache.org With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@druid.apache.org For additional commands, e-mail: commits-h...@druid.apache.org
