About EricL

EricL · ‎06-12-2020

Hi Heri, Glad that it helped and thanks for the info. Cheers Eric

EricL · ‎06-11-2020

Sorry, can you try below instead? select max(id) as id from NodeName a where $CONDITIONS BTW, do you really just want to import single MAX value into HDFS?

EricL · ‎06-10-2020

Hi Heri, As mentioned in the error: if using free form query import (consider adding clause AS if you're using column transformation) You max(id) aggregate function does not have "AS" clause, please change your query to below and try again: select max(id) as max_id from NodeName a where $CONDITIONS Cheers Eric

EricL · ‎04-21-2020

Hi @SwasBigData , As Ferenc pointed out, In CDP, HiveServer2 and HiveMetaStore are separated into different services. The Hive Service now only contains HMS, and HiveServer2 is included in the Hive on Tez service. So to install Hive on Tez, you have to install Hive Service first, which will setup HMS. Can you please share more details on what error you got when trying to setup Hive on Tez? Thanks Eric

EricL · ‎03-18-2020

@Manus , Can you please share the error from Beeline and HS2 log? Without them, it is difficult to see what is going on. Cheers Eric

EricL · ‎03-04-2020

Great catch @bgooley!!

EricL · ‎02-28-2020

Hi @HadoopBD, The log you provided is RM log, not application log that Ben asked earlier. Please run below command: yarn logs -applicationId application_1582677468069_0009 > application_1582677468069_0009.log And then find the snippet that has the error, as the log will likely to be very big. I also noticed that the log you provided earlier contained your domain name, if you have concerns, we can redact them for you. Please advise. Thanks Eric

EricL · ‎02-27-2020

@HadoopBD , If possible, if you can attach log as a file to this thread, it would be better, as the log messages make the page lengthy and hard to navigate around. Cheers

EricL · ‎02-27-2020

@wert_1311, Venkat's first link seems to be broken, I will share again here: https://blog.cloudera.com/how-does-cloudera-manager-work/ And official doc is here: https://docs.cloudera.com/documentation/enterprise/6/6.3/topics/cloudera_manager.html I also wrote one basic blog on Cloudera Management services, not sure if it can help: https://www.ericlin.me/2019/11/introduction-to-cloudera-management-services-part-1/ Cheers Eric

EricL · ‎02-05-2020

Glad it works now, thanks for sharing. Cheers

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: Hive Server 2 failing to start CDP ,Cloudera M...

Re: Cloudera Hadoop internal workings

Re: Cloudera Manager APIs

Re: HDFS folder permission denied, but the user is...

Re: max() function generating an error in sqoop

Re: max() function generating an error in sqoop

Re: max() function generating an error in sqoop

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

Re: Facing transport exception in hive

Re: ALL hadoop-mapreduce-examples.jar fail cdh6

Re: ALL hadoop-mapreduce-examples.jar fail cdh6

Re: ALL hadoop-mapreduce-examples.jar fail cdh6

Re: Cloudera Hadoop internal workings

Re: Hiveserver2 not starting