tag:blogger.com,1999:blog-11802292.post7968638152493377968..comments2023-10-16T03:31:20.095-07:00Comments on Catherine: pyOraGeek: %sql: To Pandas and BackAnonymoushttp://www.blogger.com/profile/12229578427522022392noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-11802292.post-55676889010343547142015-09-10T11:09:49.466-07:002015-09-10T11:09:49.466-07:00Hi Catherine,
I am using your ipython-sql to conn...Hi Catherine,<br /><br />I am using your ipython-sql to connect to impala and run queries. It works great with the following url. <br /><br />%sql impala://aws-impala-url:21050<br /><br />But, when I try to use the same statement in kerberos environment, it not working and getting below errors. Is kerberos supported in the library? If it is supported, what is the right url or right way to use it?<br /><br />TTransportException: TSocket read 0 bytes<br />ERROR:impala.hiveserver2:Failed to open transport<br /><br />StatementError: (thrift.transport.TTransport.TTransportException) TSocket read 0 bytes [SQL: u'select version()']<br /><br /><br />I appreciate your input.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-11802292.post-37811779184533742272014-11-05T09:35:55.696-08:002014-11-05T09:35:55.696-08:00Hi Catherine. I came here by having stumbled ipyth...Hi Catherine. I came here by having stumbled ipython-sql from...somewhere. I don't know; that tab's been open for weeks. Anyway, looks great. I'm wondering how you feel <a href="http://blog.yhathq.com/posts/introducing-db-py.html" rel="nofollow">Yhat's db.py</a> would compare, specifically for use in IPython notebooks. They just announced it today, so this is a bit premature, but wondered all the same.<br /><br />Additionally, by pure serendipity, I only after looking at ipython-sql and came here realized I'd seen you talk at PyOhio 2014. My wife attended PyCamp, and then we both showed up for talks that Saturday. Great work all around.<br /><br />Lastly, I had no idea there was such a thing as TRUCEConf. Now it's long over and the URL is no longer active. Do you anticipate they'll run it again next year?<br /><br />Cheers!<br /><br />DanielAnonymoushttps://www.blogger.com/profile/05481984909599672860noreply@blogger.comtag:blogger.com,1999:blog-11802292.post-91986552790541224482014-09-08T04:39:07.041-07:002014-09-08T04:39:07.041-07:00Really cool idea. Useful for many cases, when acce...Really cool idea. Useful for many cases, when accessing a datawarehouse from iPython. Thanks for sharing it.<br /><br />Just tested with our 12GB db, which holds weather and environmental data. Worked perfectly.erlebnishengsthttps://www.blogger.com/profile/00018416083765754455noreply@blogger.com