[GitHub] [hive] RobbertDM commented on pull request #4160: remove toLowerCases

["RobbertDM (via GitHub)" <gi...@apache.org>]

RobbertDM commented on PR #4160:
URL: https://github.com/apache/hive/pull/4160#issuecomment-1494417049

   Ah well, we use [trino](https://trino.io), and we have multiple databases/connectors connected to that trino, one of them being hive metastore, another being some database that supports uppercase column names, say postgres.
   
   What we do is load some tables with uppercase column names from postgres and copy them to iceberg files through hive metastore.
   
   Then, after a few days, we want to check whether our iceberg table is still up to date, so we compare it to the postgres one. We start by comparing the schemas, and notice that some `COLUMN_NAMES` are missing, and that there are some `column_names` in our hive connector that are not present anymore in postgres. Of course, they're the same, they just got cast to lowercase somewhere along the copy.
   
   Here's the issue we ran into, it's a bit more specific but the general idea is the same:
   https://github.com/dbt-labs/dbt-core/issues/7084


-- 
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: gitbox-unsubscribe@hive.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: gitbox-unsubscribe@hive.apache.org
For additional commands, e-mail: gitbox-help@hive.apache.org