using presto mysql connector query doris , get the following error information in fe.audit.log:
2020-04-01 11:57:57,179 [query] |Client=172.172.210.127:31950|User=root|Db=|State=ERR|Time=1|ScanBytes=0|ScanRows=0|ReturnRows=0|StmtId=2393616|QueryId=2f105f89ce334ea2-8c097de14b7340e1|IsQuery=1|Stmt=SELECT TABLE_SCHEMA AS TABLE_CAT, NULL AS TABLE_SCHEM, TABLE_NAME, CASE WHEN TABLE_TYPE='BASE TABLE' THEN CASE WHEN TABLE_SCHEMA = 'mysql' OR TABLE_SCHEMA = 'performance_schema' THEN 'SYSTEM TABLE' ELSE 'TABLE' END WHEN TABLE_TYPE='TEMPORARY' THEN 'LOCAL_TEMPORARY' ELSE TABLE_TYPE END AS TABLE_TYPE, TABLE_COMMENT AS REMARKS, NULL AS TYPE_CAT, NULL AS TYPE_SCHEM, NULL AS TYPE_NAME, NULL AS SELF_REFERENCING_COL_NAME, NULL AS REF_GENERATION FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'monitor' AND TABLE_NAME = 'usedmem' HAVING TABLE_TYPE IN ('TABLE','VIEW',null,null,null) ORDER BY TABLE_TYPE, TABLE_SCHEMA, TABLE_NAME
presto show the following error:
presto> select * from monitor.usedMem limit 1;
Query 20200401_055715_01942_px3pp failed: 'TABLE' is not a number
if doris can by queried by presto , it will be wonderful !
2条答案
按热度按时间2cmtqfgy1#
2 issue :
1、table name 'usedMem' changes to 'usedmem'
2、HAVING TABLE_TYPE IN ('TABLE','VIEW',null,null,null) :null is the cause of the showing log :
'TABLE' is not a number
pinkon5k2#
@zzr1000 hello, can you show us the version of doris and presto you are using. I have tested querying data from doris through presto, and no errors ocurred.