Page 1 of 1

Re: Connecting to HDFS via Datastage 9.1 installed on window

Posted: Tue Mar 08, 2016 8:56 am
by chulett
ssk wrote:Does that mean I won't be able to go ahead?
Yes, that is exactly what that means. Others will have to chime in to say if support was added in a later version but my quick attempt to google something up failed miserably. :(

Posted: Tue Mar 08, 2016 10:56 pm
by ssk
Thanks chulett for your reply.

Unfortunately, the 11.3 version also has the same message! :(

I wonder if anyone has come across this situation earlier.

Posted: Wed Mar 09, 2016 12:04 am
by ray.wurlod
Yes, which is one of the reasons they chose to install on Linux.

Posted: Wed Mar 09, 2016 12:21 pm
by rkashyap
For sourcing data from hadoop at non Linux/AIX IIS installations, workaround suggested by IBM is "For read only operations, JDBC/HIVE interface can be utilized".

We have not tried it.

Posted: Thu Mar 10, 2016 6:21 am
by ssk
Thanks ray, rkashyap.

I will check the JDBC connection part.

Posted: Thu Mar 10, 2016 4:02 pm
by eostic
For what it's worth, the option is there....the File Connector supports WebHDFS and HttpFS protocols for reaching into Hadoop for hdfs.... I am using that on my Linux images, so haven't had a need to test it with my Windows image, but the option is there (in Windows 11.5) in the File Connector.....

Ernie

Posted: Wed Mar 23, 2016 10:21 am
by adityavinay
Are you able to connect to HIVE using JDBC connection?

Posted: Thu Apr 07, 2016 1:12 am
by ssk
Have not tried it yet. Though I vaguely remember to have read somewhere that this connection is possible.