Support Questions

Find answers, ask questions, and share your expertise

Any known issues on Hive 1.2.1 performance with date and timestamp data types?

Super Guru

Any known issues on Hive 1.2.1 performance with date and timestamp data types? Any issues? Any guidance anyone can provide?

1 ACCEPTED SOLUTION

@Sunile Manjee

You can go here and look for tickets realted to performance.

View solution in original post

2 REPLIES 2

@Sunile Manjee

You can go here and look for tickets realted to performance.

More information..

It may not be direct answer because your question is very broad.

http://hortonworks.com/blog/announcing-apache-hive-1-2/

Performance and Optimizer Improvements

  • Grace hash join algorithm for Hive so that Map Joins use disk on overflow instead of failing (HIVE-9277)
  • Predicate PushDown enhancements (HIVE-9069)
  • Improvements in stats for better MapJoin selection, Reducer Parallelism (HIVE-9392, HIVE-10107)
  • Count Distinct Performance Improvements (HIVE-10568)
  • CBO – Better Windowing support (HIVE-10627, HIVE-10686)
  • Changes to comply with SQL:2011 standard for reserved/non-reserved keywords (HIVE-6617)
  • Caching of statistics in HiveServer2 (HIVE-10382)
  • Improve performance of Vector Map Join by using more vectorization techniques (HIVE-9937, HIVE-9824)

https://issues.apache.org/jira/secure/ReleaseNote.jspa?version=12329345&styleName=Text&projectId=123...

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.