ywill3 commented on issue #36939:
URL: https://github.com/apache/superset/issues/36939#issuecomment-3717542194
1. Use show tables; show databases; show create table test.will_test1 ;below
is exception in superset
starrocks error: Getting syntax error at line 1, column 12. Detail message:
Unexpected input 'LIMIT', the most similar input is {<EOF>, ';'}.
2. Use refresh external table hive.test.will_test1 ; below is exception in
superset
Unable to parse SQL
Error parsing near 'table' at line 1:22
refresh external table hive.test.will_test1
But I use these code in the same python env, it's work;
from sqlalchemy import create_engine, text
engine =
create_engine("starrocks://bigdata:ICP1VBu&[email protected]:9030/")
with engine.connect() as conn:
conn.execute(text(""" refresh external table hive.test.will_test1 ;"""))
3.Use drop table test.will_test1 FORCE; is same as refresh external table
hive.test.will_test1 ; below is exception in superset
Unable to parse SQL
Error parsing near 'FORCE' at line 1:32
drop table test.will_test1 FORCE
--
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]
