hadoop - Hive wont run in Hortonworks 2.2.4 -

i've downloaded hortonworks sandbox 2.2.4, , noticed when follow hortonwork's tutorial on hive, this,

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 '\\t';",     "error": "unable create table: nyse_stocks",     "exec": {         "stdout": "",         "stderr": "         15/05/05 09:57:50 warn conf.hiveconf: hiveconf of name hive.heapsize not exist         15/05/05 09:57:50 warn conf.hiveconf: hiveconf of name hive.server2.enable.impersonation 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 explanation.         slf4j: actual binding of type [org.slf4j.impl.log4jloggerfactory]         command  terminated due timeout(60000ms).  see templeton.exec.timeout property",         "exitcode": 143     } }(error500) 

when ssh sandbox, , type hive on shell, output inside stderr,

15/05/05 09:57:50 warn conf.hiveconf: hiveconf of name hive.heapsize not exist 15/05/05 09:57:50 warn conf.hiveconf: hiveconf of name hive.server2.enable.impersonation 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 explanation. slf4j: actual binding of type [org.slf4j.impl.log4jloggerfactory] 

what solution this?

there problem (due incompatibility) serde jar, inside sandbox. had same problem , after few googles, found solution @ https://github.com/brandonswilson.

here did:

a-)removed first line hiveddl.sql

b-)changed line 34 to: row format serde 'org.apache.hive.hcatalog.data.jsonserde'

that's it!

(after run hive -f hiveddl.sql got problem @ line 119:

-- failed: semanticexception unrecognized file format in stored clause: 'rcfilese' --

was: stored rcfilese

i changed to: stored rcfile

you try change before run.)

daniel galizi.