You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@lens.apache.org by "Amareshwari Sriramadasu (JIRA)" <ji...@apache.org> on 2016/07/22 10:44:20 UTC

[jira] [Resolved] (LENS-1009) Queries with large sql are not getting purged

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