Issue querying tables of hive running metastore on derby

[vasilyev76]

Presto 0.280, Hive 3.1.3 using derby metastore.

Query - SHOW TABLES FROM hive.default;
Will get timeout and in the hive log

hive --service metastore -hiveconf hive.root.logger=DEBUG,console

Caused by: ERROR 42818: Comparisons between 'CLOB (UCS_BASIC)' and 'CLOB (UCS_BASIC)' are not supported. Types must be comparable. String types must also have matching collation. If collation does not match, a possible solution is to cast operands to force them to the default collation (e.g. SELECT tablename FROM sys.systables WHERE CAST(tablename AS VARCHAR(128)) = 'T1')

Seems to be an issue for Hive>2.3+
Also known in Trino and fixed there - trinodb/trino#951

[rohanpednekar]

@vasilyev76 Do you think you can backport and open a PR, we will get it reviewed and merged.

cc: @v-jizhang

[iq180fq200]

I ran into the same issue, how did you end up solving it?

[agrawalreetika]

This may be fixed by #24466