AnsweredAssumed Answered

Setting up MapR Metrics database

Question asked by vvk on Apr 25, 2013
Latest reply on Apr 26, 2013 by vvk
After following the instructions provided in the link http://mapr.com/doc/display/MapR/Setting+up+the+MapR+Metrics+Database, I am getting the following error
ERROR 1709 (HY000): Index column size too large. The maximum column size is 767 bytes.

mysql> source /opt/mapr/bin/setup.sql

After debugging this issue further, it seems like M_VALUE VARCHAR(256) is causing the problem.



    create table IF NOT EXISTS METRIC_TRANSACTION_EVENT (
       EVENT_TIME BIGINT NOT NULL,
       M_NAME VARCHAR(64) NOT NULL,
       M_VALUE VARCHAR(256) NOT NULL,
       NODE_ID VARCHAR(64) NOT NULL,      
       CLUSTER_ID VARCHAR(32) NOT NULL,
       USER_ID VARCHAR(64),
       PROCESS_ID VARCHAR(64),
       CREATED TIMESTAMP NOT NULL DEFAULT NOW(),
       PRIMARY KEY (CLUSTER_ID, NODE_ID, M_NAME, EVENT_TIME, M_VALUE)
    );  

Is there any resolution or workaround for this?

Thanks in advance.

Outcomes