Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Cannot DROP or TERMINATE when names of streams, tables, queries are quoted (backticks) #2171

Closed
tkaven opened this issue Nov 20, 2018 · 6 comments

Comments

@tkaven
Copy link

tkaven commented Nov 20, 2018


Stream Name                 | Kafka Topic                 | Format 
--------------------------------------------------------------------
ks.hgame.projects.11_stream | ks.hgame.projects.11_stream | JSON   
vs.hgame.projects.1_stream  | maxwell.hgame.projects      | JSON   
vs.hgame.projects.n1_stream | maxwell.hgame.projects      | JSON   
--------------------------------------------------------------------
ksql> drop stream `vs.hgame.projects.1_stream`;
Cannot drop vs.hgame.projects.1_stream. 
The following queries read from this source: [CSAS_ks.hgame.projects.11_stream_3]. 
The following queries write into this source: []. 
You need to terminate them before dropping vs.hgame.projects.1_stream.
ksql> terminate `CSAS_ks.hgame.projects.11_stream_3`;
java.lang.Exception: No running query with id `CSAS_ks.hgame.projects.11_stream_3` was found
ksql> show queries;

Query ID                           | Kafka Topic                 | Query String                                                                                                                                                                                                                                                                                                                                                                                                                                                 
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 CSAS_ks.hgame.projects.11_stream_3 | ks.hgame.projects.11_stream | CREATE STREAM `ks.hgame.projects.11_stream` WITH (VALUE_FORMAT='JSON') AS SELECT data->`userid` AS userid, data->`iscancel` AS iscancel, data->`totalprice` AS totalprice, data->`bouns` AS bouns, data->`bonustime` AS bonustime, data->`writetime` AS writetime, data->`deducttime` AS deducttime, data->`projectid` AS projectid, data->`lotteryid` AS lotteryid, data->`methodid` AS methodid, data->`modes` AS modes FROM `vs.hgame.projects.1_stream`; 
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
For detailed information on a Query run: EXPLAIN <Query ID>;
ksql> terminate `CSAS_ks.hgame.projects.11_stream_3`;
java.lang.Exception: No running query with id `CSAS_ks.hgame.projects.11_stream_3` was found
ksql> 
@tkaven
Copy link
Author

tkaven commented Nov 21, 2018

CSAS_ks.hgame.projects.11_stream_3

cause 11 not alowd

@miguno
Copy link
Contributor

miguno commented Nov 21, 2018

@tkaven : Which version of KSQL are you using?

@tkaven
Copy link
Author

tkaven commented Nov 22, 2018

@tkaven : Which version of KSQL are you using?

version is 5.0.1

thank you

@miguno
Copy link
Contributor

miguno commented Nov 23, 2018

@big-andy-coates : I suppose this is, again, related to quoted identifiers (i.e., the use of backticks)?

@miguno miguno changed the title why running query not found, and can not terminate? Cannot DROP or TERMINATE when names of streams, tables, queries are quoted (backticks) Nov 23, 2018
@apurvam
Copy link
Contributor

apurvam commented Nov 30, 2018

Seems like a dup of #1888

@big-andy-coates big-andy-coates added this to Needs triage in Bugs Oct 25, 2019
@agavra agavra self-assigned this Oct 25, 2019
@agavra
Copy link
Contributor

agavra commented Nov 4, 2019

This issue should be fixed as of master!

@agavra agavra closed this as completed Nov 4, 2019
Bugs automation moved this from Needs triage to Closed Nov 4, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
Bugs
  
Closed
Development

No branches or pull requests

4 participants