Hive函数quarter()返回'无效函数' [英] Hive function quarter() returns 'invalid function'

查看:1931
本文介绍了Hive函数quarter()返回'无效函数'的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

这表示函数quarter()是在Hive 1.3中引入的。

https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-DateFunctions



我使用默认版本的HDInsight(3.1)来运行Hadoop: b
$ b

https://azure.microsoft.com/en-us/documentation/articles/hdinsight-component-versioning/



当我尝试使用季度函数时,我得到:

使用文件中的配置初始化日志记录:/ C:/apps/dist/hive-0.13.0.2.1.15.1-0001/conf/hive-log4j.properties
SLF4J:类路径包含多个SLF4J绑定。
SLF4J:在[jar:file:/ C:/apps/dist/hadoop-2.4.0.2.1.15.1-0001/share/hadoop/common/lib/slf4j-log4j12-1.7.5中找到绑定。 jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J:在[jar:file:/ C:/apps/dist/hbase-0.98.0.2.1.15.1-0001-hadoop2/lib中找到绑定/slf4j-log4j12-1.6.4.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J:请参阅 http://www.slf4j.org/codes.html#multiple_bindings 以获得解释。
SLF4J:实际绑定类型为[org.slf4j.impl.Log4jLoggerFactory] ​​
FAILED:SemanticException [错误10011]:第10行:1无效函数'quarter'

我缺少什么?

解决方案

不幸的是,HDInsight 3.1只运行Hive 0.13.1,在版本1.3之前不可用。您可以在此处查看所有配置单元发布版 p>

This says the function quarter() was introduced in Hive 1.3

https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-DateFunctions

I am using the default version of HDInsight (3.1) to run Hadoop:

https://azure.microsoft.com/en-us/documentation/articles/hdinsight-component-versioning/

When I try to use the quarter function I get:

Logging initialized using configuration in file:/C:/apps/dist/hive-0.13.0.2.1.15.1-0001/conf/hive-log4j.properties SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/C:/apps/dist/hadoop-2.4.0.2.1.15.1-0001/share/hadoop/common/lib/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/C:/apps/dist/hbase-0.98.0.2.1.15.1-0001-hadoop2/lib/slf4j-log4j12-1.6.4.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory] FAILED: SemanticException [Error 10011]: Line 10:1 Invalid function 'quarter'

What am I missing?

解决方案

Unfortunately HDInsight 3.1 is only running Hive 0.13.1 and the quarter function isn't available until version 1.3. You can see all of the hive release here

这篇关于Hive函数quarter()返回'无效函数'的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆