Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-3738

Create StoragePlugin for Excel files (.xlsx or possibly .xls) - version 1 - read only.

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: Future
    • Fix Version/s: None
    • Component/s: None
    • Labels:

      Description

      I would like to implement a new storage plugin for Excel files which would support reading and writing of these.

      It would be implemented using Apache POI project:
      https://poi.apache.org/spreadsheet/

      The most recent component of POI called SS supports both .xlsx and .xls format which is particularly convenient, as this will uniformly allow the coverage of of both formats.

      First version would feature only read functionality.

        Activity

        Hide
        jnadeau Jacques Nadeau added a comment -

        It would be great if you could start by proposing a user experience.

        What are tables? (sheets, workbook)?
        What are columns (first row or a, b, c)
        etc.

        Maybe show some examples of how might work.

        Show
        jnadeau Jacques Nadeau added a comment - It would be great if you could start by proposing a user experience. What are tables? (sheets, workbook)? What are columns (first row or a, b, c) etc. Maybe show some examples of how might work.
        Hide
        ebegoli Edmon Begoli added a comment -

        What is the preferred way to document the proposed design?

        Here, in a project/fork wiki, or in a separate Google doc?

        Show
        ebegoli Edmon Begoli added a comment - What is the preferred way to document the proposed design? Here, in a project/fork wiki, or in a separate Google doc?
        Hide
        jnadeau Jacques Nadeau added a comment -

        Any/all are fine. Having a conversation here is usually a good place to start to shape the feature. Then maybe put together a formal doc in Google and link here.

        Show
        jnadeau Jacques Nadeau added a comment - Any/all are fine. Having a conversation here is usually a good place to start to shape the feature. Then maybe put together a formal doc in Google and link here.
        Hide
        ebegoli Edmon Begoli added a comment -

        I am adding some design thoughts in this Google Doc. It is open for editing to all with a link:
        https://docs.google.com/document/d/170shyenybRQ8MB0fdj1WVWmhvv5qJ5rVkpUFKibg0b4/edit?usp=sharing
        (please no vandalism)

        Show
        ebegoli Edmon Begoli added a comment - I am adding some design thoughts in this Google Doc. It is open for editing to all with a link: https://docs.google.com/document/d/170shyenybRQ8MB0fdj1WVWmhvv5qJ5rVkpUFKibg0b4/edit?usp=sharing (please no vandalism)
        Hide
        ebegoli Edmon Begoli added a comment -

        Just added. See below.

        Show
        ebegoli Edmon Begoli added a comment - Just added. See below.

          People

          • Assignee:
            Unassigned
            Reporter:
            ebegoli Edmon Begoli
          • Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

            • Created:
              Updated:

              Development