hi gurus, kindly clarify the following please - Hive currently does not support indexes or indexes are not used in the query - The lowest granularity for concurrency is partition. If table is partitioned, then partition will be lucked in DML operation - What is the best file format to store Hive table in HDFS? Is this ORC or Avro that allow being split and support block compression? - Text/CSV files. By default if file type is not specified at creation time, Hive will default to text file?
Thanks
