incubator-doris error while doris queried by presto

ztyzrc3y  于 2022-04-22  发布在  Java
关注(0)|答案(2)|浏览(600)

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 !

2cmtqfgy

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

pinkon5k

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.

相关问题