I've a table containing about 4 millions rows and all queries like:
select count(*) from table1 or select col1 from table1 where col2=xxx
runs always in more than 15 seconds.
The table has been stored as ORC with index enabled.
My Env. is Cloudera 5.8.2 and the engine execution is mapreduce. For some reason, TEZ engine does not work.
Any idea how making queries running faster ?