[jira] [Commented] (EAGLE-190) JBDC Metadata Storage Extension
[ https://issues.apache.org/jira/browse/EAGLE-190?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15196783#comment-15196783 ] ASF GitHub Bot commented on EAGLE-190: -- Github user asfgit closed the pull request at: https://github.com/apache/incubator-eagle/pull/118 > JBDC Metadata Storage Extension > --- > > Key: EAGLE-190 > URL: https://issues.apache.org/jira/browse/EAGLE-190 > Project: Eagle > Issue Type: Improvement >Affects Versions: v0.3.0 >Reporter: Hao Chen >Assignee: Hao Chen > Fix For: v0.3.0 > > > JDBC as metadata storage maybe more convenient and light-weight for user to > use. > * Support Derby in Memory: The JDBC can support derby and mysql completely, > and use derby in memory by default, so that user don’t have to install any > additional dependencies even mysql to get started, and also our unit test > could easily pass without any tricky modifications. > * Automatic DDL Schema Manager: JdbcEntitySchemaManager could automatically > create all required tables if not existing when application is started. > * Fixed JDBC reserved field name like desc, group and so on > * Force update while inserting failed due to duplicated key exception -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (EAGLE-190) JBDC Metadata Storage Extension
[ https://issues.apache.org/jira/browse/EAGLE-190?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15190485#comment-15190485 ] Hao Chen commented on EAGLE-190: No need to register additional complex jdbc type double[], because eagle storage system support both hbase and jdbc, in hbase we would serialize everything as binary, but in mysql, we would only register those type we don't want to store directly as binary for example some fileds in primitive type like String, Integer, Boolean and so on which could be filtered through sql query, otherwise for those types we don't register like double[], it will be serialized as binary and store as Types.BLOB physically. > JBDC Metadata Storage Extension > --- > > Key: EAGLE-190 > URL: https://issues.apache.org/jira/browse/EAGLE-190 > Project: Eagle > Issue Type: Improvement >Reporter: Hao Chen >Assignee: Hao Chen > > JDBC as metadata storage maybe more convenient and light-weight for user to > use. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (EAGLE-190) JBDC Metadata Storage Extension
[ https://issues.apache.org/jira/browse/EAGLE-190?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15186424#comment-15186424 ] ASF GitHub Bot commented on EAGLE-190: -- GitHub user haoch opened a pull request: https://github.com/apache/incubator-eagle/pull/118 EAGLE-190 JBDC Metadata Storage Extension https://issues.apache.org/jira/browse/EAGLE-190 You can merge this pull request into a Git repository by running: $ git pull https://github.com/yonzhang/incubator-eagle rdbms-support Alternatively you can review and apply these changes as the patch at: https://github.com/apache/incubator-eagle/pull/118.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #118 commit 7b317323abfb5d75f000d90194b261b731283cf0 Author: yonzhangDate: 2016-01-14T18:48:28Z initial commit for rdbms revisit commit 7ae4d6f0224466e159636316ed46e3fb262959cf Author: yonzhang Date: 2016-01-14T19:03:00Z add mysql configuratioin commit e46ecc4273472a4a854932e41579ba5bf8b57609 Author: yonzhang Date: 2016-01-18T00:23:59Z test mysql end-2-end commit e0b7d0f3a6c2dfc5e9400e410ea302bc944bcbfc Author: yonzhang Date: 2016-01-20T01:27:18Z fix LIKE issue commit b84f3d97a6f9e6536530fe9e9923375134af0700 Author: yonzhang Date: 2016-01-20T05:37:01Z fix query by rowkey commit 2315d14a72db36dcf5185e773bf5c7b0e2f12a09 Author: yonzhang Date: 2016-01-20T20:45:55Z fix desc field which conflicts with mysql reserved word commit 8fd23b39b8fa61633737ad9e8ff44ef01e0aa752 Author: yonzhang Date: 2016-01-20T22:13:55Z ui desc -> description commit d1ab4a290422036b08f1642d0e8df4a3e586f912 Author: yonzhang Date: 2016-01-20T23:07:31Z add license text commit 1dbef1a7506a1ba6d7aa51b1df5a20c16596d92a Author: yonzhang Date: 2016-01-21T04:41:09Z fix reesource query commit 4d64afbeedf1cea62a8eea2059ddf2c43d10ffb8 Author: Hao Chen Date: 2016-03-07T23:29:09Z Sync with master commit ad7cbb6a797bf093bf53d4be6d1b75ed246ae0d8 Author: Hao Chen Date: 2016-03-08T00:16:07Z Fix bug caused by AlertAPIEntity.alertContext type's changing commit 02d5840298103d747503fe45c3c7ced1eefc4dcc Author: Hao Chen Date: 2016-03-08T01:15:43Z Create HTablePool only for hbase storage commit ae44ec9be167083f9a0268bf21d18d7de9c5247b Author: Hao Chen Date: 2016-03-08T01:16:20Z Use rest/entities endpoint instead of deprecated rest/list commit 62171ffd0d65990ecd06cfc85ee4e7aea5d5ecf8 Author: Hao Chen Date: 2016-03-08T18:28:23Z Try as Types.BINARY for unknown java type commit 7d046703fd742e73a0e0233f9d02e33ce78156b5 Author: Hao Chen Date: 2016-03-08T20:51:24Z Rename desc -> description and group to groupName in ApplicationDescServiceEntity and support unknown field type as binary in JDBC commit 9e8d34be0776ead0ec80d868718ad599382f579e Author: Hao Chen Date: 2016-03-08T23:24:14Z Fix invalid fields for mysql commit edc8a2ba091d151b4dfe7c4ce23101bed4f2e65f Author: Hao Chen Date: 2016-03-08T23:24:39Z Merge branch 'master' into jilin-rdbms-rebase commit 8df70c762e4a09ea2279e9296fcd8890a13b76a6 Author: Hao Chen Date: 2016-03-08T23:26:31Z Rename dataSource to application in eagle-hadoop-metric commit bb727c281b668f2192aa1a0adab6501d20e8a3f1 Author: Hao Chen Date: 2016-03-09T00:26:00Z Fix group-renamed-to-groupName problem in front-end js commit ad59477cef6e07df38a92d18f80e339325e3672c Author: Hao Chen Date: 2016-03-09T01:28:56Z Use eagle encoded rowkey as primary key implementation for jdbc commit 3a8f13f560c0ca8f038bb388d59237d4f41e9745 Author: Hao Chen Date: 2016-03-09T01:29:26Z Use 9099 as default web service port eagle-env.sh commit c89ec72b1bece829732183d452d4c52a8f3dc915 Author: Hao Chen Date: 2016-03-09T02:37:26Z Add eagle-jdbc-mysql.sql > JBDC Metadata Storage Extension > --- > > Key: EAGLE-190 > URL: https://issues.apache.org/jira/browse/EAGLE-190 > Project: Eagle > Issue Type: Improvement >Reporter: Hao Chen >Assignee: Hao Chen > > JDBC as metadata storage maybe more convenient and light-weight for user to > use. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (EAGLE-190) JBDC Metadata Storage Extension
[ https://issues.apache.org/jira/browse/EAGLE-190?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15186422#comment-15186422 ] ASF GitHub Bot commented on EAGLE-190: -- Github user haoch closed the pull request at: https://github.com/apache/incubator-eagle/pull/117 > JBDC Metadata Storage Extension > --- > > Key: EAGLE-190 > URL: https://issues.apache.org/jira/browse/EAGLE-190 > Project: Eagle > Issue Type: Improvement >Reporter: Hao Chen >Assignee: Hao Chen > > JDBC as metadata storage maybe more convenient and light-weight for user to > use. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (EAGLE-190) JBDC Metadata Storage Extension
[ https://issues.apache.org/jira/browse/EAGLE-190?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15186418#comment-15186418 ] ASF GitHub Bot commented on EAGLE-190: -- GitHub user haoch opened a pull request: https://github.com/apache/incubator-eagle/pull/117 EAGLE-190 JBDC Metadata Storage Extension https://issues.apache.org/jira/browse/EAGLE-190 You can merge this pull request into a Git repository by running: $ git pull https://github.com/yonzhang/incubator-eagle rdbms-extension Alternatively you can review and apply these changes as the patch at: https://github.com/apache/incubator-eagle/pull/117.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #117 commit 7b317323abfb5d75f000d90194b261b731283cf0 Author: yonzhangDate: 2016-01-14T18:48:28Z initial commit for rdbms revisit commit 7ae4d6f0224466e159636316ed46e3fb262959cf Author: yonzhang Date: 2016-01-14T19:03:00Z add mysql configuratioin commit e46ecc4273472a4a854932e41579ba5bf8b57609 Author: yonzhang Date: 2016-01-18T00:23:59Z test mysql end-2-end commit e0b7d0f3a6c2dfc5e9400e410ea302bc944bcbfc Author: yonzhang Date: 2016-01-20T01:27:18Z fix LIKE issue commit b84f3d97a6f9e6536530fe9e9923375134af0700 Author: yonzhang Date: 2016-01-20T05:37:01Z fix query by rowkey commit 2315d14a72db36dcf5185e773bf5c7b0e2f12a09 Author: yonzhang Date: 2016-01-20T20:45:55Z fix desc field which conflicts with mysql reserved word commit 8fd23b39b8fa61633737ad9e8ff44ef01e0aa752 Author: yonzhang Date: 2016-01-20T22:13:55Z ui desc -> description commit d1ab4a290422036b08f1642d0e8df4a3e586f912 Author: yonzhang Date: 2016-01-20T23:07:31Z add license text commit 1dbef1a7506a1ba6d7aa51b1df5a20c16596d92a Author: yonzhang Date: 2016-01-21T04:41:09Z fix reesource query commit 4d64afbeedf1cea62a8eea2059ddf2c43d10ffb8 Author: Hao Chen Date: 2016-03-07T23:29:09Z Sync with master commit ad7cbb6a797bf093bf53d4be6d1b75ed246ae0d8 Author: Hao Chen Date: 2016-03-08T00:16:07Z Fix bug caused by AlertAPIEntity.alertContext type's changing commit 02d5840298103d747503fe45c3c7ced1eefc4dcc Author: Hao Chen Date: 2016-03-08T01:15:43Z Create HTablePool only for hbase storage commit ae44ec9be167083f9a0268bf21d18d7de9c5247b Author: Hao Chen Date: 2016-03-08T01:16:20Z Use rest/entities endpoint instead of deprecated rest/list commit 62171ffd0d65990ecd06cfc85ee4e7aea5d5ecf8 Author: Hao Chen Date: 2016-03-08T18:28:23Z Try as Types.BINARY for unknown java type commit 7d046703fd742e73a0e0233f9d02e33ce78156b5 Author: Hao Chen Date: 2016-03-08T20:51:24Z Rename desc -> description and group to groupName in ApplicationDescServiceEntity and support unknown field type as binary in JDBC commit 9e8d34be0776ead0ec80d868718ad599382f579e Author: Hao Chen Date: 2016-03-08T23:24:14Z Fix invalid fields for mysql commit edc8a2ba091d151b4dfe7c4ce23101bed4f2e65f Author: Hao Chen Date: 2016-03-08T23:24:39Z Merge branch 'master' into jilin-rdbms-rebase commit 8df70c762e4a09ea2279e9296fcd8890a13b76a6 Author: Hao Chen Date: 2016-03-08T23:26:31Z Rename dataSource to application in eagle-hadoop-metric commit bb727c281b668f2192aa1a0adab6501d20e8a3f1 Author: Hao Chen Date: 2016-03-09T00:26:00Z Fix group-renamed-to-groupName problem in front-end js commit ad59477cef6e07df38a92d18f80e339325e3672c Author: Hao Chen Date: 2016-03-09T01:28:56Z Use eagle encoded rowkey as primary key implementation for jdbc commit 3a8f13f560c0ca8f038bb388d59237d4f41e9745 Author: Hao Chen Date: 2016-03-09T01:29:26Z Use 9099 as default web service port eagle-env.sh commit c89ec72b1bece829732183d452d4c52a8f3dc915 Author: Hao Chen Date: 2016-03-09T02:37:26Z Add eagle-jdbc-mysql.sql > JBDC Metadata Storage Extension > --- > > Key: EAGLE-190 > URL: https://issues.apache.org/jira/browse/EAGLE-190 > Project: Eagle > Issue Type: Improvement >Reporter: Hao Chen >Assignee: Hao Chen > > JDBC as metadata storage maybe more convenient and light-weight for user to > use. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (EAGLE-190) JBDC Metadata Storage Extension
[ https://issues.apache.org/jira/browse/EAGLE-190?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15186395#comment-15186395 ] ASF GitHub Bot commented on EAGLE-190: -- Github user haoch closed the pull request at: https://github.com/apache/incubator-eagle/pull/116 > JBDC Metadata Storage Extension > --- > > Key: EAGLE-190 > URL: https://issues.apache.org/jira/browse/EAGLE-190 > Project: Eagle > Issue Type: Improvement >Reporter: Hao Chen >Assignee: Hao Chen > > JDBC as metadata storage maybe more convenient and light-weight for user to > use. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (EAGLE-190) JBDC Metadata Storage Extension
[ https://issues.apache.org/jira/browse/EAGLE-190?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15186383#comment-15186383 ] ASF GitHub Bot commented on EAGLE-190: -- GitHub user haoch opened a pull request: https://github.com/apache/incubator-eagle/pull/116 EAGLE-190 JBDC Metadata Storage Extension https://issues.apache.org/jira/browse/EAGLE-190 JDBC as metadata storage maybe more convenient and light-weight for user to use. You can merge this pull request into a Git repository by running: $ git pull https://github.com/yonzhang/incubator-eagle rdbms-support Alternatively you can review and apply these changes as the patch at: https://github.com/apache/incubator-eagle/pull/116.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #116 commit 973da8d2288ac6e3fa2c6bdebdef496e1def411f Author: yonzhangDate: 2016-01-14T18:48:28Z initial commit for rdbms revisit commit 5162a204f1086d19708692e8b3c6e907525a4696 Author: yonzhang Date: 2016-01-14T18:48:28Z initial commit for rdbms revisit commit e0b2dd9cd423ad223e77188f6cfb5885b74f6e26 Author: yonzhang Date: 2016-01-14T19:03:00Z add mysql configuratioin commit b665905073731cc80150e5e885a248de59af29ed Author: yonzhang Date: 2016-01-18T00:23:59Z test mysql end-2-end commit 005503e3cd93a2e4fe9f0842bc18bb53423d871b Author: yonzhang Date: 2016-01-18T00:24:44Z Merge branch 'rdbms-support' of https://github.com/yonzhang/incubator-eagle into rdbms-support commit f3a3687003f51d39ed32c4be0dd4bdc57803c1c3 Author: yonzhang Date: 2016-01-20T01:27:18Z fix LIKE issue commit b111570e4f3711a09ce9385f8ffb80c6575b9125 Author: yonzhang Date: 2016-01-20T05:37:01Z fix query by rowkey commit f644e3d17f3729e4c8a898cd2b18049c8eb9b170 Author: yonzhang Date: 2016-01-20T20:45:55Z fix desc field which conflicts with mysql reserved word commit aad45b2679f63ffc6182b4c959048970cfdb76f1 Author: yonzhang Date: 2016-01-20T22:13:55Z ui desc -> description commit 7eab1a3970826a874cc8f9fc7c300f96a235eabf Author: yonzhang Date: 2016-01-20T23:07:31Z add license text commit e71296dc60a6f3ed31f1813af6a7df539116a4d9 Author: yonzhang Date: 2016-01-21T04:41:09Z fix reesource query commit 7b317323abfb5d75f000d90194b261b731283cf0 Author: yonzhang Date: 2016-01-14T18:48:28Z initial commit for rdbms revisit commit 7ae4d6f0224466e159636316ed46e3fb262959cf Author: yonzhang Date: 2016-01-14T19:03:00Z add mysql configuratioin commit e46ecc4273472a4a854932e41579ba5bf8b57609 Author: yonzhang Date: 2016-01-18T00:23:59Z test mysql end-2-end commit e0b7d0f3a6c2dfc5e9400e410ea302bc944bcbfc Author: yonzhang Date: 2016-01-20T01:27:18Z fix LIKE issue commit b84f3d97a6f9e6536530fe9e9923375134af0700 Author: yonzhang Date: 2016-01-20T05:37:01Z fix query by rowkey commit 2315d14a72db36dcf5185e773bf5c7b0e2f12a09 Author: yonzhang Date: 2016-01-20T20:45:55Z fix desc field which conflicts with mysql reserved word commit 8fd23b39b8fa61633737ad9e8ff44ef01e0aa752 Author: yonzhang Date: 2016-01-20T22:13:55Z ui desc -> description commit d1ab4a290422036b08f1642d0e8df4a3e586f912 Author: yonzhang Date: 2016-01-20T23:07:31Z add license text commit 1dbef1a7506a1ba6d7aa51b1df5a20c16596d92a Author: yonzhang Date: 2016-01-21T04:41:09Z fix reesource query commit 4d64afbeedf1cea62a8eea2059ddf2c43d10ffb8 Author: Hao Chen Date: 2016-03-07T23:29:09Z Sync with master commit ad7cbb6a797bf093bf53d4be6d1b75ed246ae0d8 Author: Hao Chen Date: 2016-03-08T00:16:07Z Fix bug caused by AlertAPIEntity.alertContext type's changing commit 02d5840298103d747503fe45c3c7ced1eefc4dcc Author: Hao Chen Date: 2016-03-08T01:15:43Z Create HTablePool only for hbase storage commit ae44ec9be167083f9a0268bf21d18d7de9c5247b Author: Hao Chen Date: 2016-03-08T01:16:20Z Use rest/entities endpoint instead of deprecated rest/list commit 62171ffd0d65990ecd06cfc85ee4e7aea5d5ecf8 Author: Hao Chen Date: 2016-03-08T18:28:23Z Try as Types.BINARY for unknown java type commit 7d046703fd742e73a0e0233f9d02e33ce78156b5 Author: Hao Chen Date: 2016-03-08T20:51:24Z Rename desc -> description and group to groupName in ApplicationDescServiceEntity and support unknown field type as binary in
[jira] [Commented] (EAGLE-190) JBDC Metadata Storage Extension
[ https://issues.apache.org/jira/browse/EAGLE-190?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15186212#comment-15186212 ] Jaspaul Chahal commented on EAGLE-190: -- When I was looking into it, I concluded that we need to registerJdbcType for double[]. Not sure if Types.ARRAY will do the job or need changes in code for that. > JBDC Metadata Storage Extension > --- > > Key: EAGLE-190 > URL: https://issues.apache.org/jira/browse/EAGLE-190 > Project: Eagle > Issue Type: Improvement >Reporter: Hao Chen >Assignee: Hao Chen > > JDBC as metadata storage maybe more convenient and light-weight for user to > use. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (EAGLE-190) JBDC Metadata Storage Extension
[ https://issues.apache.org/jira/browse/EAGLE-190?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15186190#comment-15186190 ] Hao Chen commented on EAGLE-190: I changed the front-end, current problem is that it's hard to modify the same entity because mysql dosen't work like the same approach. > JBDC Metadata Storage Extension > --- > > Key: EAGLE-190 > URL: https://issues.apache.org/jira/browse/EAGLE-190 > Project: Eagle > Issue Type: Improvement >Reporter: Hao Chen >Assignee: Hao Chen > > JDBC as metadata storage maybe more convenient and light-weight for user to > use. -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (EAGLE-190) JBDC Metadata Storage Extension
[ https://issues.apache.org/jira/browse/EAGLE-190?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15185503#comment-15185503 ] Hao Chen commented on EAGLE-190: Some field name like `desc`,`group` are reserved keywords of JDBC, so we should rename such kinds of field names, while the front-end needs to have some changes as well. [~smith3816] > JBDC Metadata Storage Extension > --- > > Key: EAGLE-190 > URL: https://issues.apache.org/jira/browse/EAGLE-190 > Project: Eagle > Issue Type: Improvement >Reporter: Hao Chen >Assignee: Hao Chen > > JDBC as metadata storage maybe more convenient and light-weight for user to > use. -- This message was sent by Atlassian JIRA (v6.3.4#6332)