You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@community.apache.org by "Xiangdong Huang (Jira)" <ji...@apache.org> on 2021/04/01 07:24:00 UTC

[jira] [Commented] (COMDEV-404) Integrating Apache IoTDB and Apache Superset

    [ https://issues.apache.org/jira/browse/COMDEV-404?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17312942#comment-17312942 ] 

Xiangdong Huang commented on COMDEV-404:
----------------------------------------

update about IoTDB's Python API, Pandas has been supported.

[1]https://github.com/apache/iotdb/pull/2960

> 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-unsubscribe@community.apache.org
For additional commands, e-mail: dev-help@community.apache.org