Cloudera 5.6：实木复合地板不支持日期。见HIVE-6384 [英] Cloudera 5.6: Parquet does not support date. See HIVE-6384

问题描述

我正在使用Cloudera 5.6试图在基于另一个表的hive表中创建parquet格式表，但我遇到了一个错误。

  create table sfdc_opportunities_sandbox_parquet like 
 sfdc_opportunities_sandbox STORED AS PARQUET 
  

错误消息

  Parquet不支持日期。请参阅HIVE-6384 
  

我读到hive 1.2已解决此问题，但Cloudera 5.6和5.7不要配备蜂巢1.2。有没有人找到解决这个问题的方法？除了使用其他数据类型，如 display / Hive / LanguageManual + Types＃LanguageManualTypes-Date / TimeTypesrel =nofollow noreferrer> TIMESTAMP 或其他存储格式，如 ORC ，如果依赖于使用的Hive版本和Parquet文件存储格式，则可能没有办法解决。

根据Clouderas CDH 5 Packaging and Tarball信息，整个分支5在v1.5.0中包含 Apache Parquet 和 Apache Hive 。

日期已在实木复合地板使用 HIVE-8119 和从Hive 1.2开始。

I am currently using Cloudera 5.6 trying to create a parquet format table in hive table based off another table, but I am running into an error.

create table sfdc_opportunities_sandbox_parquet like 
sfdc_opportunities_sandbox STORED AS PARQUET

Error Message

Parquet does not support date. See HIVE-6384

I read that hive 1.2 has a fix for this issue, but Cloudera 5.6 and 5.7 do not come with hive 1.2. Has anyone found way around this issue?

解决方案

Except from using an other data type like TIMESTAMP or an other storage format like ORC, there might be no way around if there is a dependency to the used Hive version and Parquet file storage format.

According Clouderas CDH 5 Packaging and Tarball Information, the whole branch 5 comes packed with Apache Parquet in v1.5.0 and Apache Hive in v1.1.0.

Date was implemented in ParquetSerde with HIVE-8119 and as of Hive 1.2.

这篇关于Cloudera 5.6：实木复合地板不支持日期。见HIVE-6384的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！