About EricL

EricL · ‎03-21-2018

when you say "not visible in web browser of cloudera", did you mean in Hue interface or NN web UI? If no new directory you created, what do you see? Screenshot would be helpful here.

EricL · ‎12-31-2017

I don't see what exact query was sent to HS2 to run that caused the issue. But from the error message, it looks like that there is some issue on the query string itself. This could happen when there is bugs in the HIve JDBC driver that you are using and does not tramsform query correctly. Couple of things you can check: 1. what version of JDBC driver are you using? If not latest, maybe try the latest version: https://www.cloudera.com/downloads/connectors/hive/jdbc/2-5-19.html 2. Check if UseNativeQuery is set or not, Default is 0, meaning it will transform query inside JDBC before sending to HS2. You can try to set it to 1 to disable transformation. Details can be found here: http://www.cloudera.com/documentation/other/connectors/hive-jdbc/latest/Cloudera-JDBC-Driver-for-Apache-Hive-Install-Guide.pdf

EricL · ‎12-31-2017

Hi, I am not sure if you have noticed Robert's response on the thread you mentioned. Run below command from the remote host to see if you can set response back to test if the GET command works: curl http://oozie_host:oozie_port/oozie/v2/admin/status

EricL · ‎12-16-2017

HiveServer2 will NOT count session as idle if query is still running, so, a query can run longer than the session timeout, so long as the query is running, but not waiting for client to fetch data. Please refer to https://issues.apache.org/jira/browse/HIVE-10146. This looks like it is F5's issue that it does not know query is still running, which makes sense. Having keep alive pings to HS2 will make Hive Session timeout setting useless, I am not sure if that is best practice either.

EricL · ‎12-16-2017

Can you please enable JDBC driver TRACE log by adding: ;LogLevel=6;LogPath=/tmp/jdbc-log to the end of JDBC connection string and collect trace log, there might be clues there. Also, have you checked the impala daemon log on host beta01.opr.test.XYZ.COM to see if there is any error messages related?

EricL · ‎11-30-2017

It looks like that HS2 did not start correctly. Have you checked HS2 log to see what might be going on? Please also check if HMS is up and running. If HMS failed to start, HS2 will not able to either.

EricL · ‎11-15-2017

How much heap does Oozie has? Have you noticed GC hangs in the Oozie server. That might hang the Oozie process and potentially causing the timeout on client connection from CM. Worth checking this to rule out.

EricL · ‎11-14-2017

It will not work, you should remove all special characters in column names. There is no workarounds as far as I know.

EricL · ‎11-14-2017

Have you checked what error do you see in the Ooize server log? This looks like CM was not able to access Oozie for some reason, the Oozie server log might give you some clue.

EricL · ‎11-14-2017

Hi, Are you able to update the view while you updating the table with new columns? I don't see there is other better ways as VIEWs and TABLEs are different entities in Hive and they don't relate to each other. Let me research a bit more.

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: I have created a directory in hdfs but cant se...

Re: SQL Query Failed with Cloudera Hive JDBC drive...

Re: Simple 'ls -l" hue-oozie SSH Action Node ...

Re: Keep alive configuration for Hive clients work...

Re: java.lang.RuntimeException: [Simba][ImpalaJDBC...

Re: Could not connect to quickstart.cloudera:10000...

Re: Oozie server is getting in bad health- OOZIE_S...

Re: Symbols in Column name

Re: Oozie server is getting in bad health- OOZIE_S...

Re: describe view not updated with additional colu...