eagle-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "JiJun Tang (JIRA)" <j...@apache.org>
Subject [jira] [Assigned] (EAGLE-980) Throw SQL syntax exception when using jdbc storage
Date Thu, 30 Mar 2017 07:08:41 GMT

     [ https://issues.apache.org/jira/browse/EAGLE-980?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

JiJun Tang reassigned EAGLE-980:
--------------------------------

    Assignee: Lingang Deng

> Throw SQL syntax exception when using jdbc storage
> --------------------------------------------------
>
>                 Key: EAGLE-980
>                 URL: https://issues.apache.org/jira/browse/EAGLE-980
>             Project: Eagle
>          Issue Type: Bug
>    Affects Versions: v0.4.0
>            Reporter: Lingang Deng
>            Assignee: Lingang Deng
>
> I configue storage type "jdbc" in eagle server, exception threw as follows,
> {code}
> # eagle_metric_eagle_metric_schema 
> # ----------------------------------------------------------------------- 
> CREATE TABLE eagle_metric_eagle_metric_schema
> (
>     uuid VARCHAR(254) NOT NULL,
>     timestamp BIGINT,
>     site VARCHAR(254) NULL,
>     site VARCHAR(254) NULL,
>     group VARCHAR(254) NULL,
>     dimensionFields LONGBLOB,
>     metricFields LONGBLOB,
>     granularity VARCHAR(1000) NULL,
>     modifiedTimestamp BIGINT,
>     PRIMARY KEY (uuid)
> ) failed with: You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near 'group VARCHAR(254) NULL,
>     dimensionFields LONGBLOB,
>     metricFields LONGBLOB' at line 11
> {code}
> There are 2 "site" field, and "group" field is a keyword.
> I found the table is based on class "MetricSchemaEntity", 
> {code}
> @Tags({"site","site","group"})
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message