About EricL

EricL · ‎03-06-2017

If the PROFILES showed the same performance, then you can turn on the debug logs for JDBC to see which part it was slow, add the following to the JDBC connection string: ;LogLevel=6;LogPath=/path/to/directory Then examine the debug log create under the directory after you run the query.

EricL · ‎01-01-2017

Hi, I see that you are using IP address 192.168.53.121 for the impala daemon host, can you pleaes use the FQDN for the impala host? The one that matches host defined with the kerberos principal, like impala/<full-domain>@REALM. Hope that can help. I have tested and it works by using the domain, but IP address will fail.

EricL · ‎01-01-2017

Hi, I believe that those errors were from client output, can you also paste the error from the Oozie server log? Do you have Kerberos enabled? Did you mean that all Oozie commands fail with the same error?

EricL · ‎12-14-2016

Looks like this thread is old, but I would like to add that this was a HiveMetaStore issue, so it should be going into HiveMetaStore safety valve. Cheers

EricL · ‎12-14-2016

Hi, Impala JDBC driver is not Open Source, as it contains proprietary code that makes it more performant and featureful, as a result, no public maven respository available for it. We do publish the Apache version of JDBC driver however, though they are not the same and contain different features. Hope that answers your question.

EricL · ‎12-13-2016

Hi, The JSON class in json-serde-1.3.7-jar-with-dependencies.jar is org.openx.data.jsonserde.JsonSerDe, not com.cloudera.hive.SERDE.JSONSerDe. So did you mean to use com.cloudera.hive.SERDE.JSONSerDe or org.openx.data.jsonserde.JsonSerDe? Can you give me the output of : jar tf /usr/lib/hive/lib/hive-serdes-1.0-SNAPSHOT.jar so that I can confirm the classes in this jar? Thanks

EricL · ‎12-13-2016

Hi, I can see the images now, but not sure why they did not show up before. I can see that you are trying to run a query that contains: (rel.i_prtitn,rel.i_mod_yr) in (select * from my_prtitn) I would like you know that this is currently not supported, please refer to Hive's Apache documentation below: https://cwiki.apache.org/confluence/display/Hive/LanguageManual+SubQueries It mentions the following: IN/NOT IN subqueries may only select a single column If you want to acheive the same goal, you will need to use JOIN with subQuery on those two columns. Hope this helps. Regards Eric

EricL · ‎12-13-2016

Hi, Based on the error from NM log, I can see the following Dec 13, 3:43:51.255 PM ERROR org.apache.hadoop.yarn.server.nodemanager.NodeManager RECEIVED SIGNAL 15: SIGTERM This looks like that it is killed by some other process, but not sure what. Do you use Cloudera Manager? If yes, can you check the logs under /var/log/cloudera-scm-agent and see if you can find any clues? You can also check under /var/run/cloudera-scm-agent/process/*NODEMANAGER*, find one that was the most recent one and check for "logs" directory for logs. Regards

EricL · ‎12-08-2016

Do I miss anything? I don't see what are in the two pictures..

EricL · ‎11-18-2016

Hi, Can you please give a bit more information regarding what sanity check you want to perform? For what compoenent? (MR, YARN, Oozie?) Thanks

Online	Offline
Last Visited	‎08-12-2020 03:17 AM

Member Since	‎03-23-2015 01:24 PM
Last Visited	‎08-12-2020 03:17 AM
Posts	1,288
Kudos received	113

Cloudera Community

Re: max() function generating an error in sqoop

Re: Add a dynamic variable to a Hive view

Re: Hive Server 2 failing to start CDP ,Cloudera M...

Re: Sqoop export from hive to teradata - > issue ...

Re: Cloudera Hadoop internal workings

Re: Impala JDBC 10x Slower Vs. Shell

Re: connect kerberozied cluster from impyla in win...

Re: Oozie Error

Re: Potential misconfiguration detected - Hue - Hi...

Re: Impala JDBC is not in maven repo

Re: Where to put json-serde-1.3.7-jar-with-depend...

Re: multiple columns in where clause not working i...

Re: Unable to start YARN - Error starting NodeMana...

Re: multiple columns in where clause not working i...

Re: Fire sanity check manually?