[
https://issues.apache.org/jira/browse/LENS-1260?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15407655#comment-15407655
]
Rajat Khandelwal commented on LENS-1260:
----------------------------------------
http://stackoverflow.com/questions/9192027/invalid-default-value-for-create-date-timestamp-field
worked as a workaround.
> Saved query table not created with mysql 5.7+
> ---------------------------------------------
>
> Key: LENS-1260
> URL: https://issues.apache.org/jira/browse/LENS-1260
> Project: Apache Lens
> Issue Type: Bug
> Reporter: Rajat Khandelwal
> Assignee: Rajat Khandelwal
>
> https://github.com/apache/lens/commit/3780744f87e89839d7d51ce069d5e84c66ca6740
> works for mysql 5.7+, which is the version I have in my local setup.
> https://github.com/apache/lens/commit/90c710018ae56712cf91c56338d69dc0ad1ee65c
> works for mysql 5.5 and 5.6.
> I've been unable to find a sql which works for both. So I'd like to create
> one dialect to incorporate both create syntaxes.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
