Hi All, I have three date columns, So, I written l...
# general
r
Hi All, I have three date columns, So, I written like this,
Copy code
"dateTimeFieldSpecs": [
  {
    "name": "_source.startDate",
    "dataType": "STRING",
    "format": "1:SECONDS:SIMPLE_DATE_FORMAT:yyyy-MM-dd",
    "granularity": "1:DAYS"
  },
  {
    "name": "_source.lastUpdate",
    "dataType": "STRING",
    "format": "1:SECONDS:SIMPLE_DATE_FORMAT:yyyy-MM-dd HH:mm:ss",
    "granularity": "1:DAYS"
  },
  {
    "name": "_source.sDate",
    "dataType": "STRING",
    "format": "1:SECONDS:SIMPLE_DATE_FORMAT:yyyy-MM-dd HH:mm:ss",
    "granularity": "1:DAYS"
  }
]
can you please correct. I am getting error
Copy code
{
  "code": 400,
  "error": "Cannot find valid fieldSpec for timeColumn: timestamp from the table config: eventflow_REALTIME, in the schema: eventflowstats"
}
Need your help 🙂
k
Let’s use #troubleshooting for these questions.
r
Sure thanks
k
The error message has the info- time column (time stamp) specified in tableconfig does not exist in schema
Change the time column in table config to point to one of these name in schema
r
i don't have any column named 'timestamp'.