[
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)
