[jira] [Created] (LENS-1261) Unable to create finished_queries table in mysql 5.7+

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

Rajat Khandelwal created LENS-1261:
--------------------------------------

             Summary: Unable to create finished_queries table in mysql 5.7+
                 Key: LENS-1261
                 URL: https://issues.apache.org/jira/browse/LENS-1261
             Project: Apache Lens
          Issue Type: Bug
            Reporter: Rajat Khandelwal


{noformat}
04 Aug 2016 12:26:02 [5cd88636-6187-4242-9622-bfa4ab64ea60] [main] WARN  org.apache.lens.server.query.LensServerDAO - Unable to create finished queries table
java.sql.SQLException: Column length too big for column 'metadata' (max = 65535); 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,priority varchar(255), starttime bigint, endtime bigint,result varchar(255),status varchar(255), metadata varchar(100000), rows int, filesize bigint, errormessage varchar(10000), driverstarttime bigint, driverendtime bigint, drivername varchar(10000), queryname varchar(255), submissiontime bigint) Parameters: []
{noformat}




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