martin-raymond commented on issue #25749: URL: https://github.com/apache/superset/issues/25749#issuecomment-1781806269
@zhaoyongjie we tried to use a calculated column as you said superset seems to not be able to display the result from pinot. here are the logs when we try to create a chart : ``` 10.42.9.0 - - [26/Oct/2023:19:47:43 +0000] "GET /api/v1/me/ HTTP/1.1" 200 150 "https://superset.knada.rancher.kosmos.fr/explore/?form_data_key=BjW4HfY8NeJzcurrBzb6L16PZtorS2K4FnVzTPuFXrk6Pfk0YUH1mQOFAuNUK4jc&datasource_type=table&datasource_id=54"; "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/116.0.0.0 Safari/537.36" 2023-10-26 19:47:45,016:INFO:pinotdb.sqlalchemy:Updated pinot dialect args from {'debug': False}: None and False 2023-10-26 19:47:45,038:INFO:pinotdb.sqlalchemy:Updated pinot dialect args from {'dbapi': <module 'pinotdb' from '/usr/local/lib/python3.9/site-packages/pinotdb/__init__.py'>, 'compiler_linting': 1, 'debug': False}: None and False 2023-10-26 19:47:45,038:INFO:pinotdb.sqlalchemy:Updated pinot dialect args from {'host': 'pinot-broker.pinot.svc.cluster.local', 'port': 8099, 'path': 'query/sql', 'scheme': 'http', 'username': None, 'password': None, 'debug': False}: http://pinot-controller.pinot.svc.cluster.local:9000 and False 2023-10-26 19:47:45,062:INFO:pinotdb.sqlalchemy:Updated pinot dialect args from {'dbapi': <module 'pinotdb' from '/usr/local/lib/python3.9/site-packages/pinotdb/__init__.py'>, 'compiler_linting': 1, 'debug': False}: None and False 2023-10-26 19:47:45,062:INFO:pinotdb.sqlalchemy:Updated pinot dialect args from {'host': 'pinot-broker.pinot.svc.cluster.local', 'port': 8099, 'path': 'query/sql', 'scheme': 'http', 'username': None, 'password': None, 'debug': False}: http://pinot-controller.pinot.svc.cluster.local:9000 and False 2023-10-26 19:47:45,066:INFO:pinotdb.sqlalchemy:Updated pinot dialect args from {'dbapi': <module 'pinotdb' from '/usr/local/lib/python3.9/site-packages/pinotdb/__init__.py'>, 'compiler_linting': 1, 'debug': False}: None and False 2023-10-26 19:47:45,066:INFO:pinotdb.sqlalchemy:Updated pinot dialect args from {'host': 'pinot-broker.pinot.svc.cluster.local', 'port': 8099, 'path': 'query/sql', 'scheme': 'http', 'username': None, 'password': None, 'debug': False}: http://pinot-controller.pinot.svc.cluster.local:9000 and False 2023-10-26 19:47:45,072:DEBUG:urllib3.connectionpool:Starting new HTTP connection (1): pinot-broker.pinot.svc.cluster.local:8099 2023-10-26 19:47:45,114:DEBUG:urllib3.connectionpool:http://pinot-broker.pinot.svc.cluster.local:8099 "POST /query/sql HTTP/1.1" 200 3744 2023-10-26 19:47:45,115:DEBUG:pinotdb.db:Got the rows as a type <class 'list'> of size 84 2023-10-26 19:47:45,116:DEBUG:pinotdb.db:[['2023-06-08 00:00:00.0', 443], ['2023-03-22 00:00:00.0', 101], ['2023-10-06 00:00:00.0', 82], ['2023-06-27 00:00:00.0', 80], ['2023-03-09 00:00:00.0', 78], ['2023-06-28 00:00:00.0', 78], ['2023-03-24 00:00:00.0', 74], ['2023-05-02 00:00:00.0', 69], ['2023-04-19 00:00:00.0', 69], ['2023-03-23 00:00:00.0', 65], ['2023-03-28 00:00:00.0', 62], ['2023-03-21 00:00:00.0', 61], ['2023-04-05 00:00:00.0', 58], ['2023-06-26 00:00:00.0', 58], ['2023-06-15 00:00:00.0', 58], ['2023-02-28 00:00:00.0', 56], ['2023-02-27 00:00:00.0', 55], ['2023-06-06 00:00:00.0', 53], ['2023-03-10 00:00:00.0', 52], ['2023-05-09 00:00:00.0', 51], ['2023-06-16 00:00:00.0', 50], ['2023-04-21 00:00:00.0', 49], ['2023-06-14 00:00:00.0', 48], ['2023-06-30 00:00:00.0', 48], ['2023-04-11 00:00:00.0', 48], ['2023-05-10 00:00:00.0', 48], ['2023-08-30 00:00:00.0', 47], ['2023-03-27 00:00:00.0', 46], ['2023-05-03 00:00:00.0', 45], ['2023-03-13 00:00:00.0', 44], ['2023-03-30 00:00:00.0', 44], ['2023-05-04 00:00:00.0', 42], ['2023-06-02 00:00:00.0', 42], ['2023-09-18 00:00:00.0', 41], ['2023-03-16 00:00:00.0', 38], ['2023-05-05 00:00:00.0', 38], ['2023-06-13 00:00:00.0', 38], ['2023-05-12 00:00:00.0', 38], ['2023-03-15 00:00:00.0', 36], ['2023-04-03 00:00:00.0', 36], ['2023-03-01 00:00:00.0', 36], ['2023-04-12 00:00:00.0', 36], ['2023-03-20 00:00:00.0', 36], ['2023-04-18 00:00:00.0', 34], ['2023-03-14 00:00:00.0', 34], ['2023-04-04 00:00:00.0', 33], ['2023-03-07 00:00:00.0', 33], ['2023-06-07 00:00:00.0', 31], ['2023-03-02 00:00:00.0', 31], ['2023-06-21 00:00:00.0', 31], ['2023-03-31 00:00:00.0', 30], ['2023-04-07 00:00:00.0', 29], ['2023-08-29 00:00:00.0', 29], ['2023-06-19 00:00:00.0', 28], ['2023-05-31 00:00:00.0', 27], ['2023-05-11 00:00:00.0', 26], ['2023-06-20 00:00:00.0', 26], ['2023-04-06 00:00:00.0', 25], ['2023-06-05 00:00:00.0', 25], ['2023-06-01 00:00:00.0', 24], ['2023-09-20 00:00:00.0', 23], ['2023-03-17 00:00:00.0', 23], ['2023-09-19 00:00:00.0', 22], ['2023-07-03 00:00:00.0', 22], ['2023-06-22 00:00:00.0', 22], ['2023-03-29 00:00:00.0', 21], ['2023-04-25 00:00:00.0', 20], ['2023-04-28 00:00:00.0', 18], ['2023-04-27 00:00:00.0', 17], ['2023-04-26 00:00:00.0', 17], ['2023-03-08 00:00:00.0', 16], ['2023-05-08 00:00:00.0', 13], ['2023-04-20 00:00:00.0', 12], ['2023-05-01 00:00:00.0', 10], ['2023-02-24 00:00:00.0', 8], ['2023-04-24 00:00:00.0', 8], ['2023-09-12 00:00:00.0', 7], ['2023-04-17 00:00:00.0', 7], ['2023-06-29 00:00:00.0', 6], ['2023-08-31 00:00:00.0', 4], ['2023-10-05 00:00:00.0', 2], ['2023-09-11 00:00:00.0', 1], ['2023-05-30 00:00:00.0', 1], ['2023-08-28 00:00:00.0', 1]] 10.42.9.0 - - [26/Oct/2023:19:47:45 +0000] "POST /api/v1/chart/data?force HTTP/1.1" 200 472 "https://superset.knada.rancher.kosmos.fr/explore/?form_data_key=BjW4HfY8NeJzcurrBzb6L16PZtorS2K4FnVzTPuFXrk6Pfk0YUH1mQOFAuNUK4jc&datasource_type=table&datasource_id=54"; "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/116.0.0.0 Safari/537.36" 10.42.9.0 - - [26/Oct/2023:19:47:46 +0000] "PUT /api/v1/explore/form_data/BjW4HfY8NeJzcurrBzb6L16PZtorS2K4FnVzTPuFXrk6Pfk0YUH1mQOFAuNUK4jc?tab_id=63 HTTP/1.1" 200 75 "https://superset.knada.rancher.kosmos.fr/explore/?form_data_key=BjW4HfY8NeJzcurrBzb6L16PZtorS2K4FnVzTPuFXrk6Pfk0YUH1mQOFAuNUK4jc&datasource_type=table&datasource_id=54"; "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/116.0.0.0 Safari/537.36" 10.42.9.0 - - [26/Oct/2023:19:47:46 +0000] "POST /superset/log/?explode=events&dashboard_id=1 HTTP/1.1" 200 1 "https://superset.knada.rancher.kosmos.fr/explore/?form_data_key=BjW4HfY8NeJzcurrBzb6L16PZtorS2K4FnVzTPuFXrk6Pfk0YUH1mQOFAuNUK4jc&datasource_type=table&datasource_id=54"; "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/116.0.0.0 Safari/537.36" ``` The calculated column :   (we tried DATETIME and STRING, same result) There is no error, just nothing is displayed in superset (no result) -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
