[jira] [Updated] (LENS-640) Create table query for finished_queries table does not work with MySQL 5.6

["Rajat Khandelwal (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/LENS-640?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Rajat Khandelwal updated LENS-640:
----------------------------------
    Fix Version/s: 2.3

> Create table query for finished_queries table does not work with MySQL 5.6
> --------------------------------------------------------------------------
>
>                 Key: LENS-640
>                 URL: https://issues.apache.org/jira/browse/LENS-640
>             Project: Apache Lens
>          Issue Type: Bug
>            Reporter: Deepak Barr
>            Assignee: Deepak Barr
>            Priority: Minor
>             Fix For: 2.3
>
>
> The create query in LensServerDAO class works fine on MySQL 5.1 but throws the following error on MySQL 5.6 -
> java.sql.SQLException: Column length too big for column 'metadata' (max = 21845); use BLOB or TEXT instead Query: CREATE TABLE if not exists finished_queries (handle varchar(255) not null unique,userquery varchar(10000) not null,submitter varchar(255) not null,starttime bigint, endtime bigint,result varchar(255),status varchar(255), metadata varchar(100000), rows int, errormessage varchar(10000), driverstarttime bigint, driverendtime bigint, metadataclass varchar(10000),queryname varchar(255),submissiontime bigint) Parameters: []
>         at org.apache.commons.dbutils.AbstractQueryRunner.rethrow(AbstractQueryRunner.java:363)
>         at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:490)
>         at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:420)
>         at org.apache.lens.server.query.LensServerDAO.createTable(LensServerDAO.java:75)
>         at org.apache.lens.server.query.LensServerDAO.createFinishedQueriesTable(LensServerDAO.java:103)
>         at org.apache.lens.server.query.QueryExecutionServiceImpl.initalizeFinishedQueryStore(QueryExecutionServiceImpl.java:890)
>         at org.apache.lens.server.query.QueryExecutionServiceImpl.init(QueryExecutionServiceImpl.java:877)
>         at org.apache.hive.service.CompositeService.init(CompositeService.java:59)
>         at org.apache.lens.server.LensServices.init(LensServices.java:206)
>         at org.apache.lens.server.LensServer.startServices(LensServer.java:137)
>         at org.apache.lens.server.LensServer.<init>(LensServer.java:89)
>         at org.apache.lens.server.LensServer.createLensServer(LensServer.java:78)
>         at org.apache.lens.server.LensServer.main(LensServer.java:190)
> I figured changing the big "VARCHAR" fields to "TEXT" fields will fix the error. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)