You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2020/04/16 15:06:26 UTC
[GitHub] [incubator-superset] pake2070 opened a new issue #9559:
elasticsearch connect to superset failed
pake2070 opened a new issue #9559: elasticsearch connect to superset failed
URL: https://github.com/apache/incubator-superset/issues/9559
TransportError(500, 'unresolved_exception', 'Invalid call to attribute on an unresolved object database.ID)
After using SQL lab to query data, we exported to the draw chart but got this error.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] pake2070 removed a comment on issue #9559:
elasticsearch connect to superset failed
Posted by GitBox <gi...@apache.org>.
pake2070 removed a comment on issue #9559: elasticsearch connect to superset failed
URL: https://github.com/apache/incubator-superset/issues/9559#issuecomment-614734898
2020-04-16 22:20:52,211:INFO:root:Database.get_sqla_engine(). Masked URL: elasticsearch+http://elastic:XXXXXXXXXX@localhost:9200/
2020-04-16 22:20:52,213:INFO:root:SELECT "sessionLength" AS "sessionLength", max AS max, sum("sessionLength") AS "SUM(sessionLength)"
FROM (SELECT max,
min,
sessionLength
FROM "default"."session-aggregation"
LIMIT 100) AS expr_qry
WHERE "sessionLength" IS NULL GROUP BY "sessionLength", max ORDER BY "SUM(sessionLength)" DESC
LIMIT 1000
2020-04-16 22:20:52,227:INFO:root:Database.get_sqla_engine(). Masked URL: elasticsearch+http://elastic:XXXXXXXXXX@localhost:9200/
2020-04-16 22:20:52,229:DEBUG:urllib3.connectionpool:Starting new HTTP connection (1): localhost
2020-04-16 22:20:52,242:DEBUG:urllib3.connectionpool:http://localhost:9200 "POST /_sql/ HTTP/1.1" 500 297
2020-04-16 22:20:52,242:WARNING:elasticsearch:POST http://localhost:9200/_sql/ [status:500 request:0.014s]
2020-04-16 22:20:52,243:DEBUG:elasticsearch:> {"query":"SELECT \"sessionLength\" AS \"sessionLength\",\n max AS max,\n sum(\"sessionLength\") AS \"SUM(sessionLength)\"\nFROM\n (SELECT max,\n min,\n sessionLength\n FROM \"session-aggregation\"\n LIMIT 100) AS expr_qry\nWHERE \"sessionLength\" IS NULL\nGROUP BY \"sessionLength\",\n max\nORDER BY \"SUM(sessionLength)\" DESC\nLIMIT 1000"}
2020-04-16 22:20:52,243:DEBUG:elasticsearch:< {"error":{"root_cause":[{"type":"unresolved_exception","reason":"Invalid call to attribute on an unresolved object session-aggregation.max{f}#9077 AS ?"}],"type":"unresolved_exception","reason":"Invalid call to attribute on an unresolved object session-aggregation.max{f}#9077 AS ?"},"status":500}
2020-04-16 22:20:52,243:ERROR:root:Query SELECT "sessionLength" AS "sessionLength",
max AS max,
sum("sessionLength") AS "SUM(sessionLength)"
FROM
(SELECT max,
min,
sessionLength
FROM "default"."session-aggregation"
LIMIT 100) AS expr_qry
WHERE "sessionLength" IS NULL
GROUP BY "sessionLength",
max
ORDER BY "SUM(sessionLength)" DESC
LIMIT 1000 on schema default failed
Traceback (most recent call last):
File "/usr/local/lib/python3.6/dist-packages/superset/connectors/sqla/models.py", line 947, in query
df = self.database.get_df(sql, self.schema, mutator)
File "/usr/local/lib/python3.6/dist-packages/superset/models/core.py", line 963, in get_df
self.db_engine_spec.execute(cursor, sqls[-1])
File "/usr/local/lib/python3.6/dist-packages/superset/db_engine_specs/base.py", line 754, in execute
cursor.execute(query)
File "/usr/local/lib/python3.6/dist-packages/es/baseapi.py", line 25, in g
return f(self, *args, **kwargs)
File "/usr/local/lib/python3.6/dist-packages/es/elastic/api.py", line 139, in execute
results = self.elastic_query(query)
File "/usr/local/lib/python3.6/dist-packages/es/baseapi.py", line 217, in elastic_query
resp = self.es.transport.perform_request("POST", path, body=payload)
File "/usr/local/lib/python3.6/dist-packages/elasticsearch/transport.py", line 362, in perform_request
timeout=timeout,
File "/usr/local/lib/python3.6/dist-packages/elasticsearch/connection/http_urllib3.py", line 248, in perform_request
self._raise_error(response.status, raw_data)
File "/usr/local/lib/python3.6/dist-packages/elasticsearch/connection/base.py", line 244, in _raise_error
status_code, error_message, additional_info
elasticsearch.exceptions.TransportError: TransportError(500, 'unresolved_exception', 'Invalid call to attribute on an unresolved object session-aggregation.max{f}#9077 AS ?')
2020-04-16 22:20:52,263:INFO:werkzeug:127.0.0.1 - - [16/Apr/2020 22:20:52] "POST /superset/explore_json/ HTTP/1.1" 400 -
2020-04-16 22:20:52,638:DEBUG:root:[stats_logger] (incr) queries
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] pake2070 removed a comment on issue #9559:
elasticsearch connect to superset failed
Posted by GitBox <gi...@apache.org>.
pake2070 removed a comment on issue #9559: elasticsearch connect to superset failed
URL: https://github.com/apache/incubator-superset/issues/9559#issuecomment-614725719
When we query table from elasticsearch's dataset
### **everything is ok if I load it directly:**
### **if I load via SQLlab then it failed**
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] pake2070 commented on issue #9559:
elasticsearch connect to superset failed
Posted by GitBox <gi...@apache.org>.
pake2070 commented on issue #9559: elasticsearch connect to superset failed
URL: https://github.com/apache/incubator-superset/issues/9559#issuecomment-614734898
2020-04-16 22:20:52,211:INFO:root:Database.get_sqla_engine(). Masked URL: elasticsearch+http://elastic:XXXXXXXXXX@localhost:9200/
2020-04-16 22:20:52,213:INFO:root:SELECT "sessionLength" AS "sessionLength", max AS max, sum("sessionLength") AS "SUM(sessionLength)"
FROM (SELECT max,
min,
sessionLength
FROM "default"."session-aggregation"
LIMIT 100) AS expr_qry
WHERE "sessionLength" IS NULL GROUP BY "sessionLength", max ORDER BY "SUM(sessionLength)" DESC
LIMIT 1000
2020-04-16 22:20:52,227:INFO:root:Database.get_sqla_engine(). Masked URL: elasticsearch+http://elastic:XXXXXXXXXX@localhost:9200/
2020-04-16 22:20:52,229:DEBUG:urllib3.connectionpool:Starting new HTTP connection (1): localhost
2020-04-16 22:20:52,242:DEBUG:urllib3.connectionpool:http://localhost:9200 "POST /_sql/ HTTP/1.1" 500 297
2020-04-16 22:20:52,242:WARNING:elasticsearch:POST http://localhost:9200/_sql/ [status:500 request:0.014s]
2020-04-16 22:20:52,243:DEBUG:elasticsearch:> {"query":"SELECT \"sessionLength\" AS \"sessionLength\",\n max AS max,\n sum(\"sessionLength\") AS \"SUM(sessionLength)\"\nFROM\n (SELECT max,\n min,\n sessionLength\n FROM \"session-aggregation\"\n LIMIT 100) AS expr_qry\nWHERE \"sessionLength\" IS NULL\nGROUP BY \"sessionLength\",\n max\nORDER BY \"SUM(sessionLength)\" DESC\nLIMIT 1000"}
2020-04-16 22:20:52,243:DEBUG:elasticsearch:< {"error":{"root_cause":[{"type":"unresolved_exception","reason":"Invalid call to attribute on an unresolved object session-aggregation.max{f}#9077 AS ?"}],"type":"unresolved_exception","reason":"Invalid call to attribute on an unresolved object session-aggregation.max{f}#9077 AS ?"},"status":500}
2020-04-16 22:20:52,243:ERROR:root:Query SELECT "sessionLength" AS "sessionLength",
max AS max,
sum("sessionLength") AS "SUM(sessionLength)"
FROM
(SELECT max,
min,
sessionLength
FROM "default"."session-aggregation"
LIMIT 100) AS expr_qry
WHERE "sessionLength" IS NULL
GROUP BY "sessionLength",
max
ORDER BY "SUM(sessionLength)" DESC
LIMIT 1000 on schema default failed
Traceback (most recent call last):
File "/usr/local/lib/python3.6/dist-packages/superset/connectors/sqla/models.py", line 947, in query
df = self.database.get_df(sql, self.schema, mutator)
File "/usr/local/lib/python3.6/dist-packages/superset/models/core.py", line 963, in get_df
self.db_engine_spec.execute(cursor, sqls[-1])
File "/usr/local/lib/python3.6/dist-packages/superset/db_engine_specs/base.py", line 754, in execute
cursor.execute(query)
File "/usr/local/lib/python3.6/dist-packages/es/baseapi.py", line 25, in g
return f(self, *args, **kwargs)
File "/usr/local/lib/python3.6/dist-packages/es/elastic/api.py", line 139, in execute
results = self.elastic_query(query)
File "/usr/local/lib/python3.6/dist-packages/es/baseapi.py", line 217, in elastic_query
resp = self.es.transport.perform_request("POST", path, body=payload)
File "/usr/local/lib/python3.6/dist-packages/elasticsearch/transport.py", line 362, in perform_request
timeout=timeout,
File "/usr/local/lib/python3.6/dist-packages/elasticsearch/connection/http_urllib3.py", line 248, in perform_request
self._raise_error(response.status, raw_data)
File "/usr/local/lib/python3.6/dist-packages/elasticsearch/connection/base.py", line 244, in _raise_error
status_code, error_message, additional_info
elasticsearch.exceptions.TransportError: TransportError(500, 'unresolved_exception', 'Invalid call to attribute on an unresolved object session-aggregation.max{f}#9077 AS ?')
2020-04-16 22:20:52,263:INFO:werkzeug:127.0.0.1 - - [16/Apr/2020 22:20:52] "POST /superset/explore_json/ HTTP/1.1" 400 -
2020-04-16 22:20:52,638:DEBUG:root:[stats_logger] (incr) queries
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] pake2070 edited a comment on issue #9559:
elasticsearch connect to superset failed
Posted by GitBox <gi...@apache.org>.
pake2070 edited a comment on issue #9559: elasticsearch connect to superset failed
URL: https://github.com/apache/incubator-superset/issues/9559#issuecomment-614725719
When we query table from elasticsearch's dataset
**everything is ok if I load it directly:**
**if I load via SQLlab then it failed**
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] pake2070 edited a comment on issue #9559:
elasticsearch connect to superset failed
Posted by GitBox <gi...@apache.org>.
pake2070 edited a comment on issue #9559: elasticsearch connect to superset failed
URL: https://github.com/apache/incubator-superset/issues/9559#issuecomment-614725719
When we query table from elasticsearch's dataset
### **everything is ok if I load it directly:**
### **if I load via SQLlab then it failed**
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] pake2070 commented on issue #9559:
elasticsearch connect to superset failed
Posted by GitBox <gi...@apache.org>.
pake2070 commented on issue #9559: elasticsearch connect to superset failed
URL: https://github.com/apache/incubator-superset/issues/9559#issuecomment-614725719
**everything is ok if I load it directly:**
**if I load via SQLlab then it failed**
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [incubator-superset] hungphamvn commented on issue #9559: elasticsearch connect to superset failed
Posted by GitBox <gi...@apache.org>.
hungphamvn commented on issue #9559:
URL: https://github.com/apache/incubator-superset/issues/9559#issuecomment-617531635
Our team also got this issue too, any help?
----------------------------------------------------------------
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.
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
[GitHub] [incubator-superset] stale[bot] closed issue #9559: elasticsearch connect to superset failed
Posted by GitBox <gi...@apache.org>.
stale[bot] closed issue #9559:
URL: https://github.com/apache/incubator-superset/issues/9559
----------------------------------------------------------------
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.
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
[GitHub] [incubator-superset] willbarrett commented on issue #9559: elasticsearch connect to superset failed
Posted by GitBox <gi...@apache.org>.
willbarrett commented on issue #9559:
URL: https://github.com/apache/incubator-superset/issues/9559#issuecomment-649099785
@dpgaspar you're the expert here. Any thoughts?
----------------------------------------------------------------
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.
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
[GitHub] [incubator-superset] stale[bot] commented on issue #9559: elasticsearch connect to superset failed
Posted by GitBox <gi...@apache.org>.
stale[bot] commented on issue #9559:
URL: https://github.com/apache/incubator-superset/issues/9559#issuecomment-647076818
This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue `.pinned` to prevent stale bot from closing the issue.
----------------------------------------------------------------
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.
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
[GitHub] [incubator-superset] stale[bot] commented on issue #9559: elasticsearch connect to superset failed
Posted by GitBox <gi...@apache.org>.
stale[bot] commented on issue #9559:
URL: https://github.com/apache/incubator-superset/issues/9559#issuecomment-678835182
This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue `.pinned` to prevent stale bot from closing the issue.
----------------------------------------------------------------
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.
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