{"action":"created","issue":{"url":"https://api.github.com/repos/dropbox/PyHive/issues/35","labels_url":"https://api.github.com/repos/dropbox/PyHive/issues/35/labels{/name}","comments_url":"https://api.github.com/repos/dropbox/PyHive/issues/35/comments","events_url":"https://api.github.com/repos/dropbox/PyHive/issues/35/events","html_url":"https://github.com/dropbox/PyHive/issues/35","id":126644108,"number":35,"title":"Error doing `SELECT` operations on Hive, `show databases` works fine","user":{"login":"ispmarin","id":12247,"avatar_url":"https://avatars.githubusercontent.com/u/12247?v=3","gravatar_id":"","url":"https://api.github.com/users/ispmarin","html_url":"https://github.com/ispmarin","followers_url":"https://api.github.com/users/ispmarin/followers","following_url":"https://api.github.com/users/ispmarin/following{/other_user}","gists_url":"https://api.github.com/users/ispmarin/gists{/gist_id}","starred_url":"https://api.github.com/users/ispmarin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ispmarin/subscriptions","organizations_url":"https://api.github.com/users/ispmarin/orgs","repos_url":"https://api.github.com/users/ispmarin/repos","events_url":"https://api.github.com/users/ispmarin/events{/privacy}","received_events_url":"https://api.github.com/users/ispmarin/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":5,"created_at":"2016-01-14T12:20:06Z","updated_at":"2016-01-21T19:30:56Z","closed_at":null,"body":"I have a Hive server using Tez that I can connect correctly:\r\n\r\n    import pyhive\r\n    from pyhive import hive\r\n\r\n    cursor = hive.connect(connect_host, port=10000, configuration={'job.queue.name': 'myqueue'}).cursor()\r\n    cursor.execute('use db_20160111') # works fine\r\n    cursor.execute('show databases') # works fine\r\n    cursor.execute('SELECT cgi FROM db_20160111.useful_result') # crashes\r\n\r\nwith the following error:\r\n\r\n    OperationalError: TExecuteStatementResp(status=TStatus(errorCode=1, errorMessage='Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.TezTask', sqlState='08S01', infoMessages=['*org.apache.hive.service.cli.HiveSQLException:Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.tez.TezTask:29:28', 'org.apache.hive.service.cli.operation.Operation:toSQLException:Operation.java:314', 'org.apache.hive.service.cli.operation.SQLOperation:runQuery:SQLOperation.java:146', 'org.apache.hive.service.cli.operation.SQLOperation:runInternal:SQLOperation.java:173', 'org.apache.hive.service.cli.operation.Operation:run:Operation.java:256', 'org.apache.hive.service.cli.session.HiveSessionImpl:executeStatementInternal:HiveSessionImpl.java:376', 'org.apache.hive.service.cli.session.HiveSessionImpl:executeStatement:HiveSessionImpl.java:357', 'sun.reflect.GeneratedMethodAccessor308:invoke::-1', 'sun.reflect.DelegatingMethodAccessorImpl:invoke:DelegatingMethodAccessorImpl.java:43', 'java.lang.reflect.Method:invoke:Method.java:606', 'org.apache.hive.service.cli.session.HiveSessionProxy:invoke:HiveSessionProxy.java:79', 'org.apache.hive.service.cli.session.HiveSessionProxy:access$000:HiveSessionProxy.java:37', 'org.apache.hive.service.cli.session.HiveSessionProxy$1:run:HiveSessionProxy.java:64', 'java.security.AccessController:doPrivileged:AccessController.java:-2', 'javax.security.auth.Subject:doAs:Subject.java:415', 'org.apache.hadoop.security.UserGroupInformation:doAs:UserGroupInformation.java:1628', 'org.apache.hadoop.hive.shims.HadoopShimsSecure:doAs:HadoopShimsSecure.java:536', 'org.apache.hive.service.cli.session.HiveSessionProxy:invoke:HiveSessionProxy.java:60', 'com.sun.proxy.$Proxy23:executeStatement::-1', 'org.apache.hive.service.cli.CLIService:executeStatement:CLIService.java:234', 'org.apache.hive.service.cli.thrift.ThriftCLIService:ExecuteStatement:ThriftCLIService.java:401', 'org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement:getResult:TCLIService.java:1313', 'org.apache.hive.service.cli.thrift.TCLIService$Processor$ExecuteStatement:getResult:TCLIService.java:1298', 'org.apache.thrift.ProcessFunction:process:ProcessFunction.java:39', 'org.apache.thrift.TBaseProcessor:process:TBaseProcessor.java:39', 'org.apache.hive.service.auth.TSetIpAddressProcessor:process:TSetIpAddressProcessor.java:56', 'org.apache.thrift.server.TThreadPoolServer$WorkerProcess:run:TThreadPoolServer.java:206', 'java.util.concurrent.ThreadPoolExecutor:runWorker:ThreadPoolExecutor.java:1145', 'java.util.concurrent.ThreadPoolExecutor$Worker:run:ThreadPoolExecutor.java:615', 'java.lang.Thread:run:Thread.java:745'], statusCode=3), operationHandle=None)\r\n\r\nThanks!"},"comment":{"url":"https://api.github.com/repos/dropbox/PyHive/issues/comments/173683435","html_url":"https://github.com/dropbox/PyHive/issues/35#issuecomment-173683435","issue_url":"https://api.github.com/repos/dropbox/PyHive/issues/35","id":173683435,"user":{"login":"jingw","id":2019426,"avatar_url":"https://avatars.githubusercontent.com/u/2019426?v=3","gravatar_id":"","url":"https://api.github.com/users/jingw","html_url":"https://github.com/jingw","followers_url":"https://api.github.com/users/jingw/followers","following_url":"https://api.github.com/users/jingw/following{/other_user}","gists_url":"https://api.github.com/users/jingw/gists{/gist_id}","starred_url":"https://api.github.com/users/jingw/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jingw/subscriptions","organizations_url":"https://api.github.com/users/jingw/orgs","repos_url":"https://api.github.com/users/jingw/repos","events_url":"https://api.github.com/users/jingw/events{/privacy}","received_events_url":"https://api.github.com/users/jingw/received_events","type":"User","site_admin":false},"created_at":"2016-01-21T19:30:56Z","updated_at":"2016-01-21T19:30:56Z","body":"Could you post the full diff of the set outputs? I'm not familiar with Tez so I'm not sure what would be relevant. At this point, I'm pretty sure this is an issue with configuration rather than an issue with the client."}}