[GitHub] [doris] dutyu commented on pull request #18815: [Feature](multi-catalog) support query hive views.

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

dutyu commented on PR #18815:
URL: https://github.com/apache/doris/pull/18815#issuecomment-1514350277

   > > But if the ddl of hive views use some complicated or incompatible grammar, the query might fail.
   > 
   > Could you list the specific area of influence?
   Sorry i can not enumerate all fail scenes but i can give an example, if the hive view's definition like this 
   ```CREATE VIEW `test.tbl_test_v` AS select sha(`lh_test`.`number`), `lh_test`.`k1`, `lh_test`.`k2`, `lh_test`.`k3`, `lh_test`.`k4` from `test`.`lh_test`
   ```, when we create a hive catalog named `hive_ctl` and submit a query like this ```select * from hive_ctl.test.tbl_test_v```,  this query will fail and you can see some message like this: ```
   MySQL [test_d]> select * from hive_ctl.test.tbl_test_v;
   ERROR 1105 (HY000): errCode = 2, detailMessage = No matching function with signature: sha(decimal(18, 7)).
   ```.
   Above all, a query with hive view will be failed including but not limited to these scenes, **but other queries are not affected.** :
   - ddl of hive view use some functions that doris dose not contain
   - ddl of hive view use some grammer that doris does not support
   
   


-- 
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: commits-unsubscribe@doris.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org