You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "antonio-tg (via GitHub)" <gi...@apache.org> on 2023/03/01 19:04:05 UTC
[GitHub] [superset] antonio-tg opened a new issue, #23254: Databricks equal issue
antonio-tg opened a new issue, #23254:
URL: https://github.com/apache/superset/issues/23254
I'm trying to execute a query to databricks, but when I execute the query I get this.
#### How to reproduce the bug
1. Install databricks-dbapi[hive]==0.6.0.
2. Add conection to databricks+pyhive://user:pass@host:port/base?http_path=http_path.
3. Go to sql_lab.
4. Execute a query with equal simbol "=".
### Expected results
Get a table.
### Actual results
Database error
databricks error: Couldn't find log associated with operation handle: OperationHandle [opType=EXECUTE_STATEMENT, getHandleIdentifier()=c621b74d-718d-4b4c-af73-50983e955414]
The logs say:
superset_app | 2023-03-01 18:44:55,360:DEBUG:superset.sql_lab:Query 156288: TFetchResultsResp(status=TStatus(statusCode=3, infoMessages=["*org.apache.hive.service.cli.HiveSQLException:Couldn't find $
og associated with operation handle: OperationHandle [opType=EXECUTE_STATEMENT, getHandleIdentifier()=96a3e43a-a763-4198-ba9d-01c64cb5fd90]:112:111", 'org.apache.hive.service.cli.operation.OperationManager:getO$
erationLogRowSet:OperationManager.java:285', 'org.apache.hive.service.cli.session.HiveSessionImpl:fetchResults:HiveSessionImpl.java:907', 'org.apache.hive.service.cli.CLIService:fetchResults:CLIService.java:587$
, 'org.apache.hive.service.cli.thrift.OSSTCLIServiceIface:FetchResults:ThriftCLIService.java:1278', 'com.databricks.sql.hive.thriftserver.thrift.DelegatingThriftHandler:FetchResults:DelegatingThriftHandler.scal$
:99', 'com.databricks.sql.hive.thriftserver.thrift.DelegatingThriftHandler:FetchResults$:DelegatingThriftHandler.scala:98', 'com.databricks.sql.hive.thriftserver.thrift.QueryRejectionThriftHandler:FetchResults:$
ueryRejectionThriftHandler.scala:30', 'com.databricks.sql.hive.thriftserver.thrift.DelegatingThriftHandler:FetchResults:DelegatingThriftHandler.scala:99', 'com.databricks.sql.hive.thriftserver.thrift.Delegating$
hriftHandler:FetchResults$:DelegatingThriftHandler.scala:98', 'com.databricks.sql.hive.thriftserver.thrift.SQLGatewaySessionConfThriftHandler:FetchResults:SQLGatewaySessionConfThriftHandler.scala:40', 'com.data$
ricks.sql.hive.thriftserver.thrift.DelegatingThriftHandler:FetchResults:DelegatingThriftHandler.scala:99', 'com.databricks.sql.hive.thriftserver.thrift.DelegatingThriftHandler:FetchResults$:DelegatingThriftHand$
er.scala:98', 'com.databricks.sql.hive.thriftserver.thrift.SQLGatewaySessionStateThriftHandler:FetchResults:SQLGatewaySessionStateThriftHandler.scala:49', 'com.databricks.sql.hive.thriftserver.thrift.Delegating$
hriftHandler:FetchResults:DelegatingThriftHandler.scala:99', 'com.databricks.sql.hive.thriftserver.thrift.DelegatingThriftHandler:FetchResults$:DelegatingThriftHandler.scala:98', 'com.databricks.sql.hive.thrift$
erver.thrift.FetchProtocolThriftHandler:FetchResults:FetchProtocolThriftHandler.scala:36', 'com.databricks.sql.hive.thriftserver.thrift.DelegatingThriftHandler:FetchResults:DelegatingThriftHandler.scala:99', 'c$
m.databricks.sql.hive.thriftserver.thrift.DelegatingThriftHandler:FetchResults$:DelegatingThriftHandler.scala:98', 'com.databricks.sql.hive.thriftserver.thrift.GetResultSetMetadataThriftHandler:FetchResults:Get$
esultSetMetadataThriftHandler.scala:26', 'com.databricks.sql.hive.thriftserver.thrift.DelegatingThriftHandler:FetchResults:DelegatingThriftHandler.scala:99', 'com.databricks.sql.hive.thriftserver.thrift.Delegat$
ngThriftHandler:FetchResults$:DelegatingThriftHandler.scala:98', 'com.databricks.sql.hive.thriftserver.thrift.InitialNamespaceThriftHandler:FetchResults:InitialNamespaceThriftHandler.scala:33', 'com.databricks.$
ql.hive.thriftserver.thrift.DelegatingThriftHandler:FetchResults:DelegatingThriftHandler.scala:99', 'com.databricks.sql.hive.thriftserver.thrift.DelegatingThriftHandler:FetchResults$:DelegatingThriftHandler.sca$
a:98', 'com.databricks.sql.hive.thriftserver.thrift.SessionCapabilitiesHandler:FetchResults:SessionCapabilitiesHandler.scala:27', 'com.databricks.sql.hive.thriftserver.thrift.DelegatingThriftHandler:FetchResult$
:DelegatingThriftHandler.scala:99', 'com.databricks.sql.hive.thriftserver.thrift.DelegatingThriftHandler:FetchResults$:DelegatingThriftHandler.scala:98', 'com.databricks.sql.hive.thriftserver.thrift.AsyncMetada$
aOperationsThriftHandler:FetchResults:AsyncMetadataOperationsThriftHandler.scala:26', 'com.databricks.sql.hive.thriftserver.thrift.DelegatingThriftHandler:FetchResults:DelegatingThriftHandler.scala:99', 'com.da$
abricks.sql.hive.thriftserver.thrift.DelegatingThriftHandler:FetchResults$:DelegatingThriftHandler.scala:98', 'com.databricks.sql.hive.thriftserver.thrift.GetInfoInOpenSessionThriftHandler:FetchResults:GetInfoI$
OpenSessionThriftHandler.scala:36', 'com.databricks.sql.hive.thriftserver.thrift.ResultSetMetadataInFetchResultsThriftHandler:FetchResults:ResultSetMetadataInFetchResultsThriftHandler.scala:31', 'com.databricks$
sql.hive.thriftserver.thrift.DelegatingThriftHandler:FetchResults:DelegatingThriftHandler.scala:99', 'com.databricks.sql.hive.thriftserver.thrift.DelegatingThriftHandler:FetchResults$:DelegatingThriftHandler.sc$
la:98', 'com.databricks.sql.hive.thriftserver.thrift.DirectResultsThriftHandler:FetchResults:DirectResultsThriftHandler.scala:53', 'com.databricks.sql.hive.thriftserver.thrift.DelegatingThriftHandler:FetchResul$
s:DelegatingThriftHandler.scala:99', 'com.databricks.sql.hive.thriftserver.thrift.DelegatingThriftHandler:FetchResults$:DelegatingThriftHandler.scala:98', 'com.databricks.sql.hive.thriftserver.thrift.ProtocolVe$
sionThriftHandler:FetchResults:ProtocolVersionThriftHandler.scala:29', 'com.databricks.sql.hive.thriftserver.thrift.DelegatingThriftHandler:FetchResults:DelegatingThriftHandler.scala:99', 'com.databricks.sql.hi$
e.thriftserver.thrift.DelegatingThriftHandler:FetchResults$:DelegatingThriftHandler.scala:98', 'com.databricks.sql.hive.thriftserver.thrift.FilterJDBCStatementBlockListThriftHandler:FetchResults:FilterJDBCState$
entBlockListThriftHandler.scala:29', 'com.databricks.sql.hive.thriftserver.thrift.DelegatingThriftHandler:FetchResults:DelegatingThriftHandler.scala:99', 'com.databricks.sql.hive.thriftserver.thrift.DelegatingT$
riftHandler:FetchResults$:DelegatingThriftHandler.scala:98', 'com.databricks.sql.hive.thriftserver.thrift.LocalPropertiesThriftHandler:super$FetchResults:LocalPropertiesThriftHandler.scala:210', 'com.databricks$
sql.hive.thriftserver.thrift.LocalPropertiesThriftHandler:$anonfun$FetchResults$1:LocalPropertiesThriftHandler.scala:210', 'org.apache.spark.sql.hive.thriftserver.ThriftLocalProperties:withLocalProperties:Thrif$
LocalProperties.scala:123', 'org.apache.spark.sql.hive.thriftserver.ThriftLocalProperties:withLocalProperties$:ThriftLocalProperties.scala:48', 'com.databricks.sql.hive.thriftserver.thrift.LocalPropertiesThrift$
andler:withLocalProperties:LocalPropertiesThriftHandler.scala:30', 'com.databricks.sql.hive.thriftserver.thrift.LocalPropertiesThriftHandler:FetchResults:LocalPropertiesThriftHandler.scala:210', 'com.databricks$
sql.hive.thriftserver.thrift.DelegatingThriftHandler:FetchResults:DelegatingThriftHandler.scala:99', 'com.databricks.sql.hive.thriftserver.thrift.DelegatingThriftHandler:FetchResults$:DelegatingThriftHandler.sc$
la:98', 'com.databricks.sql.hive.thriftserver.thrift.SetNextOperationIdThriftHandler:FetchResults:SetNextOperationIdThriftHandler.scala:37', 'com.databricks.sql.hive.thriftserver.thrift.DelegatingThriftHandler:F
etchResults:DelegatingThriftHandler.scala:99', 'com.databricks.sql.hive.thriftserver.thrift.DelegatingThriftHandler:FetchResults$:DelegatingThriftHandler.scala:98', 'com.databricks.sql.hive.thriftserver.thrift.S
etSessionHandleProtocolVersionThriftHandler:FetchResults:SetSessionHandleProtocolVersionThriftHandler.scala:43', 'com.databricks.sql.hive.thriftserver.thrift.DelegatingThriftHandler:FetchResults:DelegatingThrift
Handler.scala:99', 'com.databricks.sql.hive.thriftserver.thrift.DelegatingThriftHandler:FetchResults$:DelegatingThriftHandler.scala:98', 'com.databricks.sql.hive.thriftserver.thrift.ThreadLocalContextThriftHandl
er:super$FetchResults:ThreadLocalContextThriftHandler.scala:106', 'com.databricks.sql.hive.thriftserver.thrift.ThreadLocalContextThriftHandler:$anonfun$FetchResults$1:ThreadLocalContextThriftHandler.scala:106',
'com.databricks.sql.hive.thriftserver.thrift.ThreadLocalContextThriftHandler:createThriftThreadLocalContext:ThreadLocalContextThriftHandler.scala:45', 'com.databricks.sql.hive.thriftserver.thrift.ThreadLocalCont
extThriftHandler:FetchResults:ThreadLocalContextThriftHandler.scala:106', 'com.databricks.sql.hive.thriftserver.thrift.DelegatingThriftHandler:FetchResults:DelegatingThriftHandler.scala:99', 'com.databricks.sql.
hive.thriftserver.thrift.DelegatingThriftHandler:FetchResults$:DelegatingThriftHandler.scala:98', 'com.databricks.sql.hive.thriftserver.thrift.ErrorPropagationThriftHandler:super$FetchResults:ErrorPropagationThr
iftHandler.scala:109', 'com.databricks.sql.hive.thriftserver.thrift.ErrorPropagationThriftHandler:$anonfun$FetchResults$1:ErrorPropagationThriftHandler.scala:109', 'com.databricks.sql.hive.thriftserver.thrift.Er
rorPropagationThriftHandler:runSafely:ErrorPropagationThriftHandler.scala:119', 'com.databricks.sql.hive.thriftserver.thrift.ErrorPropagationThriftHandler:FetchResults:ErrorPropagationThriftHandler.scala:109', '
org.apache.hive.service.cli.thrift.ThriftCLIService:FetchResults:ThriftCLIService.java:744', 'org.apache.hive.service.rpc.thrift.TCLIService$Processor$FetchResults:getResult:TCLIService.java:1717', 'org.apache.h
ive.service.rpc.thrift.TCLIService$Processor$FetchResults:getResult:TCLIService.java:1702', 'org.apache.thrift.ProcessFunction:process:ProcessFunction.java:38', 'org.apache.thrift.TBaseProcessor:process:TBasePro
cessor.java:39', 'org.apache.thrift.server.TServlet:doPost:TServlet.java:83', 'org.apache.hive.service.cli.thrift.ThriftHttpServlet:doPost:ThriftHttpServlet.java:95', 'javax.servlet.http.HttpServlet:service:Http
Servlet.java:523', 'javax.servlet.http.HttpServlet:service:HttpServlet.java:590', 'org.eclipse.jetty.servlet.ServletHolder:handle:ServletHolder.java:799', 'org.eclipse.jetty.servlet.ServletHandler:doHandle:Servl
etHandler.java:550', 'org.eclipse.jetty.server.handler.ScopedHandler:handle:ScopedHandler.java:143', 'org.eclipse.jetty.security.SecurityHandler:handle:SecurityHandler.java:602', 'org.eclipse.jetty.server.handle
r.HandlerWrapper:handle:HandlerWrapper.java:127', 'org.eclipse.jetty.server.handler.ScopedHandler:nextHandle:ScopedHandler.java:235', 'org.eclipse.jetty.server.session.SessionHandler:doHandle:SessionHandler.java
:1624', 'org.eclipse.jetty.server.handler.ScopedHandler:nextHandle:ScopedHandler.java:233', 'org.eclipse.jetty.server.handler.ContextHandler:doHandle:ContextHandler.java:1434', 'org.eclipse.jetty.server.handler.
ScopedHandler:nextScope:ScopedHandler.java:188', 'org.eclipse.jetty.servlet.ServletHandler:doScope:ServletHandler.java:501', 'org.eclipse.jetty.server.session.SessionHandler:doScope:SessionHandler.java:1594', 'o
rg.eclipse.jetty.server.handler.ScopedHandler:nextScope:ScopedHandler.java:186', 'org.eclipse.jetty.server.handler.ContextHandler:doScope:ContextHandler.java:1349', 'org.eclipse.jetty.server.handler.ScopedHandle
r:handle:ScopedHandler.java:141', 'org.eclipse.jetty.server.handler.HandlerWrapper:handle:HandlerWrapper.java:127', 'org.eclipse.jetty.server.Server:handle:Server.java:516', 'org.eclipse.jetty.server.HttpChannel
:lambda$handle$1:HttpChannel.java:388', 'org.eclipse.jetty.server.HttpChannel:dispatch:HttpChannel.java:633', 'org.eclipse.jetty.server.HttpChannel:handle:HttpChannel.java:380', 'org.eclipse.jetty.server.HttpCon
nection:onFillable:HttpConnection.java:277', 'org.eclipse.jetty.io.AbstractConnection$ReadCallback:succeeded:AbstractConnection.java:311', 'org.eclipse.jetty.io.FillInterest:fillable:FillInterest.java:105', 'org
.eclipse.jetty.io.ssl.SslConnection$DecryptedEndPoint:onFillable:SslConnection.java:555', 'org.eclipse.jetty.io.ssl.SslConnection:onFillable:SslConnection.java:410', 'org.eclipse.jetty.io.ssl.SslConnection$2:suc
ceeded:SslConnection.java:164', 'org.eclipse.jetty.io.FillInterest:fillable:FillInterest.java:105', 'org.eclipse.jetty.io.ChannelEndPoint$1:run:ChannelEndPoint.java:104', 'org.eclipse.jetty.util.thread.strategy.
EatWhatYouKill:runTask:EatWhatYouKill.java:338', 'org.eclipse.jetty.util.thread.strategy.EatWhatYouKill:doProduce:EatWhatYouKill.java:315', 'org.eclipse.jetty.util.thread.strategy.EatWhatYouKill:tryProduce:EatWh
atYouKill.java:173', 'org.eclipse.jetty.util.thread.strategy.EatWhatYouKill:run:EatWhatYouKill.java:131', 'org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread:run:ReservedThreadExecutor.java:386'
, 'java.util.concurrent.ThreadPoolExecutor:runWorker:ThreadPoolExecutor.java:1149', 'java.util.concurrent.ThreadPoolExecutor$Worker:run:ThreadPoolExecutor.java:624', 'java.lang.Thread:run:Thread.java:750'], sqlS
tate='08000', errorCode=0, errorMessage="Couldn't find log associated with operation handle: OperationHandle [opType=EXECUTE_STATEMENT, getHandleIdentifier()=96a3e43a-a763-4198-ba9d-01c64cb5fd90]"), hasMoreRows=
None, results=None)
#### Screenshots
### Environment
(please complete the following information):
- browser type and version: google chrome 109.0.5414.120
- superset version: 0.999.0dev
- python version:: 3.7.9
- node.js version: v14.16.0
- any feature flags active:
### Checklist
Make sure to follow these steps before submitting your issue - thank you!
- [] I have checked the superset logs for python stacktraces and included it here as text if there are any.
- [ ] I have reproduced the issue with at least the latest released version of superset.
- [] I have checked the issue tracker for the same issue and I haven't found one similar.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Databricks equal issue [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas closed issue #23254: Databricks equal issue
URL: https://github.com/apache/superset/issues/23254
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Databricks equal issue [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #23254:
URL: https://github.com/apache/superset/issues/23254#issuecomment-1957604006
Closing this as stale since it's been silent for so long, and we're trying to steer toward a more actionable Issues backlog. If people are still encountering this in current versions (currently 3.x) please re-open this issue, open a new Issue with updated context, or raise a PR to address the problem. Thanks!
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org