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

[#1]

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

[#2 · Accepted solution]

@Sunile Manjee

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

[#3]

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