{"action":"closed","issue":{"url":"https://api.github.com/repos/databricks/spark-avro/issues/103","repository_url":"https://api.github.com/repos/databricks/spark-avro","labels_url":"https://api.github.com/repos/databricks/spark-avro/issues/103/labels{/name}","comments_url":"https://api.github.com/repos/databricks/spark-avro/issues/103/comments","events_url":"https://api.github.com/repos/databricks/spark-avro/issues/103/events","html_url":"https://github.com/databricks/spark-avro/issues/103","id":117966059,"number":103,"title":"storage directory structure aware queries","user":{"login":"Gauravshah","id":620559,"avatar_url":"https://avatars.githubusercontent.com/u/620559?v=3","gravatar_id":"","url":"https://api.github.com/users/Gauravshah","html_url":"https://github.com/Gauravshah","followers_url":"https://api.github.com/users/Gauravshah/followers","following_url":"https://api.github.com/users/Gauravshah/following{/other_user}","gists_url":"https://api.github.com/users/Gauravshah/gists{/gist_id}","starred_url":"https://api.github.com/users/Gauravshah/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Gauravshah/subscriptions","organizations_url":"https://api.github.com/users/Gauravshah/orgs","repos_url":"https://api.github.com/users/Gauravshah/repos","events_url":"https://api.github.com/users/Gauravshah/events{/privacy}","received_events_url":"https://api.github.com/users/Gauravshah/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2015-11-20T05:03:21Z","updated_at":"2016-11-21T23:35:31Z","closed_at":"2016-11-21T23:35:31Z","body":"I am trying to read s3 directory using sparksql.\n\n```\nCREATE TEMPORARY TABLE events_spark\nUSING com.databricks.spark.avro\nOPTIONS (path \"s3://s3-basin/events_v2/\")\n;\n```\n\nThe folder structure on s3 is `events_v2/year/month/date/hour/events.avro`. Is there any way to query the data like `select count(*) from events_spark where year=2015 AND month = 10 AND date = 12`\n\nI am able to do the same if I have the following directory:\n`events_v2/year=2015/month=11/day=20`\n"}}
{"actor":{"display_login":"JoshRosen"}}