Uploaded image for project: 'Community Development'
  1. Community Development
  2. COMDEV-404

Integrating Apache IoTDB and Apache Superset

Attach filesAttach ScreenshotAdd voteVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments



      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 comment will be Viewable by All Users Viewable by All Users


            Unassigned Unassigned
            hxd Xiangdong Huang




                Issue deployment