Support Questions
Find answers, ask questions, and share your expertise
Announcements
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.

Highlighted

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 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?