Skip to main content

Querying data from HDFS.

  • January 4, 2018
  • 1 reply
  • 10 views

RohitM

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 reply

Jim_Knicely
Forum|alt.badge.img+2
  • Participating Frequently
  • January 4, 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!