[
https://issues.apache.org/jira/browse/COMDEV-404?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17318478#comment-17318478
]
Kris Stern commented on COMDEV-404:
-----------------------------------
Hi [~jfeinauer] It would be great to have you as a co-mentor! I am still doing
some research on potential ways to build a IoTDB database connector Superset,
as well as ways to support NoSQL or non-standard RDBs. So these two foci may be
explored over the next few months for the proposed project at least. Xiangdong
did mention in a email that it may be beneficial for us to look at any work
that has already been done for existing Superset adaptors, as as both Superset
and IoTDB do not support standard relational SQL, if my understanding of the
situation is accurate.
> Integrating Apache IoTDB and Apache Superset
> --------------------------------------------
>
> Key: COMDEV-404
> URL: https://issues.apache.org/jira/browse/COMDEV-404
> Project: Community Development
> Issue Type: Task
> Components: GSoC/Mentoring ideas
> Reporter: Xiangdong Huang
> Priority: Major
> Labels: IoTDB, gsoc2021, mentor
>
> Apache IoTDB [1] is an Open Source IoT database designed to meet the rigorous
> data, storage, and analytics requirements of large-scale Internet of Things
> (IoT) and Industrial Internet of Things (IIoT) applications.
> Apache Superset [2] is fast, lightweight, intuitive, and loaded with options
> that make it easy for users of all skill sets to explore and visualize their
> data, from simple line charts to highly detailed geospatial charts.
> We hope that Superset can be used as a data display and analysis tool of
> IoTDB, which will bring great convenience to analysts of the IoT and IIoT.
> For a database engine to be supported in Superset, it requires having a
> Python compliant SQLAlchemy dialect [3] as well as a DBAPI driver [4]
> defined. The current Python client of IoTDB is packaged by Apache Thrift
> generated code and does not follow a certain interface specification.
> Therefore, the first thing you need to do is to implement a standard
> SQLAlchemy connector based on the current Python client (or some new
> interfaces defined and generated by Thrift).
> Next, you need to explore how to integrate IoTDB and Superset and document
> the usage in a user-friendly way. The integration documentation for Apache
> Kylin and Superset is here [5] for your reference.
> What knowledge you need to know:
> - Basic database knowledge (SQL)
> - Python
> [1] https://iotdb.apache.org
> [2] https://superset.apache.org/
> [3] https://docs.sqlalchemy.org/en/13/dialects/
> [4] https://www.python.org/dev/peps/pep-0249/
> [5] http://kylin.apache.org/blog/2018/01/01/kylin-and-superset/
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@community.apache.org
For additional commands, e-mail: dev-h...@community.apache.org
