Skip to content

Instantly share code, notes, and snippets.

@kstirman

kstirman/amazing.sql

Created November 9, 2017 22:25
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kstirman/c81f3c18afd2cee5c7dde923cdb2287c to your computer and use it in GitHub Desktop.
Save kstirman/c81f3c18afd2cee5c7dde923cdb2287c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
amazing.sql
SELECT
business.name,
business.full_address,
business.city,
business.state,
review.text,
review."date" AS "date",
review.user_id AS user_id,
review.stars AS stars,
review.text AS text
FROM
elastic.yelp.business AS business
INNER JOIN
elastic.yelp.review AS review ON business.business_id = review.business_id
WHERE CONTAINS(text:'amazing')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment