[jira] [Created] (EAGLE-980) Throw SQL syntax exception when using jdbc storage

[Lingang Deng (JIRA)]

Lingang Deng created EAGLE-980:
----------------------------------

             Summary: 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
          Components: Core::Query Engine
    Affects Versions: v0.4.0
            Reporter: 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)