About deepesh1

deepesh1 · ‎12-22-2015

Make sure the jar file being referenced by the function has adequate permissions on hdfs. Is it the same user accessing this from hive cli and hiveserver2? Depending on hive.server2.enable.doAs setting your hiveserver2 user could be hive or the connecting user from JDBC.

deepesh1 · ‎12-19-2015

Perhaps what you want is a CTAS statement not a CTE. create table q as select CLAIMNUMBER,EXP_ID,EXP_COVERAGE,VEHICLE_STYLE from orc_claiminfo where VEHICLE_STYLE != "" AND EXP_COVERAGE = "Property Damage - Vehicle Damage" This way you can use table q later.

deepesh1 · ‎12-17-2015

Can you check if there is a mismatch of serde? Example you may have non-text data inside your external table location whereas your table is expecting text.

deepesh1 · ‎12-17-2015

Are you using Ambari 2.1 and HDP-2.2+? Ambari documentation has instructions to add new HiveServer2 to a node in the cluster.

deepesh1 · ‎12-15-2015

Any local user that wants to start YARN application also needs a home directory (/user/<user>) on the HDFS as well. I am guessing Tez is enabled in your environment and part of initializing hive cli is bringing up a YARN application which might be failing.

deepesh1 · ‎12-15-2015

Looking at your attachments, it looks like you are trying to launch hive cli as root user. Make sure /user/root exists on HDFS and is owned by root user. If it's not so, login/sudo as hdfs user and run the following commands: hadoop fs -mkdir /user/root hadoop fs -chmod -R 755 /user/root hadoop fs -chown -R root:root /user/root Launch the hive cli after that.

deepesh1 · ‎12-14-2015

You can kill the jobs that you want to remove from the queue: yarn application -kill <applicationId>

deepesh1 · ‎12-11-2015

Check if the services are up, looks like your Job History Server may be down.

deepesh1 · ‎12-11-2015

Try the following, lets assume your hive.tez.container.size=2048. set hive.tez.java.opts=-Xmx1640m (0.8 times hive.tez.container.size) set tez.runtime.io.sort.mb=820 (0.4 times hive.tez.container.size) set tez.runtime.unordered.output.buffer.size-mb=205 (0.1 times hive.tez.container.size)

deepesh1 · ‎12-11-2015

Can you print the whole console output? The error here doesn't tell much.

Online	Offline
Last Visited	‎05-09-2018 06:03 AM

Member Since	‎09-25-2015 05:14 PM
Last Visited	‎05-09-2018 06:03 AM
Posts	356
Kudos received	379

Cloudera Community

Re: Hive 2 is missing after HDP upgrade

Re: Is Hortonworks HDP 2.6.0 supports Centos 6.9

Re: Add Service - BigSQL fails

Re: hi , I am having trouble connecting to beeline...

Re: Hive Metastore throws a null pointer exception

Re: Error executing a hive UDF through jbdc

Re: ParseException line 1:162 cannot recognize inp...

Re: Hive : Failed with exception java.io.IOExcepti...

Re: Multi HiveServer2

Re: Not able to start Hive on HDP sandbox

Re: Not able to start Hive on HDP sandbox

Re: How do I remove these dead jobs from my queue?

Re: Failed to read data from "/user/guest/Batting....

Re: Hive on Tez query Map output OutOfMemoryError:...

Re: Failed to read data from "/user/guest/Batting....