Trouble importing sparse expresion matrix due to Mysql limits on table columns.
SQL Error [1005] [HY000]: (conn=11) Can't create table `10X_airr`.`expression` (errno: 185 "Too many columns")
MySQL has a hard limit of 4096 columns per table, but the effective maximum may be less for a given table. The 10X sparse matrix example has a shape of 5105 rows × 36602 columns. Even if the dataframe is transposed the columns still exceed this limit. What would be the best way to store this data?