BLOB with ORC in Hive

[#1]

This is the access pattern:

Select datetime from tableName where id =?

Select content from tableName where id =? And datetime=?

One of the columns is a BLOB and the table is in ORC format. (The table needs to be transactional)

Because of the BLOB, the read times are high.

Any recommendations on optimization? This is on HDP 2.3.

Thanks,

Kiran