1.if I have 30 crore rows, with 40 fields in hive orc table.day by day data level increased in lacs level.i Have partitioned that table based on timestamp.now its take 40sec to return 1month level result.
2.can I get that rows less than seconds by applying some filter and aggregation function.
3.if it is not ,how much time it takes to return result.
4.now i am using llap in tez engine for interactive query .
5.can i achieve these things in spark or tez llap enough for that?