Uploaded image for project: 'Chukwa'
  1. Chukwa
  2. CHUKWA-271

Create Data mining interface for drawing chart and show database output

    Details

    • Type: New Feature
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.2.0
    • Component/s: User Interface
    • Labels:
      None
    • Environment:

      Redhat EL 5.1, Java 6

      Description

      This is an extension to improve database query interface, where it should be possible to draw chart and tables by entering SQL statements on the same widget for developers to generate their own hypothesis and test the data visualization.

      1. CHUKWA-271-1.patch
        19 kB
        Eric Yang
      2. CHUKWA-271.patch
        18 kB
        Eric Yang

        Activity

        Hide
        hudson Hudson added a comment -
        Show
        hudson Hudson added a comment - Integrated in Chukwa-trunk #45 (See http://hudson.zones.apache.org/hudson/job/Chukwa-trunk/45/ )
        Hide
        hudson Hudson added a comment -

        Integrated in Chukwa-trunk #42 (See http://hudson.zones.apache.org/hudson/job/Chukwa-trunk/42/)
        . Added SQL client to HICC for SQL data exploration. (Eric Yang)

        Show
        hudson Hudson added a comment - Integrated in Chukwa-trunk #42 (See http://hudson.zones.apache.org/hudson/job/Chukwa-trunk/42/ ) . Added SQL client to HICC for SQL data exploration. (Eric Yang)
        Hide
        eyang Eric Yang added a comment -

        I just committed this. Thanks Terence.

        Show
        eyang Eric Yang added a comment - I just committed this. Thanks Terence.
        Hide
        terencekwan Terence Kwan added a comment -

        look good. +1

        Show
        terencekwan Terence Kwan added a comment - look good. +1
        Hide
        eyang Eric Yang added a comment -

        Added patch to prevent harmful SQL statement from executing.

        Show
        eyang Eric Yang added a comment - Added patch to prevent harmful SQL statement from executing.
        Hide
        eyang Eric Yang added a comment -

        I'll add additional SQL injection filter. However, I recommend to deploy HICC with read only user independent from the regular data processing node.

        Show
        eyang Eric Yang added a comment - I'll add additional SQL injection filter. However, I recommend to deploy HICC with read only user independent from the regular data processing node.
        Hide
        asrabkin Ari Rabkin added a comment -

        Very cool idea. Can we/does this patch santize input to make sure that queries can only read, but not alter, the submitted data?

        Show
        asrabkin Ari Rabkin added a comment - Very cool idea. Can we/does this patch santize input to make sure that queries can only read, but not alter, the submitted data?
        Hide
        eyang Eric Yang added a comment -

        The improved SQL client provides the ability to look at the data from different visualization method.

        Show
        eyang Eric Yang added a comment - The improved SQL client provides the ability to look at the data from different visualization method.
        Hide
        eyang Eric Yang added a comment -

        Add SQL Client to visual data by chart or table.

        Show
        eyang Eric Yang added a comment - Add SQL Client to visual data by chart or table.

          People

          • Assignee:
            eyang Eric Yang
            Reporter:
            eyang Eric Yang
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development