Styjun

When is it legal to castle moving the rook first?

What exactly is a softlock?

Archiving processor does not archive

Why do we need explainable AI?

Does POSIX guarantee the paths to any standard utilities?

Count rook moves 1D

What would a biological creature need in order to see the future?

Were the women of Travancore, India, taxed for covering their breasts by breast size?

How does Harry wear the invisibility cloak?

Does this bike use hydraulic brakes?

Is there any reason to change the ISO manually?

To which airspace does the border of two adjacent airspaces belong to?

Why did the Joi advertisement trigger K?

How can I let authenticated users rebuild caches?

Everyone for non livings

What is the most likely cause of short, quick, and useless reviews?

Plotting level sets of the form f(x,y,c)==0

How can I use arrays in a PGF axis environment?

Would you recommend a keyboard for beginners with or without lights in keys for learning?

What does "se jouer" mean here?

Do I need to get a noble in order to win Splendor?

Is mathematics truth?

Confusion in understanding control system?

How do I name the individual parts of the lumbricals muscle of the foot in latin?

How to run presto queries in python using pyhive?

How do I check whether a file exists without exceptions?Calling an external command in PythonWhat are metaclasses in Python?Is there a way to run Python on Android?How can I safely create a nested directory?Does Python have a ternary conditional operator?How to get the current time in PythonHow can I make a time delay in Python?Does Python have a string 'contains' substring method?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

I am trying to run presto query in python using pyhive library but max retries error is coming. I am running it in jupyter notebook locally(laptop). I think its not able to connect to presto node. I am using Azure hdinsight cluster and installed presto application on head node(using starburst distribution). I have used cluster user name and password and also i have tried head node ssh user and password but nothing is working. Below is my code:

from pyhive import presto
conn= presto.connect(
 host='clustername-ssh.azurehdinsight.net',
 port=8085,
 username='sshuser'
 password='sshpassword',
 protocol='https'
 ).cursor()
conn.execute('SELECT * FROM hive.default.parquettest limit 1')

The error i am getting is:

ConnectionError:
HTTPConnectionPool(host='sm-hdinsight01-ssh.azurehdinsight.net',
port=8085): Max retries exceeded with url: /v1/statement (Caused by
NewConnectionError(': Failed to establish a new connection: [Errno 110]
Connection timed out',))

But when i am running it in terminal of head node it works:

from pyhive import presto
conn= presto.connect(
 host='localhost',
 port=8085).cursor()
conn.execute('SELECT * FROM hive.default.parquettest limit 1')

I think i am missing some crucial thing here. please help.

python database-connection hdinsight presto pyhive

share|improve this question

edited Mar 28 at 4:47

Bhanuday Birla

asked Mar 27 at 13:06

Bhanuday BirlaBhanuday Birla

32133 silver badges1616 bronze badges

add a comment | 

0

I am trying to run presto query in python using pyhive library but max retries error is coming. I am running it in jupyter notebook locally(laptop). I think its not able to connect to presto node. I am using Azure hdinsight cluster and installed presto application on head node(using starburst distribution). I have used cluster user name and password and also i have tried head node ssh user and password but nothing is working. Below is my code:

from pyhive import presto
conn= presto.connect(
 host='clustername-ssh.azurehdinsight.net',
 port=8085,
 username='sshuser'
 password='sshpassword',
 protocol='https'
 ).cursor()
conn.execute('SELECT * FROM hive.default.parquettest limit 1')

The error i am getting is:

ConnectionError:
HTTPConnectionPool(host='sm-hdinsight01-ssh.azurehdinsight.net',
port=8085): Max retries exceeded with url: /v1/statement (Caused by
NewConnectionError(': Failed to establish a new connection: [Errno 110]
Connection timed out',))

But when i am running it in terminal of head node it works:

from pyhive import presto
conn= presto.connect(
 host='localhost',
 port=8085).cursor()
conn.execute('SELECT * FROM hive.default.parquettest limit 1')

I think i am missing some crucial thing here. please help.

python database-connection hdinsight presto pyhive

share|improve this question

edited Mar 28 at 4:47

Bhanuday Birla

asked Mar 27 at 13:06

Bhanuday BirlaBhanuday Birla

32133 silver badges1616 bronze badges

add a comment | 

I am trying to run presto query in python using pyhive library but max retries error is coming. I am running it in jupyter notebook locally(laptop). I think its not able to connect to presto node. I am using Azure hdinsight cluster and installed presto application on head node(using starburst distribution). I have used cluster user name and password and also i have tried head node ssh user and password but nothing is working. Below is my code:

from pyhive import presto
conn= presto.connect(
 host='clustername-ssh.azurehdinsight.net',
 port=8085,
 username='sshuser'
 password='sshpassword',
 protocol='https'
 ).cursor()
conn.execute('SELECT * FROM hive.default.parquettest limit 1')

The error i am getting is:

ConnectionError:
HTTPConnectionPool(host='sm-hdinsight01-ssh.azurehdinsight.net',
port=8085): Max retries exceeded with url: /v1/statement (Caused by
NewConnectionError(': Failed to establish a new connection: [Errno 110]
Connection timed out',))

But when i am running it in terminal of head node it works:

from pyhive import presto
conn= presto.connect(
 host='localhost',
 port=8085).cursor()
conn.execute('SELECT * FROM hive.default.parquettest limit 1')

I think i am missing some crucial thing here. please help.

python database-connection hdinsight presto pyhive

share|improve this question

edited Mar 28 at 4:47

Bhanuday Birla

asked Mar 27 at 13:06

Bhanuday BirlaBhanuday Birla

32133 silver badges1616 bronze badges

from pyhive import presto
conn= presto.connect(
 host='clustername-ssh.azurehdinsight.net',
 port=8085,
 username='sshuser'
 password='sshpassword',
 protocol='https'
 ).cursor()
conn.execute('SELECT * FROM hive.default.parquettest limit 1')

from pyhive import presto
conn= presto.connect(
 host='localhost',
 port=8085).cursor()
conn.execute('SELECT * FROM hive.default.parquettest limit 1')

share|improve this question

edited Mar 28 at 4:47

Bhanuday Birla

asked Mar 27 at 13:06

Bhanuday BirlaBhanuday Birla

32133 silver badges1616 bronze badges

share|improve this question

edited Mar 28 at 4:47

Bhanuday Birla

asked Mar 27 at 13:06

Bhanuday BirlaBhanuday Birla

32133 silver badges1616 bronze badges

asked Mar 27 at 13:06

Bhanuday BirlaBhanuday Birla

32133 silver badges1616 bronze badges

asked Mar 27 at 13:06

Bhanuday BirlaBhanuday Birla

32133 silver badges1616 bronze badges