I have a table A, with age a column in it. I created a table B in orc with age column sorted. Now, select * from A where age=60; select * from B where age=60; Both reads same amount of data and no difference in time was observed. Please help me with this.
I didn't understand what you said. I think row groups should be skipped based on max and min stored for them. And also I tried for one selecting one column too. It didn't work. Maybe I'm wrong in my understanding.