hadoop - Hive 不会在 Hortonworks 2.2.4 中运行

Question

我刚刚下载了 Hortonworks Sandbox 2.2.4，当我关注 Hortonwork's tutorial on Hive 时我注意到了，我明白了，

HCatClienterroroncreatetable: {
    "statement": "use default; create table nyse_stocks(`exchange` string, `stock_symbol` string, `date` string, `stock_price_open` float, `stock_price_high` float, `stock_price_low` float, `stock_price_close` float, `stock_volume` bigint, `stock_price_adj_close` float) row format delimited fields terminated by '\\t';",
    "error": "unable to create table: nyse_stocks",
    "exec": {
        "stdout": "",
        "stderr": "
        15/05/05 09:57:50 WARN conf.HiveConf: HiveConf of name hive.heapsize does not exist
        15/05/05 09:57:50 WARN conf.HiveConf: HiveConf of name hive.server2.enable.impersonation does not exist
        SLF4J: Class path contains multiple SLF4J bindings.
        SLF4J: Found binding in [jar:file:/usr/hdp/2.2.4.2-2/hadoop/lib/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class]
        SLF4J: Found binding in                                                         [jar:file:/usr/hdp/2.2.4.2-2/hive/lib/hive-jdbc-0.14.0.2.2.4.2-2-standalone.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]
        Command  was terminated due to timeout(60000ms).  See templeton.exec.timeout property",
        "exitcode": 143
    }
}(error500)

当我通过 ssh 进入沙箱时，我只需在 shell 上键入 hive，我就会在 stderr 中得到这个输出，

15/05/05 09:57:50 WARN conf.HiveConf: HiveConf of name hive.heapsize does not exist
15/05/05 09:57:50 WARN conf.HiveConf: HiveConf of name hive.server2.enable.impersonation does not exist
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/usr/hdp/2.2.4.2-2/hadoop/lib/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in                                                         [jar:file:/usr/hdp/2.2.4.2-2/hive/lib/hive-jdbc-0.14.0.2.2.4.2-2-standalone.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]

有什么解决方案？

Answer 1

沙箱内的 SerDe jar 存在问题(由于不兼容)。我遇到了同样的问题，经过几次谷歌搜索后，我在以下位置找到了解决方案 https://github.com/brandonswilson .

这是我做的:

a-)从 hiveddl.sql 中删除了第一行

b-) 将第 34 行更改为:行格式 SERDE 'org.apache.hive.hcatalog.data.JsonSerDe'

就是这样!

(运行 hive -f hiveddl.sql 后，我在第 119 行遇到问题:

-- 失败:语义异常 STORED AS 子句中无法识别的文件格式:'RCFILESE' --

是:存储为 RCFilese

我改为:存储为 RCFile

你可以在运行之前尝试更改。)

丹尼尔·加利兹。