You are viewing a plain text version of this content. The canonical link for it is here.
Posted to common-dev@hadoop.apache.org by "Eric Yang (JIRA)" <ji...@apache.org> on 2009/03/04 20:21:56 UTC
[jira] Created: (HADOOP-5398) Support SQL macros in Chukwa Charting
Support SQL macros in Chukwa Charting
-------------------------------------
Key: HADOOP-5398
URL: https://issues.apache.org/jira/browse/HADOOP-5398
Project: Hadoop Core
Issue Type: New Feature
Environment: Redhat EL 5.1, Java 6
Reporter: Eric Yang
In Chukwa Database aggregator, we could execute SQL statement which looks like:
insert into [cluster_system_metrics] (select [avg(system_metrics)] from [system_metrics] where timestamp between [past_10_minutes] and [now]);
This new feature is to bring macro language to HICC charting. The user can write statement like:
select timestamp,host,load_5 from [system_metrics] where timestamp between [start] and [end];
This statement will automatically expand to:
select timestamp, host, load_5 from system_metrics_2045_week where timestamp between '2009-03-02 00:00:00' and '2009-03-03 00:00:00';
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HADOOP-5398) Support SQL macros in Chukwa Charting
Posted by "Eric Yang (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-5398?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Eric Yang updated HADOOP-5398:
------------------------------
Attachment: HADOOP-5398.patch
- Create a new Macro class for macro substitution.
- Changed Aggregator to use Macro class.
- Added macro substitution support to Chukwa Charting.
- Added Macro test case.
> Support SQL macros in Chukwa Charting
> -------------------------------------
>
> Key: HADOOP-5398
> URL: https://issues.apache.org/jira/browse/HADOOP-5398
> Project: Hadoop Core
> Issue Type: New Feature
> Components: contrib/chukwa
> Environment: Redhat EL 5.1, Java 6
> Reporter: Eric Yang
> Assignee: Eric Yang
> Attachments: HADOOP-5398.patch
>
>
> In Chukwa Database aggregator, we could execute SQL statement which looks like:
> insert into [cluster_system_metrics] (select [avg(system_metrics)] from [system_metrics] where timestamp between [past_10_minutes] and [now]);
> This new feature is to bring macro language to HICC charting. The user can write statement like:
> select timestamp,host,load_5 from [system_metrics] where timestamp between [start] and [end];
> This statement will automatically expand to:
> select timestamp, host, load_5 from system_metrics_2045_week where timestamp between '2009-03-02 00:00:00' and '2009-03-03 00:00:00';
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HADOOP-5398) Support SQL macros in Chukwa Charting
Posted by "Eric Yang (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-5398?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Eric Yang updated HADOOP-5398:
------------------------------
Release Note:
What is new in HADOOP-5398:
- Create a new Macro class for macro substitution.
- Changed Aggregator to use Macro class.
- Added macro substitution support to Chukwa Charting.
- Added Macro test case.
Hadoop Flags: [Reviewed]
Status: Patch Available (was: Open)
> Support SQL macros in Chukwa Charting
> -------------------------------------
>
> Key: HADOOP-5398
> URL: https://issues.apache.org/jira/browse/HADOOP-5398
> Project: Hadoop Core
> Issue Type: New Feature
> Components: contrib/chukwa
> Environment: Redhat EL 5.1, Java 6
> Reporter: Eric Yang
> Assignee: Eric Yang
> Attachments: HADOOP-5398.patch
>
>
> In Chukwa Database aggregator, we could execute SQL statement which looks like:
> insert into [cluster_system_metrics] (select [avg(system_metrics)] from [system_metrics] where timestamp between [past_10_minutes] and [now]);
> This new feature is to bring macro language to HICC charting. The user can write statement like:
> select timestamp,host,load_5 from [system_metrics] where timestamp between [start] and [end];
> This statement will automatically expand to:
> select timestamp, host, load_5 from system_metrics_2045_week where timestamp between '2009-03-02 00:00:00' and '2009-03-03 00:00:00';
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HADOOP-5398) Support SQL macros in Chukwa Charting
Posted by "Eric Yang (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-5398?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Eric Yang updated HADOOP-5398:
------------------------------
Component/s: contrib/chukwa
> Support SQL macros in Chukwa Charting
> -------------------------------------
>
> Key: HADOOP-5398
> URL: https://issues.apache.org/jira/browse/HADOOP-5398
> Project: Hadoop Core
> Issue Type: New Feature
> Components: contrib/chukwa
> Environment: Redhat EL 5.1, Java 6
> Reporter: Eric Yang
> Assignee: Eric Yang
>
> In Chukwa Database aggregator, we could execute SQL statement which looks like:
> insert into [cluster_system_metrics] (select [avg(system_metrics)] from [system_metrics] where timestamp between [past_10_minutes] and [now]);
> This new feature is to bring macro language to HICC charting. The user can write statement like:
> select timestamp,host,load_5 from [system_metrics] where timestamp between [start] and [end];
> This statement will automatically expand to:
> select timestamp, host, load_5 from system_metrics_2045_week where timestamp between '2009-03-02 00:00:00' and '2009-03-03 00:00:00';
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Assigned: (HADOOP-5398) Support SQL macros in Chukwa
Charting
Posted by "Eric Yang (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-5398?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Eric Yang reassigned HADOOP-5398:
---------------------------------
Assignee: Eric Yang
> Support SQL macros in Chukwa Charting
> -------------------------------------
>
> Key: HADOOP-5398
> URL: https://issues.apache.org/jira/browse/HADOOP-5398
> Project: Hadoop Core
> Issue Type: New Feature
> Components: contrib/chukwa
> Environment: Redhat EL 5.1, Java 6
> Reporter: Eric Yang
> Assignee: Eric Yang
>
> In Chukwa Database aggregator, we could execute SQL statement which looks like:
> insert into [cluster_system_metrics] (select [avg(system_metrics)] from [system_metrics] where timestamp between [past_10_minutes] and [now]);
> This new feature is to bring macro language to HICC charting. The user can write statement like:
> select timestamp,host,load_5 from [system_metrics] where timestamp between [start] and [end];
> This statement will automatically expand to:
> select timestamp, host, load_5 from system_metrics_2045_week where timestamp between '2009-03-02 00:00:00' and '2009-03-03 00:00:00';
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.