[
https://issues.apache.org/jira/browse/LENS-1009?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Amareshwari Sriramadasu resolved LENS-1009.
-------------------------------------------
Resolution: Workaround
Solution is to change the type of query column to text in underling DB.
> 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
>
> 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
(v6.3.4#6332)