Re: Re: How can I know use execute or executeQuery

2021-09-15 Thread igyu
MSCK REPAIR TABLE hivetest.mytable1 I know this reason but if I ResultSet rs = st.executeQuery("msck repair table hivetest.chinese_part1"); I will get a error The query did not generate a result set! igyu From: igyu Date: 2021-09-16 08:59 To: user Subject: Re: Re: How can I know use execute

Re: Re: How can I know use execute or executeQuery

2021-09-15 Thread igyu
thanks I have a other perblem when I run "MSCK REPAIR TABLE hivetest.mytable1" I get a error Encountered: IDENTIFIER Expected: ALTER, COMMENT, COMPUTE, COPY, CREATE, DELETE, DESCRIBE, DROP, EXPLAIN, GRANT, INSERT, INVALIDATE, LOAD, REFRESH, REVOKE, SELECT, SET, SHOW, TRUNCATE, UPDATE, UPSERT

Re: How can I know use execute or executeQuery

2021-09-15 Thread Edward Capriolo
In most sql drivers.. you can always use executeQuery even if the query has no result set. On Wednesday, September 15, 2021, Alessandro Solimando < alessandro.solima...@gmail.com> wrote: > Hi Igyu, > sending different SQL statements is exactly what beeline has to handle, > I'd have a look at how

Re: How can I know use execute or executeQuery

2021-09-15 Thread Alessandro Solimando
Hi Igyu, sending different SQL statements is exactly what beeline has to handle, I'd have a look at how they handle this: https://github.com/apache/hive/tree/master/beeline (this