{"action":"created","issue":{"url":"https://api.github.com/repos/cloudera/ibis/issues/648","labels_url":"https://api.github.com/repos/cloudera/ibis/issues/648/labels{/name}","comments_url":"https://api.github.com/repos/cloudera/ibis/issues/648/comments","events_url":"https://api.github.com/repos/cloudera/ibis/issues/648/events","html_url":"https://github.com/cloudera/ibis/issues/648","id":105520484,"number":648,"title":"SQLite: expression execute does not invoke dialect compiler","user":{"login":"wesm","id":329591,"avatar_url":"https://avatars.githubusercontent.com/u/329591?v=3","gravatar_id":"","url":"https://api.github.com/users/wesm","html_url":"https://github.com/wesm","followers_url":"https://api.github.com/users/wesm/followers","following_url":"https://api.github.com/users/wesm/following{/other_user}","gists_url":"https://api.github.com/users/wesm/gists{/gist_id}","starred_url":"https://api.github.com/users/wesm/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/wesm/subscriptions","organizations_url":"https://api.github.com/users/wesm/orgs","repos_url":"https://api.github.com/users/wesm/repos","events_url":"https://api.github.com/users/wesm/events{/privacy}","received_events_url":"https://api.github.com/users/wesm/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/cloudera/ibis/labels/bug","name":"bug","color":"fc2929"},{"url":"https://api.github.com/repos/cloudera/ibis/labels/sqlite","name":"sqlite","color":"c7def8"}],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/cloudera/ibis/milestones/6","html_url":"https://github.com/cloudera/ibis/milestones/0.5","labels_url":"https://api.github.com/repos/cloudera/ibis/milestones/6/labels","id":1149847,"number":6,"title":"0.5","description":"","creator":{"login":"wesm","id":329591,"avatar_url":"https://avatars.githubusercontent.com/u/329591?v=3","gravatar_id":"","url":"https://api.github.com/users/wesm","html_url":"https://github.com/wesm","followers_url":"https://api.github.com/users/wesm/followers","following_url":"https://api.github.com/users/wesm/following{/other_user}","gists_url":"https://api.github.com/users/wesm/gists{/gist_id}","starred_url":"https://api.github.com/users/wesm/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/wesm/subscriptions","organizations_url":"https://api.github.com/users/wesm/orgs","repos_url":"https://api.github.com/users/wesm/repos","events_url":"https://api.github.com/users/wesm/events{/privacy}","received_events_url":"https://api.github.com/users/wesm/received_events","type":"User","site_admin":false},"open_issues":6,"closed_issues":83,"state":"open","created_at":"2015-06-04T17:51:00Z","updated_at":"2015-09-09T05:11:51Z","due_on":"2015-09-15T07:00:00Z","closed_at":null},"comments":1,"created_at":"2015-09-09T05:11:51Z","updated_at":"2015-09-09T05:14:54Z","closed_at":null,"body":"Using crunchbase data\r\n\r\n```python\r\nfunding_buckets = [0, 1000000, 10000000, 50000000, 100000000, 500000000, 1000000000]\r\nbucket_names = ['0 to 1m', '1m to 10m', '10m to 50m', '50m to 100m', '100m to 500m',\r\n                '500m to 1b', 'Over 1b']\r\n\r\nbucket = (companies.funding_total_usd\r\n          .bucket(funding_buckets, include_over=True))\r\njoined = (companies.mutate(bucket=bucket, \r\n                           status=companies.status.fillna('Unknown'))\r\n          [companies.founded_at > '2010-01-01']\r\n          .group_by(['bucket', 'status'])\r\n          .size()\r\n          .mutate(bucket_name=lambda x: (x.bucket.label(bucket_names)\r\n                                         .fillna('Unknown'))))\r\ntable = joined.execute()\r\n```"},"comment":{"url":"https://api.github.com/repos/cloudera/ibis/issues/comments/138787402","html_url":"https://github.com/cloudera/ibis/issues/648#issuecomment-138787402","issue_url":"https://api.github.com/repos/cloudera/ibis/issues/648","id":138787402,"user":{"login":"wesm","id":329591,"avatar_url":"https://avatars.githubusercontent.com/u/329591?v=3","gravatar_id":"","url":"https://api.github.com/users/wesm","html_url":"https://github.com/wesm","followers_url":"https://api.github.com/users/wesm/followers","following_url":"https://api.github.com/users/wesm/following{/other_user}","gists_url":"https://api.github.com/users/wesm/gists{/gist_id}","starred_url":"https://api.github.com/users/wesm/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/wesm/subscriptions","organizations_url":"https://api.github.com/users/wesm/orgs","repos_url":"https://api.github.com/users/wesm/repos","events_url":"https://api.github.com/users/wesm/events{/privacy}","received_events_url":"https://api.github.com/users/wesm/received_events","type":"User","site_admin":false},"created_at":"2015-09-09T05:14:54Z","updated_at":"2015-09-09T05:14:54Z","body":"SQLite has its own translation rule for `IfNull` which this triggered"}}