[ https://issues.apache.org/jira/browse/LENS-1009?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17017727#comment-17017727 ]
Puneet Gupta commented on LENS-1009: ------------------------------------ Don't think this has been fixed. Use the workaround mentioned by [~amareshwari] and alter the database table directly. > Queries with large sql are not getting purged > --------------------------------------------- > > Key: LENS-1009 > URL: https://issues.apache.org/jira/browse/LENS-1009 > Project: Apache Lens > Issue Type: Bug > Components: server > Reporter: Rajat Khandelwal > Priority: Major > > Lens creates finished_queries table with column userquery as varchar(10000). > If a query is larger than that, while purging it throws an exception > regarding data truncation. After that, there are retries for purging and it > keeps on retrying. After some time the logs get cluttered since purge > failure logs are everywhere. -- This message was sent by Atlassian Jira (v8.3.4#803005)