You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@chukwa.apache.org by "Eric Yang (JIRA)" <ji...@apache.org> on 2009/05/30 04:07:07 UTC

[jira] Created: (CHUKWA-271) Create Data mining interface for drawing chart and show database output

Create Data mining interface for drawing chart and show database output
-----------------------------------------------------------------------

                 Key: CHUKWA-271
                 URL: https://issues.apache.org/jira/browse/CHUKWA-271
             Project: Hadoop Chukwa
          Issue Type: New Feature
          Components: User Interface
         Environment: Redhat EL 5.1, Java 6
            Reporter: Eric Yang
            Assignee: Eric Yang
         Attachments: CHUKWA-271.patch

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.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Re: [jira] Commented: (CHUKWA-271) Create Data mining interface for drawing chart and show database output

Posted by Eric Yang <ey...@yahoo-inc.com>.
Definitely.  CHUKWA-272 filed.

Regards,
Eric

On 5/31/09 12:48 PM, "Ariel Rabkin" <as...@gmail.com> wrote:

> That's a good suggestion.  Probably worth putting in
> documentation/facilitating having separate users for HICC vs demux?
> 
> On Sun, May 31, 2009 at 12:32 PM, Eric Yang (JIRA) <ji...@apache.org> wrote:
>> 
>>    [ 
>> https://issues.apache.org/jira/browse/CHUKWA-271?page=com.atlassian.jira.plug
>> in.system.issuetabpanels:comment-tabpanel&focusedCommentId=12714919#action_12
>> 714919 ]
>> 
>> Eric Yang commented on CHUKWA-271:
>> ----------------------------------
>> 
>> I'll add additional SQL injection filter.  However, I recommend to deploy
>> HICC with read only user independent from the regular data processing node.
>> 
>>> Create Data mining interface for drawing chart and show database output
>>> -----------------------------------------------------------------------
>>> 
>>>                 Key: CHUKWA-271
>>>                 URL: https://issues.apache.org/jira/browse/CHUKWA-271
>>>             Project: Hadoop Chukwa
>>>          Issue Type: New Feature
>>>          Components: User Interface
>>>         Environment: Redhat EL 5.1, Java 6
>>>            Reporter: Eric Yang
>>>            Assignee: Eric Yang
>>>             Fix For: 0.2.0
>>> 
>>>         Attachments: CHUKWA-271.patch
>>> 
>>> 
>>> 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.
>> 
>> --
>> This message is automatically generated by JIRA.
>> -
>> You can reply to this email to add a comment to the issue online.
>> 
>> 
> 
> 


Re: [jira] Commented: (CHUKWA-271) Create Data mining interface for drawing chart and show database output

Posted by Ariel Rabkin <as...@gmail.com>.
That's a good suggestion.  Probably worth putting in
documentation/facilitating having separate users for HICC vs demux?

On Sun, May 31, 2009 at 12:32 PM, Eric Yang (JIRA) <ji...@apache.org> wrote:
>
>    [ https://issues.apache.org/jira/browse/CHUKWA-271?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12714919#action_12714919 ]
>
> Eric Yang commented on CHUKWA-271:
> ----------------------------------
>
> I'll add additional SQL injection filter.  However, I recommend to deploy HICC with read only user independent from the regular data processing node.
>
>> Create Data mining interface for drawing chart and show database output
>> -----------------------------------------------------------------------
>>
>>                 Key: CHUKWA-271
>>                 URL: https://issues.apache.org/jira/browse/CHUKWA-271
>>             Project: Hadoop Chukwa
>>          Issue Type: New Feature
>>          Components: User Interface
>>         Environment: Redhat EL 5.1, Java 6
>>            Reporter: Eric Yang
>>            Assignee: Eric Yang
>>             Fix For: 0.2.0
>>
>>         Attachments: CHUKWA-271.patch
>>
>>
>> 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.
>
> --
> This message is automatically generated by JIRA.
> -
> You can reply to this email to add a comment to the issue online.
>
>



-- 
Ari Rabkin asrabkin@gmail.com
UC Berkeley Computer Science Department

[jira] Commented: (CHUKWA-271) Create Data mining interface for drawing chart and show database output

Posted by "Ari Rabkin (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/CHUKWA-271?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12714847#action_12714847 ] 

Ari Rabkin commented on CHUKWA-271:
-----------------------------------

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

> Create Data mining interface for drawing chart and show database output
> -----------------------------------------------------------------------
>
>                 Key: CHUKWA-271
>                 URL: https://issues.apache.org/jira/browse/CHUKWA-271
>             Project: Hadoop Chukwa
>          Issue Type: New Feature
>          Components: User Interface
>         Environment: Redhat EL 5.1, Java 6
>            Reporter: Eric Yang
>            Assignee: Eric Yang
>             Fix For: 0.2.0
>
>         Attachments: CHUKWA-271.patch
>
>
> 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.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (CHUKWA-271) Create Data mining interface for drawing chart and show database output

Posted by "Eric Yang (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/CHUKWA-271?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Eric Yang updated CHUKWA-271:
-----------------------------

    Resolution: Fixed
        Status: Resolved  (was: Patch Available)

I just committed this.  Thanks Terence.

> Create Data mining interface for drawing chart and show database output
> -----------------------------------------------------------------------
>
>                 Key: CHUKWA-271
>                 URL: https://issues.apache.org/jira/browse/CHUKWA-271
>             Project: Hadoop Chukwa
>          Issue Type: New Feature
>          Components: User Interface
>         Environment: Redhat EL 5.1, Java 6
>            Reporter: Eric Yang
>            Assignee: Eric Yang
>             Fix For: 0.2.0
>
>         Attachments: CHUKWA-271-1.patch, CHUKWA-271.patch
>
>
> 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.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (CHUKWA-271) Create Data mining interface for drawing chart and show database output

Posted by "Hudson (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/CHUKWA-271?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12716975#action_12716975 ] 

Hudson commented on CHUKWA-271:
-------------------------------

Integrated in Chukwa-trunk #45 (See [http://hudson.zones.apache.org/hudson/job/Chukwa-trunk/45/])
    

> Create Data mining interface for drawing chart and show database output
> -----------------------------------------------------------------------
>
>                 Key: CHUKWA-271
>                 URL: https://issues.apache.org/jira/browse/CHUKWA-271
>             Project: Hadoop Chukwa
>          Issue Type: New Feature
>          Components: User Interface
>         Environment: Redhat EL 5.1, Java 6
>            Reporter: Eric Yang
>            Assignee: Eric Yang
>             Fix For: 0.2.0
>
>         Attachments: CHUKWA-271-1.patch, CHUKWA-271.patch
>
>
> 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.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (CHUKWA-271) Create Data mining interface for drawing chart and show database output

Posted by "Eric Yang (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/CHUKWA-271?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Eric Yang updated CHUKWA-271:
-----------------------------

    Attachment: CHUKWA-271-1.patch

Added patch to prevent harmful SQL statement from executing.

> Create Data mining interface for drawing chart and show database output
> -----------------------------------------------------------------------
>
>                 Key: CHUKWA-271
>                 URL: https://issues.apache.org/jira/browse/CHUKWA-271
>             Project: Hadoop Chukwa
>          Issue Type: New Feature
>          Components: User Interface
>         Environment: Redhat EL 5.1, Java 6
>            Reporter: Eric Yang
>            Assignee: Eric Yang
>             Fix For: 0.2.0
>
>         Attachments: CHUKWA-271-1.patch, CHUKWA-271.patch
>
>
> 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.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (CHUKWA-271) Create Data mining interface for drawing chart and show database output

Posted by "Eric Yang (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/CHUKWA-271?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Eric Yang updated CHUKWA-271:
-----------------------------

    Attachment: CHUKWA-271.patch

Add SQL Client to visual data by chart or table.

> Create Data mining interface for drawing chart and show database output
> -----------------------------------------------------------------------
>
>                 Key: CHUKWA-271
>                 URL: https://issues.apache.org/jira/browse/CHUKWA-271
>             Project: Hadoop Chukwa
>          Issue Type: New Feature
>          Components: User Interface
>         Environment: Redhat EL 5.1, Java 6
>            Reporter: Eric Yang
>            Assignee: Eric Yang
>         Attachments: CHUKWA-271.patch
>
>
> 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.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (CHUKWA-271) Create Data mining interface for drawing chart and show database output

Posted by "Eric Yang (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/CHUKWA-271?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12714919#action_12714919 ] 

Eric Yang commented on CHUKWA-271:
----------------------------------

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

> Create Data mining interface for drawing chart and show database output
> -----------------------------------------------------------------------
>
>                 Key: CHUKWA-271
>                 URL: https://issues.apache.org/jira/browse/CHUKWA-271
>             Project: Hadoop Chukwa
>          Issue Type: New Feature
>          Components: User Interface
>         Environment: Redhat EL 5.1, Java 6
>            Reporter: Eric Yang
>            Assignee: Eric Yang
>             Fix For: 0.2.0
>
>         Attachments: CHUKWA-271.patch
>
>
> 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.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (CHUKWA-271) Create Data mining interface for drawing chart and show database output

Posted by "Hudson (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/CHUKWA-271?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12715734#action_12715734 ] 

Hudson commented on CHUKWA-271:
-------------------------------

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)


> Create Data mining interface for drawing chart and show database output
> -----------------------------------------------------------------------
>
>                 Key: CHUKWA-271
>                 URL: https://issues.apache.org/jira/browse/CHUKWA-271
>             Project: Hadoop Chukwa
>          Issue Type: New Feature
>          Components: User Interface
>         Environment: Redhat EL 5.1, Java 6
>            Reporter: Eric Yang
>            Assignee: Eric Yang
>             Fix For: 0.2.0
>
>         Attachments: CHUKWA-271-1.patch, CHUKWA-271.patch
>
>
> 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.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (CHUKWA-271) Create Data mining interface for drawing chart and show database output

Posted by "Eric Yang (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/CHUKWA-271?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Eric Yang updated CHUKWA-271:
-----------------------------

    Fix Version/s: 0.2.0
           Status: Patch Available  (was: Open)

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

> Create Data mining interface for drawing chart and show database output
> -----------------------------------------------------------------------
>
>                 Key: CHUKWA-271
>                 URL: https://issues.apache.org/jira/browse/CHUKWA-271
>             Project: Hadoop Chukwa
>          Issue Type: New Feature
>          Components: User Interface
>         Environment: Redhat EL 5.1, Java 6
>            Reporter: Eric Yang
>            Assignee: Eric Yang
>             Fix For: 0.2.0
>
>         Attachments: CHUKWA-271.patch
>
>
> 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.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Commented: (CHUKWA-271) Create Data mining interface for drawing chart and show database output

Posted by "Terence Kwan (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/CHUKWA-271?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12715274#action_12715274 ] 

Terence Kwan commented on CHUKWA-271:
-------------------------------------

look good. +1

> Create Data mining interface for drawing chart and show database output
> -----------------------------------------------------------------------
>
>                 Key: CHUKWA-271
>                 URL: https://issues.apache.org/jira/browse/CHUKWA-271
>             Project: Hadoop Chukwa
>          Issue Type: New Feature
>          Components: User Interface
>         Environment: Redhat EL 5.1, Java 6
>            Reporter: Eric Yang
>            Assignee: Eric Yang
>             Fix For: 0.2.0
>
>         Attachments: CHUKWA-271-1.patch, CHUKWA-271.patch
>
>
> 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.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.