I know several have asked about JMP and Hadoop. Here is what Stan and I have come up with so far. Please respond to this thread with any notes from the field or additional comments/questions.
• JMP can access data in Hadoop optimally with the SAS/Access Interface to Hadoop. By using this interface, customers can access and use big data stored in Hadoop through the SAS integration interface in JMP. The usual caveats of data size and performance apply when trying to access these data in JMP.
• We have been marginally successful connecting to Hadoop via. ODBC and by using SAS/Access to Hadoop in JMP internally. The distribution used was Hortonworks with a local test cluster here at SAS. We were able to get as far as connecting to the server and pulling in metadata about the cluster but due to a still-unresolved permissions error we are unable to load data into the cluster or bring data other than the informational tables into JMP (Stan K and Dan V).
• (SAS Company Confidential) Matt Flynn (Aetna) has been working on developing a workflow around JMP and Hadoop. He is using a Hortonworks cluster. He is trying to use SAS/Access to Hadoop (but running into issues around security/permissions). SAS becomes the connection point to Hadoop. JMP -> SAS -> SAS/Access -> Hadoop. SAS interface for random or stratified sampling would be productive. Also considering Netezza as another intermediate step. IT would serve up summarized and cleaned up data to a Netezza appliance and then he would access in JMP via SAS/Access for Netezza.
This document was generated from the following discussion: JMP and Hadoop
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />I had been able to access Hadoop using Impala ODBC when I was at Samsung when they were on Pivotal.
