[GitHub] yurmix opened a new issue #6771: Druid SQL: Documentation of gaps in capability

[GitBox <gi...@apache.org>]

yurmix opened a new issue #6771: Druid SQL: Documentation of gaps in capability
URL: https://github.com/apache/incubator-druid/issues/6771
 
 
   Hi,
   
   SQL is the database world's standard API for both querying, updating (DML), structural transformations (DDL) as well as even administration operations.
   [Druid SQL](http://druid.io/docs/latest/querying/sql.html) exists but it still not thoroughly covers all Druid capabilities and APIs.
   
   There is a will in the community to close this gap (@gianm recently noted about it in the dev email list).
   
   I believe it would be beneficial to document all the gaps which currently exist for Druid SQL to be in full parity with other mature, commercial analytical databases. Such documentation could promote effort by many contributors to help to close that gap.
   
   Regarding technicalities, I have some suggestions:
   1. The list should be broken down to manageable chunks so multiple contributors could participate.
   2. It would be helpful to not why SQL support is missing: Is it just SQL or is this capability isn't supported by Druid core.
   3. When starting to work on a specific item, we could line its GitHub Issue (And people can also link their existing Issues).
   
   I might spend some of my own time working on a parity comparison with Vertica (which is a mature analytical database, shares many qualities with Druid and with which I have experience with).
   I'm not entirely sure, but a parity comparison with an OLAP database might also be relevant (I have no experience with these types of databases). Perhaps @julianhyde could shed some light on the relevancy of this subtopic. 

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org