I am currently trying out the latest CDH 5.6 build. This build comes with hive 1.1.0. When I tried to create a table in hive using parquet format, the error message showed that hive 1.1 does not support date format in parquet yet. it was added in 1.2.0. I can use timestamp but when I expose the table to tableau through impala using cloudera impala odbc driver, the driver is trying to convert timestamp to date in the BI queries and failing. timestamp to date is an invalid cast in impala. (for another discussion though, i think, is that those queries actually do not have to be type casted to date to get the desired results but the driver tries it). This issue restricts any continuous analysis on date columns in tablueau. So, I decided to use date column in the underlying hive table and stuck with this question of upgrading. Can I upgrade from hive 1.1.0 to 1.2.0 in CDH 5.6? Have anyone done this ? Can you give some pointers on how to do this? I Is there any known issue that I need to be aware of. I was doing a lot of search to gather information. Havent got much yet. I was going to make a build form source and replace all the hive jars under the cloudera/parcels/hive with the new ones.Just wanted to see if anyone knows more before I start with the upgrade and get stuck with a roadblock. Thank you!
Did you ever get that working? I know a bunch of people must be trying this, and I'm about to be one of them. If you ran into any problems, I'd love to get any info on the process you used.
The problem was fixed on 18 May 2015.
I understand the Cloudera would be production oriented, but is a mess with this issue when use both as ETL on parquet.
On February 2016 the hive 2.0.0 was released, maybe is time to upgrade on Cloudera.