@torafca5   Could you please try downloading the jar from the below link,   http://www.congiu.net/hive-json-serde/1.3.8/hdp23/json-serde-1.3.8-jar-with-dependencies.jar   Once the jar is downloaded, move the jar to the location /usr/hdp/3.0.1.0-187/hive/lib. Please place the jar on all the nodes hosting Hive services. Also, please make sure you are not using LLAP(HiveserverInteractive) to connect to the hive. add jar command does not work with LLAP.   implementing the above recommendation should help overcome this issue. ... View more

Hello Sir I got the output as below but I am not getting any data do you know why?   hive> select * from BOOKDATA; OK Hadoop Defnitive Guide 24.9 Programming Pig 30.9 Time taken: 0.081 seconds, Fetched: 2 row(s) ... View more

@elan chelian this line tells that job is going on a machine that have 1GB of resource. MAP capability required is more than the supported max container capability in the cluster. Killing the Job. mapResourceRequest: <memory:2048, vCores:1> maxContainerCapability:<memory:1024, vCores:3> Job received Kill while in R You can reduce the container size to 1GB and run the sqoop import. Try to run modified command: sqoop import -D mapreduce.map.memory.mb=1024 -D mapreduce.map.java.opts=-Xmx768m --connect jdbc:oracle:thin:@oracledbhost:1521:VAEDEV --table WC_LOY_MEM_TXN --username OLAP -P -m 1 ... View more

Thanks @neeraj overlooked the yum errors in the logs. I created a local repository with Oracle 6.4 media but that resulted in lot of error as most of the previous packges in the system was updated using the latest Oracle Public Repository so I have manually installed fuse and all other rpms demanded by Deployement wizard. And then started the deployment. It went well.. Cluster is now up and running. ... View more

Hi, I'm trying to configure this in my ambari 2.5.0.3 with Hive 1.2.1. When I try to connect to hive using jdbc the following error is thrown: WARN jdbc.HiveConnection: Failed to connect to localhost:10500 Error: Could not open client transport with JDBC Uri: jdbc:hive2://localhost:10500: Peer indicated failure: Error validating the login (state=08S01,code=0) ... View more