Gian,
Sounds exciting.
You say 'SQL-like'. Do you plan to add extensions that are not SQL, or
for certain queries to return different results than on other SQL
databases (e.g. implicitly adding joins)? It doesn't sound like you
do. In which case I'd describe your plan as 'core SQL': not everything
in SQL works, but what does work, works consistently with the
standard. That sounds like a fine plan.
For a minute I thought you were proposing to ditch the relational
algebra (Calcite's Filter, Scan, Project, Aggregate classes). I'm glad
you're keeping those. They are essential for semantic rewrites such a
materialized views, which you will need at some point. It makes sense
to find a plan, then transcribe directly to Druid's model classes.
Different people will need different engines. Some people will want
massive distributed joins, which Druid is not designed for. Since
you're using Calcite, people will be able to switch to a different
engine (say Hive or Drill) and keep the same SQL syntax and same
metadata. (The proposed Drillix[1] project - combining Apache Phoenix
and Apache Drill - follows a similar pattern. And indeed, what you are
proposing is very similar to how Phoenix is embedding Calcite.)
It sounds as if your biggest challenge is to implement the necessary
runtime for SQL (SQL types, SQL functions, and maybe one or two new
relational operators). I don't know whether it's feasible to re-use
parts of an existing engine (e.g. Calcite's or Drill's implementation
of SQL operators) but even if it's not, you should re-use Calcite's
unit and system tests to help develop your engine as quickly as
possible. (I've talked for a long time about Calcite having "pluggable
engines/runtimes". Maybe it's time to add that to Calcite.)
Good luck with this, and let us know what we can do to help on the Calcite side.
Julian
--
You received this message because you are subscribed to the Google Groups "Druid Development" group.
To unsubscribe from this group and stop receiving emails from it, send an email to druid-developm...@googlegroups.com.
To post to this group, send email to druid-de...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/druid-development/582c4241-eca0-4622-81ac-3c8fde1a4f1c%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "Druid Development" group.
To unsubscribe from this group and stop receiving emails from it, send an email to druid-development+unsubscribe@googlegroups.com.
To post to this group, send email to druid-development@googlegroups.com.
Gian
To unsubscribe from this group and stop receiving emails from it, send an email to druid-developm...@googlegroups.com.
To post to this group, send email to druid-de...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/druid-development/7ff1f4d5-137f-43cd-afc7-08bd55601215%40googlegroups.com.
To unsubscribe from this group and stop receiving emails from it, send an email to druid-developm...@googlegroups.com.
To post to this group, send email to druid-de...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/druid-development/CACZNdYBeOqb-empxO9jigVsCnCtuo8e1ngpD9zJR9LAq%3DLjgwA%40mail.gmail.com.
Gian
To unsubscribe from this group and stop receiving emails from it, send an email to druid-developm...@googlegroups.com.
To post to this group, send email to druid-de...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/druid-development/CACZNdYBeOqb-empxO9jigVsCnCtuo8e1ngpD9zJR9LAq%3DLjgwA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups "Druid Development" group.
To unsubscribe from this group and stop receiving emails from it, send an email to druid-development+unsubscribe@googlegroups.com.
To post to this group, send email to druid-development@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/druid-development/5FF5E050-CF62-49C0-95B2-76F375B0301E%40apache.org.
CONFIDENTIALITY NOTICE
NOTICE: This message is intended for the use of the individual or entity to which it is addressed and may contain information that is confidential, privileged and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, you are hereby notified that any printing, copying, dissemination, distribution, disclosure or forwarding of this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately and delete it from your system. Thank You.
--
You received this message because you are subscribed to the Google Groups "Druid Development" group.
To unsubscribe from this group and stop receiving emails from it, send an email to druid-development+unsubscribe@googlegroups.com.
To post to this group, send email to druid-development@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/druid-development/4bfbe22f-2d65-4d0e-b0e0-c002bf24e7e4%40googlegroups.com.
Gian
--
You received this message because you are subscribed to the Google Groups "Druid Development" group.
To unsubscribe from this group and stop receiving emails from it, send an email to druid-development+unsubscribe@googlegroups.com.
To post to this group, send email to druid-development@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/druid-development/ef8cb3e1-0b57-46f0-a5ee-357b45483bde%40googlegroups.com.
To unsubscribe from this group and stop receiving emails from it, send an email to druid-developm...@googlegroups.com.
To post to this group, send email to druid-de...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/druid-development/ef8cb3e1-0b57-46f0-a5ee-357b45483bde%40googlegroups.com.
--
You received this message because you are subscribed to a topic in the Google Groups "Druid Development" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/druid-development/3npt9Qxpjr0/unsubscribe.
To unsubscribe from this group and all its topics, send an email to druid-developm...@googlegroups.com.
To post to this group, send email to druid-de...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/druid-development/CACZNdYBFBo-43JnAmhStky804MHBr0VUL%2BJaZzoTUW4h8t%2Bykg%40mail.gmail.com.
--
You received this message because you are subscribed to the Google Groups "Druid Development" group.
To unsubscribe from this group and stop receiving emails from it, send an email to druid-development+unsubscribe@googlegroups.com.
To post to this group, send email to druid-development@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/druid-development/582c4241-eca0-4622-81ac-3c8fde1a4f1c%40googlegroups.com.
--
You received this message because you are subscribed to the Google Groups "Druid Development" group.
To unsubscribe from this group and stop receiving emails from it, send an email to druid-development+unsubscribe@googlegroups.com.
To post to this group, send email to druid-development@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/druid-development/A648C83C-1B42-43CB-B063-197B3854A5E9%40apache.org.
Hello
--
You received this message because you are subscribed to the Google Groups "Druid Development" group.
To unsubscribe from this group and stop receiving emails from it, send an email to druid-development+unsubscribe@googlegroups.com.
To post to this group, send email to druid-development@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/druid-development/11f22733-2947-4b6d-99c4-9187e073deb5%40googlegroups.com.
Try adding druid.sql.enable=true to your runtime properties.
Gian
On Sun, Aug 20, 2017 at 11:35 PM, <sreehar...@gmail.com> wrote:
HelloJust help me out in Sql using http whenever i used verbose it is showing 405 method not allowedProblem :curl -XPOST -H'Content-Type: application/json' http://localhost:8082/druid/v2/sql/ -d '{"query":"SELECT COUNT(*) FROM wikiticker"}' -vConnected to localhost (127.0.0.1) port 8082 (#0)> POST /druid/v2/sql/ HTTP/1.1> User-Agent: curl/7.35.0> Host: localhost:8082> Accept: */*> Content-Type: application/json> Content-Length: 75>* upload completely sent off: 75 out of 75 bytes< HTTP/1.1 405 Method Not Allowed< Date: Mon, 21 Aug 2017 06:32:59 GMT< Allow: DELETE,OPTIONS< Content-Length: 0* Server Jetty(9.3.16.v20170120) is not blacklisted< Server: Jetty(9.3.16.v20170120)<
--
You received this message because you are subscribed to the Google Groups "Druid Development" group.
To unsubscribe from this group and stop receiving emails from it, send an email to druid-developm...@googlegroups.com.
To post to this group, send email to druid-de...@googlegroups.com.
--
You received this message because you are subscribed to the Google Groups "Druid Development" group.
To unsubscribe from this group and stop receiving emails from it, send an email to druid-development+unsubscribe@googlegroups.com.
To post to this group, send email to druid-development@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/druid-development/fb7699c4-7ef8-4bad-9c34-01027c34a19c%40googlegroups.com.
Just a question, is it possible to enable logging of those native druid queries that sql translates to?I have this issue that GroubBy returns "null" instead of the split results even though it should not and I don't know whether the problem is in the SQL engine or druid.
--
You received this message because you are subscribed to the Google Groups "Druid Development" group.
To unsubscribe from this group and stop receiving emails from it, send an email to druid-development+unsubscribe@googlegroups.com.
To post to this group, send email to druid-development@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/druid-development/ef7a9d97-9c66-445f-a7fc-9669be3a1f34%40googlegroups.com.