[ 
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)

Reply via email to