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

[Deepak Barr (JIRA)]

Deepak Barr created LENS-640:
--------------------------------

             Summary: 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


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)