I had been trying to get histogram_numeric from a hive table with numeric
column but getting an invalid function error. Documentation has this
function listed and I dont think that this function is deprecated.
Appreciate your help in figuring this out.
hive -hiveconf hive.root.logger=INFO,console
Hive history file=/tmp/hadoop/hive_job_log_hadoop_201102072010_571576185.txt
11/02/07 20:10:27 INFO exec.HiveHistory: Hive history
file=/tmp/hadoop/hive_job_log_hadoop_201102072010_571576185.txt
hive> select histogram_numeric(request_count, 100) from requests_stat_min;
11/02/07 20:10:31 INFO parse.ParseDriver: Parsing command: select
histogram_numeric(request_count, 100) from requests_stat_min
11/02/07 20:10:32 INFO parse.ParseDriver: Parse Completed
11/02/07 20:10:32 INFO parse.SemanticAnalyzer: Starting Semantic Analysis
11/02/07 20:10:32 INFO parse.SemanticAnalyzer: Completed phase 1 of Semantic
Analysis
11/02/07 20:10:32 INFO parse.SemanticAnalyzer: Get metadata for source
tables
11/02/07 20:10:32 INFO metastore.HiveMetaStore: 0: Opening raw store with
implemenation class:org.apache.hadoop.hive.metastore.ObjectStore
11/02/07 20:10:32 INFO metastore.ObjectStore: ObjectStore, initialize called
11/02/07 20:10:32 ERROR DataNucleus.Plugin: Bundle "org.eclipse.jdt.core"
requires "org.eclipse.core.resources" but it cannot be resolved.
11/02/07 20:10:32 ERROR DataNucleus.Plugin: Bundle "org.eclipse.jdt.core"
requires "org.eclipse.core.runtime" but it cannot be resolved.
11/02/07 20:10:32 ERROR DataNucleus.Plugin: Bundle "org.eclipse.jdt.core"
requires "org.eclipse.text" but it cannot be resolved.
11/02/07 20:10:34 INFO metastore.ObjectStore: Initialized ObjectStore
11/02/07 20:10:34 INFO metastore.HiveMetaStore: 0: get_table : db=default
tbl=requests_stat_min
11/02/07 20:10:35 INFO hive.log: DDL: struct requests_stat_min { string
time, i64 request_count, i64 get_count, i64 post_count, i64 unique_orders,
i64 unique_events, i64 start_orders, i32 max_response_time, i32
min_response_time, i32 avg_response_time, i32 max_response_size, i32
min_response_size, i32 avg_response_size, i64 unique_referrers}
11/02/07 20:10:35 INFO parse.SemanticAnalyzer: Get metadata for subqueries
11/02/07 20:10:35 INFO parse.SemanticAnalyzer: Get metadata for destination
tables
11/02/07 20:10:35 WARN conf.Configuration: hdfs-site.xml:a attempt to
override final parameter: dfs.data.dir; Ignoring.
11/02/07 20:10:35 INFO parse.SemanticAnalyzer: Completed getting MetaData in
Semantic Analysis
FAILED: Error in semantic analysis: line 1:7 Invalid Function
histogram_numeric
11/02/07 20:10:35 ERROR ql.Driver: FAILED: Error in semantic analysis: line
1:7 Invalid Function histogram_numeric
org.apache.hadoop.hive.ql.parse.SemanticException: line 1:7 Invalid Function
histogram_numeric
at
org.apache.hadoop.hive.ql.parse.TypeCheckProcFactory$DefaultExprProcessor.getXpathOrFuncExprNodeDesc(TypeCheckProcFactory.java:560)
at
org.apache.hadoop.hive.ql.parse.TypeCheckProcFactory$DefaultExprProcessor.process(TypeCheckProcFactory.java:661)
at
org.apache.hadoop.hive.ql.lib.DefaultRuleDispatcher.dispatch(DefaultRuleDispatcher.java:80)
at
org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.dispatch(DefaultGraphWalker.java:83)
at
org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.walk(DefaultGraphWalker.java:117)
at
org.apache.hadoop.hive.ql.lib.DefaultGraphWalker.startWalking(DefaultGraphWalker.java:95)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genExprNodeDesc(SemanticAnalyzer.java:4509)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genSelectPlan(SemanticAnalyzer.java:1479)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genBodyPlan(SemanticAnalyzer.java:3743)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genPlan(SemanticAnalyzer.java:4184)
at
org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(SemanticAnalyzer.java:4425)
at
org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(BaseSemanticAnalyzer.java:76)
at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:249)
at org.apache.hadoop.hive.ql.Driver.run(Driver.java:281)
at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:123)
at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:181)
at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:287)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.hadoop.util.RunJar.main(RunJar.java:156)
