Re: hive table with large column data size

2022-01-10 Thread Gourav Sengupta
Hi, As always, before answering the question, can I please ask what are you trying to achieve by storing the data in a table? How are you planning to query a binary data? If you look at any relational theory, then it states that a table is a relation/ entity and the fields the attributes. You

Re: hive table with large column data size

2022-01-09 Thread Jörn Franke
It is not a good practice to do this. Just store a reference to the binary data stored on HDFS. > Am 09.01.2022 um 15:34 schrieb weoccc : > >  > Hi , > > I want to store binary data (such as images) into hive table but the binary > data column might be much larger than other columns per row.

hive table with large column data size

2022-01-09 Thread weoccc
Hi , I want to store binary data (such as images) into hive table but the binary data column might be much larger than other columns per row. I'm worried about the query performance. One way I can think of is to separate binary data storage from other columns by creating 2 hive tables and run 2