easyinplay opened a new issue, #57284:
URL: https://github.com/apache/doris/issues/57284

   ### Search before asking
   
   - [x] I had searched in the 
[issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no 
similar issues.
   
   
   ### Version
   
   4.0.0
   
   ### What's Wrong?
   
   --抽取临时数据到sqlserver
   --drop CATALOG masabak_166;
   CREATE CATALOG masabak_166 PROPERTIES (
       'type' = 'jdbc',
       'user' = 'xxx',
       'password' = 'xxx',
       'jdbc_url' = 
'jdbc:sqlserver://192.168.xx.xx;databaseName=masabak;encrypt=false',
       'driver_url' = 'mssql-jdbc-12.10.1.jre11.jar',
       'driver_class' = 'com.microsoft.sqlserver.jdbc.SQLServerDriver'
   );
   
   create table masabak_166.dbo.url_to_pf_clean_20251024
   as select *
   from hive.consumer_plus_jd.review_jd_ym a
   where exists (select 1 from masabak_166.dbo.url_to_pf b where 
a.item_id=b.itemid)
   and a.ym>=202507;
   
   查询结果无法写入,报错如下:
   [2025-10-24 10:19:11] > create table masabak_166.dbo.url_to_pf_clean_20251024
                           as select *
                           from hive.consumer_plus_jd.review_jd_ym a
                           where exists (select 1 from 
masabak_166.dbo.url_to_pf b where a.item_id=b.itemid)
                           and a.ym>=202507;
                           
   [2025-10-24 10:19:11] [HY000][1105] errCode = 2, detailMessage = Current 
catalog does not support create table: masabak_166
   
   ### What You Expected?
   
   期待正常写入
   
   ### How to Reproduce?
   
   创建一个sqlserver 的catalog
   --drop CATALOG masabak_166;
   CREATE CATALOG masabak_166 PROPERTIES (
       'type' = 'jdbc',
       'user' = 'xxx',
       'password' = 'xxx',
       'jdbc_url' = 
'jdbc:sqlserver://192.168.xx.xx;databaseName=masabak;encrypt=false',
       'driver_url' = 'mssql-jdbc-12.10.1.jre11.jar',
       'driver_class' = 'com.microsoft.sqlserver.jdbc.SQLServerDriver'
   );
   
   create table masabak_166.dbo.url_to_pf_clean_20251024
   as select *
   from hive.consumer_plus_jd.review_jd_ym a
   where exists (select 1 from masabak_166.dbo.url_to_pf b where 
a.item_id=b.itemid)
   and a.ym>=202507;
   
   
   
   ### Anything Else?
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [ ] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [x] I agree to follow this project's [Code of 
Conduct](https://www.apache.org/foundation/policies/conduct)
   


-- 
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]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to