About table creation

Please , find in this knowledge base document information and possible resolution for the error you are experiencing:

GENERIC_INTERNAL_ERROR: Value exceeds MAX_BYTE: You might see this exception when the source data column has a numeric value exceeding the allowable size for the data type BYTE. The data type BYTE is equivalent to TINYINT. TINYINT is an 8-bit signed INTEGER in two’s complement format with a minimum value of -128 and a maximum value of 127.

GENERIC_INTERNAL_ERROR: Value exceeds MAX_BYTE

To resolve this error, look for the column with the data type tinyint. Then, change the data type of this column to smallint, int, or bigint. Or, you can resolve this error by creating a new table with the updated schema.

You can run the SHOW CREATE TABLE command to generate the query that created the table. You can view the column data type for all columns from the output of this command. Look for the column with the data type tinyint, and change the data type of this column to smallint, bigint, or int.

To update the schema of the table with Data Catalog, do the following:

    Open the AWS Glue console.
    In the navigation pane, choose Tables.
    Select the table that you want to update.
    Choose Action, and then choose View details.
    Choose Edit schema.
    Scroll to the column with data type tinyint, and then choose tinyinit.
    For Column type, select smallint, bigint, or int from the dropdown list.
    Choose Update.
    On the Edit schema page, choose Save.

hope this helps