Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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
Highlighted

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