Querying data from HDFS.

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

Jim_Knicely

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!