druid icon indicating copy to clipboard operation
druid copied to clipboard

Native json qury runs even on non-existent druid datasource

Open v-vishwa opened this issue 5 years ago • 2 comments

Native json query runs even on non-existent druid datasource

Steps to reproduce

  1. Run a native druid JSON query on any datasource of your wish which is not present in the cluster. json_Query_on_non-existent_dataSource
  2. You would see the query runs without result, rather throwing the error ( dataSource Not found )

Druid SQL understand well and throws table/datasource not found an error .

v-vishwa avatar Apr 23 '20 12:04 v-vishwa

This seems like an intended behavior rather than a bug. In Druid, datasource can be thought as a label for segments. That means, Druid doesn't do anything with datasource, but only cares whether there are segments to query.

jihoonson avatar Apr 23 '20 17:04 jihoonson

This is by far the most annoying behavior I have encountered with druid. I can't tell you how many hours i have wasted debugging typos or other sources of bad datasource names!
Typo in one line out of hundreds in a json spec? No results. Maybe there is a validation mode? No, f-off, no results. Nothing makes me hate druid more than this overtly anti-user behavior. Not even a warning? No even "are you sure about this?" Just "no results"?!?

cswarth avatar Jul 12 '22 00:07 cswarth

This issue has been marked as stale due to 280 days of inactivity. It will be closed in 4 weeks if no further activity occurs. If this issue is still relevant, please simply write any comment. Even if closed, you can still revive the issue at any time or discuss it on the [email protected] list. Thank you for your contributions.

github-actions[bot] avatar Aug 06 '23 00:08 github-actions[bot]

This issue has been closed due to lack of activity. If you think that is incorrect, or the issue requires additional review, you can revive the issue at any time.

github-actions[bot] avatar Sep 04 '23 00:09 github-actions[bot]