Call From sandbox-hdp.hortonworks.com/172.18.0.2 to localhost:8020 failed on connection exception

I use Hortonworks Sandbox HDP 2.6.5 and putty to use Linux shell. My OS is window10.

I put some JSON file on HDFS and I want to open this file with pyspark.

I use below python file on linux, typing "spark-submit example.py" on shell

from pyspark.sql import SparkSession



if __name__ == "main":

    spark = SparkSession.builder.appName('JSONRead').getOrCreate()



    jsonData = spark.read.json('hdfs://localhost/user/maria_dev/example.json')

    jsonData.printSchema()

    jsonData.createOrReplaceTempView('Users')



    userNames = spark.sql('SELECT _id, name, age, email, phone, gender, index from Users')



    spark.stop()

But I got this error message

"Call From sandbox-hdp.hortonworks.com/172.18.0.2 to localhost:8020 failed on connection exception"

I searched this problem on stackoverflow and people usually said name node is running different port or not run. But I don't know how to know name node's status and how to restart it.

I typed "sudo service hadoop-hdfs-namenode restart"
But putty return "Unit hadoop-hdfs-namenode.service could not be found."

What can I do? Can you help me please?

edited Nov 21 '18 at 2:24

asked Nov 20 '18 at 15:09

James Shin

Edit your question and include your code directly in your question. Including it as an image prevents anyone from trying it and trying to help you.

– Dave
Nov 20 '18 at 15:38

add a comment |

I use Hortonworks Sandbox HDP 2.6.5 and putty to use Linux shell. My OS is window10.

I put some JSON file on HDFS and I want to open this file with pyspark.

I use below python file on linux, typing "spark-submit example.py" on shell

from pyspark.sql import SparkSession



if __name__ == "main":

    spark = SparkSession.builder.appName('JSONRead').getOrCreate()



    jsonData = spark.read.json('hdfs://localhost/user/maria_dev/example.json')

    jsonData.printSchema()

    jsonData.createOrReplaceTempView('Users')



    userNames = spark.sql('SELECT _id, name, age, email, phone, gender, index from Users')



    spark.stop()

But I got this error message

"Call From sandbox-hdp.hortonworks.com/172.18.0.2 to localhost:8020 failed on connection exception"

I searched this problem on stackoverflow and people usually said name node is running different port or not run. But I don't know how to know name node's status and how to restart it.

I typed "sudo service hadoop-hdfs-namenode restart"
But putty return "Unit hadoop-hdfs-namenode.service could not be found."

What can I do? Can you help me please?

edited Nov 21 '18 at 2:24

asked Nov 20 '18 at 15:09

James Shin

Edit your question and include your code directly in your question. Including it as an image prevents anyone from trying it and trying to help you.

– Dave
Nov 20 '18 at 15:38

add a comment |

I use Hortonworks Sandbox HDP 2.6.5 and putty to use Linux shell. My OS is window10.

I put some JSON file on HDFS and I want to open this file with pyspark.

I use below python file on linux, typing "spark-submit example.py" on shell

from pyspark.sql import SparkSession



if __name__ == "main":

    spark = SparkSession.builder.appName('JSONRead').getOrCreate()



    jsonData = spark.read.json('hdfs://localhost/user/maria_dev/example.json')

    jsonData.printSchema()

    jsonData.createOrReplaceTempView('Users')



    userNames = spark.sql('SELECT _id, name, age, email, phone, gender, index from Users')



    spark.stop()

But I got this error message

"Call From sandbox-hdp.hortonworks.com/172.18.0.2 to localhost:8020 failed on connection exception"

I searched this problem on stackoverflow and people usually said name node is running different port or not run. But I don't know how to know name node's status and how to restart it.

I typed "sudo service hadoop-hdfs-namenode restart"
But putty return "Unit hadoop-hdfs-namenode.service could not be found."

What can I do? Can you help me please?

edited Nov 21 '18 at 2:24

asked Nov 20 '18 at 15:09

James Shin

I use Hortonworks Sandbox HDP 2.6.5 and putty to use Linux shell. My OS is window10.

I put some JSON file on HDFS and I want to open this file with pyspark.

I use below python file on linux, typing "spark-submit example.py" on shell

from pyspark.sql import SparkSession



if __name__ == "main":

    spark = SparkSession.builder.appName('JSONRead').getOrCreate()



    jsonData = spark.read.json('hdfs://localhost/user/maria_dev/example.json')

    jsonData.printSchema()

    jsonData.createOrReplaceTempView('Users')



    userNames = spark.sql('SELECT _id, name, age, email, phone, gender, index from Users')



    spark.stop()

But I got this error message

"Call From sandbox-hdp.hortonworks.com/172.18.0.2 to localhost:8020 failed on connection exception"

I searched this problem on stackoverflow and people usually said name node is running different port or not run. But I don't know how to know name node's status and how to restart it.

I typed "sudo service hadoop-hdfs-namenode restart"
But putty return "Unit hadoop-hdfs-namenode.service could not be found."

What can I do? Can you help me please?

hadoop pyspark connection-refused namenode hortonworks-sandbox

edited Nov 21 '18 at 2:24

asked Nov 20 '18 at 15:09

James Shin

edited Nov 21 '18 at 2:24

asked Nov 20 '18 at 15:09

James Shin

edited Nov 21 '18 at 2:24

asked Nov 20 '18 at 15:09

James Shin

asked Nov 20 '18 at 15:09

James Shin

asked Nov 20 '18 at 15:09

James Shin

Edit your question and include your code directly in your question. Including it as an image prevents anyone from trying it and trying to help you.

– Dave
Nov 20 '18 at 15:38

add a comment |

Edit your question and include your code directly in your question. Including it as an image prevents anyone from trying it and trying to help you.

– Dave
Nov 20 '18 at 15:38

Edit your question and include your code directly in your question. Including it as an image prevents anyone from trying it and trying to help you.

– Dave
Nov 20 '18 at 15:38

add a comment |

0

active

oldest

votes

Your Answer

StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53395954%2fcall-from-sandbox-hdp-hortonworks-com-172-18-0-2-to-localhost8020-failed-on-con%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

0

active

oldest

votes

0

active

oldest

votes

draft saved

draft discarded

Thanks for contributing an answer to Stack Overflow!

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

Search This Blog

Ufyukyu