Comment 2 for bug 1389791

Revision history for this message
Roberta Marton (roberta-marton) wrote :

When Trafodion generates an hbase name, it includes both the catalog and schema name. In this case, the hbase name would look like:

"trafodion.DDL_TAB001_A013_7_CAT1_SCH1_AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA.Y123456789B123456789C123456789D123456789E123456789F123456789G123456789H123456789I123456789J123456789K123456789L123456789M1234567"

Adding up all three parts, the length of the entire name is 268 bytes.
However, the Linux file system only allow names up to 256 bytes.

The following table can be created - total length is 256.

"trafodion.DDL_TAB001_A013_7_CAT1_SCH1_AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA.Y123456789B123456789C123456789D123456789E123456789F123456789G123456789H123456789I123456789J123456789K123456789L12345"

The following table create hangs - total length is 257

"trafodion.DDL_TAB001_A013_7_CAT1_SCH1_AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA.Y123456789B123456789C123456789D123456789E123456789F123456789G123456789H123456789I123456789J123456789K123456789L123456"

Recommend adding a check to make sure the total name length is not longer than what Linux supports.