martin-raymond commented on issue #25749:
URL: https://github.com/apache/superset/issues/25749#issuecomment-1782990469
the query :
```
SELECT CAST(DATE_TRUNC('day', CAST(cast(dateHeureDebut as timestamp) AS
TIMESTAMP)) AS TIMESTAMP),
count(*)
FROM "knada-indicateur-visite-v2"."knada-indicateur-visite-v2"
GROUP BY CAST(DATE_TRUNC('day', CAST(cast(dateHeureDebut as timestamp) AS
TIMESTAMP)) AS TIMESTAMP)
ORDER BY count(*) DESC
LIMIT 10000;
```
the logs :
```
2023-10-27 14:12:29,058:INFO:pinotdb.sqlalchemy:Updated pinot dialect args
from {'debug': False}: None and False
2023-10-27 14:12:29,078: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-27 14:12:29,078: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-27 14:12:29,090: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-27 14:12:29,090: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-27 14:12:29,093: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-27 14:12:29,094: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-27 14:12:29,096:DEBUG:urllib3.connectionpool:Starting new HTTP
connection (1): pinot-broker.pinot.svc.cluster.local:8099
2023-10-27
14:12:29,160:DEBUG:urllib3.connectionpool:http://pinot-broker.pinot.svc.cluster.local:8099
"POST /query/sql HTTP/1.1" 200 None
2023-10-27 14:12:29,175:DEBUG:pinotdb.db:Got the rows as a type <class
'list'> of size 1000
2023-10-27 14:12:29,284:DEBUG:pinotdb.db:[['Personnel',
'2023-05-31 12:03:14.082',
'Collège Aldébaran (COL - 0000000C)',
['Scolarité', "Page d'accueil personnelle"],
'1115',
'Ordinateur',
['Portail Académique', 'Portail département', 'Site inter etablissement'],
['Public'],
['Absences - tableau de bord', 'Absences', 'Accueil personnel'],
'Europe/Paris',
['Collège'],
1685534594082,
1685538574435],
['Enseignant',
'2023-05-31 12:43:46.39',
'Cite scolaire Colt et Emanche (LEG - 2486935G, COL - 8098115I)',
['Communication'],
'4817',
'Ordinateur',
['Site inter etablissement',
'Portail région',
'Portail Académique',
'Portail département'],
['Public'],
['Messagerie'],
'Europe/Paris',
["Lycée d'enseignement général", 'Collège'],
1685537026390,
1685538862566],
['Autre',
'2023-05-31 15:23:37.19',
'Collège Aldébaran (COL - 0000000C)',
["Page d'accueil personnelle"],
'1115',
'Ordinateur',
['Portail Académique', 'Portail département', 'Site inter etablissement'],
['Public'],
['Accueil personnel'],
'Europe/Paris',
['Collège'],
1685546617190,
1685548417556],
['Autre',
'2023-05-31 15:25:02.604',
'Cite scolaire Colt et Emanche (LEG - 2486935G, COL - 8098115I)',
["Page d'accueil personnelle", 'Publication'],
'4817',
'Ordinateur',
['Site inter etablissement',
'Portail région',
'Portail Académique',
'Portail département'],
['Public'],
['Accueil personnel', 'Communication ciblée'],
'Europe/Paris',
["Lycée d'enseignement général", 'Collège'],
1685546702604,
1685548505940],
['Autre',
'2023-05-31 15:33:26.236',
'Collège Aldébaran (COL - 0000000C)',
['Publication', "Page d'accueil personnelle", 'Services transverses'],
'1115',
'Ordinateur',
['Portail Académique', 'Portail département', 'Site inter etablissement'],
['Public'],
['Communication ciblée', 'Accueil personnel', 'Annuaire'],
'Europe/Paris',
['Collège'],
1685547206236,
1685550716680], .....
....
]]
2023-10-27 14:12:29,551:INFO:pinotdb.sqlalchemy:Updated pinot dialect args
from {'debug': False}: None and False
2023-10-27 14:12:29,561: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-27 14:12:29,561: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-27 14:12:29,567: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-27 14:12:29,568: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-27 14:12:29,572: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-27 14:12:29,572: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-27 14:12:29,576:DEBUG:urllib3.connectionpool:Starting new HTTP
connection (1): pinot-broker.pinot.svc.cluster.local:8099
2023-10-27
14:12:29,593:DEBUG:urllib3.connectionpool:http://pinot-broker.pinot.svc.cluster.local:8099
"POST /query/sql HTTP/1.1" 200 1218
2023-10-27 14:12:29,594:DEBUG:pinotdb.db:Got the rows as a type <class
'list'> of size 1
2023-10-27 14:12:29,594:DEBUG:pinotdb.db:[[3474]]
10.42.9.0 - - [27/Oct/2023:14:12:29 +0000] "POST
/datasource/samples?force=false&datasource_type=table&datasource_id=54
HTTP/1.1" 200 21448
"https://superset.knada.rancher.kosmos.fr/explore/?form_data_key=5f5-KbTVK-Eft9BQ2pt9PUHQkwlGyTrWv3FKA5tViwf8ED0BFocjk3VArP32EmRM&dashboard_page_id=bZXKqzeU7&slice_id=9";
"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 - - [27/Oct/2023:14:12:34 +0000] "GET /api/v1/me/ HTTP/1.1" 200
150
"https://superset.knada.rancher.kosmos.fr/explore/?form_data_key=5f5-KbTVK-Eft9BQ2pt9PUHQkwlGyTrWv3FKA5tViwf8ED0BFocjk3VArP32EmRM&dashboard_page_id=bZXKqzeU7&slice_id=9";
"Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko)
Chrome/116.0.0.0 Safari/537.36"
```
--
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-unsubscr...@superset.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org
For additional commands, e-mail: notifications-h...@superset.apache.org
