Re: When i run the query it's executed but the out...

surendaran · ‎02-11-2020

@venkatsambathIt's working thank you.

surendaran · ‎02-11-2020

@venkatsambathevery thing i ok in table but still i am facing the same problem. I am load my data from local to hive.

surendaran · ‎02-10-2020

@venkatsambath We are not using CDH. We have configured Hadoop ecosystem separately in Ubuntu 18.04 (Hadoop 2.6.0, Hive 2.1.1). When using the select query without using insert line and run the query i am getting same problem in hive.

surendaran · ‎02-10-2020

2020-02-10 16:28:56 Starting to launch local task to process map join; maximum memory = 477626368 SELECT n.Id, t.job_id, t.job_title, n.Name, n.Email, n.Mobile_Number, n.Education, n.Total_Experiance, n.project_id, ((count(n.new_skills)*100)/s.skill_count) Average FROM rmt_demo.resume_convert n JOIN rmt_demo.job_description_convert t ON n.new_skills = t.skills and n.job_position = t.job_title JOIN rmt_demo.skill_count s ON n.job_position = s.job_title JOIN rmt_demo.education e ON n.education = e.education GROUP BY n.Id,t.job_id,t.job_title, n.Name, n.Email, n.Mobile_Number, n.Education, n.Total_Experiance,n.project_id,s.skill_count;

surendaran · ‎08-23-2019

I solved this issue by replacing the below line hive-site.xml <name>hive.downloaded.resources.dir</name> <value>/tmp/hive/${hive.session.id}_resources</value> </property> <property> <name>hive.scratch.dir.permission</name> <value>777</value>

surendaran · ‎08-22-2019

surendaran · ‎08-08-2019

surendaran · ‎06-26-2019

@Geoffrey Shelton Okot No same jar problem exits when i run sqoop job.

surendaran · ‎06-26-2019

@Jay Kumar SenSharma I have created a directory and added all sqoop jar to hdfs://localhost:54310/usr/local/sqoop/lib/ and Sqoop 1.4.7 jar to it at last it worked But getting this error can you help thanks for your kindly reply

surendaran · ‎06-26-2019

Is this method correct and thanks for kindly reply Geoffrey Shelton Okot

surendaran · ‎06-25-2019

I'm getting this error please help me ERROR tool.ImportTool: Import failed: java.io.FileNotFoundException: File does not exist: hdfs://localhost:54310/usr/local/sqoop/lib/parquet-hadoop-1.6.0.jar

Online	Offline
Last Visited	‎02-11-2020 11:10 PM

Date Registered	‎06-25-2019 11:30 AM
Last Visited	‎02-11-2020 11:10 PM
Total Messages Posted	12

Re: When i run the query it's executed but the out...

Re: When i run the query it's executed but the out...

Re: When i run the query it's executed but the out...

When i run the query it's executed but the output ...

Re: I'm getting this error while connecting power ...

I'm getting this error while connecting power bi w...

im using sqoop 1.4.7 and hadoop 2.6.0 while import...

Re: I'm importing data from windows sql server to ...

Re: I'm importing data from windows sql server to ...

Re: I'm importing data from windows sql server to ...

I'm importing data from windows sql server to ubun...