In JDBC adapter, when generating SQL for Hive, transform TRIM function to TRIM, LTRIM or RTRIM

Let's assume sql = SELECT TRIM(' str ')

When we use HiveSqlDialect and transform "sql", we expect SELECT TRIM(' str ')，but get SELECT TRIM(BOTH ' ' FROM ' str ') which is incorrect  sql format in hive.

So maybe HiveSqlDialect behavior should be changed when transform function trim:

1. SELECT TRIM(' str ')  =>  SELECT TRIM(' str ') 
2. SELECT TRIM(BOTH ' ' from ' str ') => SELECT TRIM(' str ')
3. SELECT TRIM(LEADING ' ' from ' str ') => SELECT LTRIM(' str ')
4. SELECT TRIM(TRAILING ' ' from ' str ')=>  SELECT RTRIM(' str ')