Support Questions
Find answers, ask questions, and share your expertise
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

hive query performance issues.


hive query performance issues.

New Contributor

Hi sir, I have questions about hive performance

1.if I have 30 crore rows, with 40 fields in hive orc by day data level increased in lacs level.i Have partitioned that table based on 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. i am using llap in tez engine for interactive query .

5.can i achieve these things in spark or tez llap enough for that?