We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now

Querying data from HDFS. — Vertica Forum

Querying data from HDFS.

RohitM

RohitM

January 2018 in General Discussion

Hi, We have installed Hortonworks 2.5 and Vertica 9. Anyone having steps to query data directly from hdfs or using Hcatalog. We can use any one of these. I have read through vertica 9 documentation but not getting exact steps needs to be done on Hadoop and vertica nodes.
Thanks

1

Comments

Jim_Knicely - Select Field - Administrator

January 2018 edited January 2018

Hi,

It's super easy to access data in Hadoop from Vertica!

First, make sure to review and perform the tasks under the topic: "Configuring the hdfs Scheme"

See:
https://my.vertica.com/docs/9.0.x/HTML/index.htm#Authoring/HadoopIntegrationGuide/libhdfs/ConfiguringAccessToHDFS.htm

Then your ready to read some data from Hadoop!

See:
https://my.vertica.com/docs/9.0.x/HTML/index.htm#Authoring/HadoopIntegrationGuide/libhdfs/ReadingDirectlyFromHDFS.htm

https://my.vertica.com/docs/9.0.x/HTML/index.htm#Authoring/HadoopIntegrationGuide/NativeFormats/ReadingNativeFormats.htm

Please let us know of any specific issues that you encounter!

1

Leave a Comment