问题描述
大量搜索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中是否有字符串数据类型的最大大小?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!