Enable text caching in HDInsight Interactive Query Cluster to get super-fast performance with text data

From Ambari, put these configs in to custom hive-site section and then restart LLAP from Ambari –

hive.llap.cache.allow.synthetic.fileid=true
hive.vectorized.use.vector.serde.deserialize=true
hive.vectorized.use.row.serde.deserialize=true
hive.llap.io.encode.enabled=true