The 8kb is a limitation from block size. There is another limitation that one single account can only put 5 custom_jsons in one block (every 3 seconds).
Using Hive as a SQL database is not going to work. Designing around Hive is something that needs to be carefully thought out.