PApostol opened a new issue, #27695:
URL: https://github.com/apache/airflow/issues/27695

   ### Description
   
   #27647 has introduced filtering for invalid schemas in Hive hook based on 
the characters `;` and `!`. I'm wondering if a more generic filtering could be 
introduced, e.g. one that adheres to the regex `^[a-z0-9_]+$`, since Hive 
schemas (and table names) can only contain alphanumeric characters and the 
character `_`.
   
   Note: since the Hive metastore [stores schemas and tables in 
lowercase](https://stackoverflow.com/questions/57181316/how-to-keep-column-names-in-camel-case-in-hive/57183048#57183048),
 checking against `^[a-z0-9_]+$` is probably better than `^[a-zA-Z0-9_]+$`.
   
   ### Use case/motivation
   
   Ensure that Hive schemas used in `apache-airflow-providers-apache-hive` 
hooks contain no invalid characters.
   
   ### Related issues
   
   _No response_
   
   ### Are you willing to submit a PR?
   
   - [X] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of 
Conduct](https://github.com/apache/airflow/blob/main/CODE_OF_CONDUCT.md)
   


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to