[GitHub] [incubator-druid] HeIsRicky opened a new issue #7663: druid 0.14.1-incubating create table failed when starting the Coordinator

[GitBox <gi...@apache.org>]

HeIsRicky opened a new issue #7663: druid 0.14.1-incubating create table failed when starting the Coordinator
URL: https://github.com/apache/incubator-druid/issues/7663
 
 
   druid 0.14.1-incubating
   mysql 5.6
   
   - Following sql has been executed
   `
     -- create a druid database, make sure to use utf8mb4 as encoding
     CREATE DATABASE druid DEFAULT CHARACTER SET utf8mb4;
   
     -- create a druid user
     CREATE USER 'druid'@'localhost' IDENTIFIED BY 'diurd';
   
     -- grant the user all the permissions on the database we just created
     GRANT ALL PRIVILEGES ON druid.* TO 'druid'@'localhost';
   
     SET GLOBAL innodb_file_format = Barracuda;
     SET GLOBAL innodb_file_per_table = ON;
     innodb_large_prefix = 1
   `
   
   - common.runtime.properties
   `
   ...
   druid.extensions.loadList=["druid-histogram", "druid-datasketches", "druid-lookups-cached-global", "druid-hdfs-storage", "mysql-metadata-storage"]
   
      druid.metadata.storage.type=mysql
      druid.metadata.storage.connector.connectURI=jdbc:mysql://rw.moni- 
      druid101680.mysql.dba.vivo.lan:11005/druid
      druid.metadata.storage.connector.user=rw_druid
      druid.metadata.storage.connector.password=...
   ...
   `
   
   - Error
   `
   java.sql.SQLException: Index column size too large. The maximum column size is 767 bytes.
   `

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org