{"action":"created","issue":{"url":"https://api.github.com/repos/dask/dask/issues/3393","repository_url":"https://api.github.com/repos/dask/dask","labels_url":"https://api.github.com/repos/dask/dask/issues/3393/labels{/name}","comments_url":"https://api.github.com/repos/dask/dask/issues/3393/comments","events_url":"https://api.github.com/repos/dask/dask/issues/3393/events","html_url":"https://github.com/dask/dask/issues/3393","id":313083504,"number":3393,"title":"read_sql_table is not working correctly","user":{"login":"krinkere","id":1323717,"avatar_url":"https://avatars2.githubusercontent.com/u/1323717?v=4","gravatar_id":"","url":"https://api.github.com/users/krinkere","html_url":"https://github.com/krinkere","followers_url":"https://api.github.com/users/krinkere/followers","following_url":"https://api.github.com/users/krinkere/following{/other_user}","gists_url":"https://api.github.com/users/krinkere/gists{/gist_id}","starred_url":"https://api.github.com/users/krinkere/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/krinkere/subscriptions","organizations_url":"https://api.github.com/users/krinkere/orgs","repos_url":"https://api.github.com/users/krinkere/repos","events_url":"https://api.github.com/users/krinkere/events{/privacy}","received_events_url":"https://api.github.com/users/krinkere/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2018-04-10T20:48:06Z","updated_at":"2018-04-11T16:54:22Z","closed_at":null,"author_association":"NONE","body":"I tried to read table from a remote Oracle database, and I am able to do it via dataframe and sqlalchemy.\r\nWhen i call read_sql_table provided by dask in sql.py, I am getting KeyError message\r\n\r\nIt breaks on index = (table.columns[index_col] if isinstance(....\r\n\r\nchecked and my index_col matches available table.columns, however, my index_col is of str per documentation, and table.columns are sqlalchemy.sql.schema.Column. Hence the error\r\n\r\nAlso in example section where it shows basic use, the example is outdated, still uses dd.read_sql\r\n\r\nI installed dask via pip, so I am using\r\n\r\n0.17.2-py36_0 "},"comment":{"url":"https://api.github.com/repos/dask/dask/issues/comments/380522336","html_url":"https://github.com/dask/dask/issues/3393#issuecomment-380522336","issue_url":"https://api.github.com/repos/dask/dask/issues/3393","id":380522336,"user":{"login":"martindurant","id":6042212,"avatar_url":"https://avatars1.githubusercontent.com/u/6042212?v=4","gravatar_id":"","url":"https://api.github.com/users/martindurant","html_url":"https://github.com/martindurant","followers_url":"https://api.github.com/users/martindurant/followers","following_url":"https://api.github.com/users/martindurant/following{/other_user}","gists_url":"https://api.github.com/users/martindurant/gists{/gist_id}","starred_url":"https://api.github.com/users/martindurant/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/martindurant/subscriptions","organizations_url":"https://api.github.com/users/martindurant/orgs","repos_url":"https://api.github.com/users/martindurant/repos","events_url":"https://api.github.com/users/martindurant/events{/privacy}","received_events_url":"https://api.github.com/users/martindurant/received_events","type":"User","site_admin":false},"created_at":"2018-04-11T16:54:22Z","updated_at":"2018-04-11T16:54:22Z","author_association":"OWNER","body":"Can you please find the possible entries in `table.columns`, i.e., `list(table.columns)` ?"}}
{"actor":{"display_login":"martindurant"}}