Support Questions
Find answers, ask questions, and share your expertise

Error while selecting data from hive using presto

Error while selecting data from hive using presto

Contributor

I have installed presto on a node like this post suggest.. ..https://community.hortonworks.com/articles/10485/introduction-to-presto.html but while accessing data from presto server ..i am getting below error:-

Query 20170110_163302_00007_ejqm4 failed: HDFS error reading from hdfs://HADOOP02/apps/hive/warehouse/test/000001_0 at position 0

I have installed Hadoop CLI and is able to get the data from hadoop server using hadoop fs -get /filepath/ .

Can someone point out what i am missing

Presto : (latest) ) 0.162

Hadoop HDP 2.3.2

1 REPLY 1

Re: Error while selecting data from hive using presto

Cloudera Employee

Did you set the hadoop xml files in hive.properties (connector setting file)?

If not, I think you can have a try.

Reference URL: https://community.hortonworks.com/articles/10485/introduction-to-presto.html

hive.properties

hive.config.resources=/etc/hadoop/conf/core-site.xml,/etc/hadoop/conf/hdfs-site.xml