Hive中是否有字符串数据类型的最大大小? [英] Is there maximum size of string data type in Hive?

问题描述

大量搜索Google，但未在任何地方找到它.还是这意味着只要允许群集，Hive就可以支持任意大字符串数据类型?如果是这样，在哪里可以找到我的集群可以支持的最大字符串数据类型?

Google a ton but haven't found it anywhere. Or does that mean Hive can support arbitrary large string data type as long as cluster is allowed? If so, where I can find what is the largest size of string data type that my cluster can support?

提前谢谢！

推荐答案

Hive的当前文档将STRING列为有效数据类型，与VARCHAR和CHAR不同，请参见此处的官方apache文档: https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Types#LanguageManualTypes-Strings

The current documentation for Hive lists STRING as a valid datatype, distinct from VARCHAR and CHAR See official apache doc here: https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Types#LanguageManualTypes-Strings

对我来说，STRING确实是它自己的类型并没有立即显现出来，但是如果向下滚动，您会发现在几种情况下它的使用方式与其他情况截然不同.

It wasn't immediately apparent to me that STRING was indeed it's own type, but if you scroll down you'll see several cases where it's used distinctly from the others.

虽然可能没有权威性，但此页面指示STRING的最大长度为2GB. http://www.folkstalk.com/2011/11/data-types-in- hive.html

While perhaps not authoritative, this page indicates the max length of a STRING is 2GB. http://www.folkstalk.com/2011/11/data-types-in-hive.html

这篇关于Hive中是否有字符串数据类型的最大大小?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！