Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
How to access IBM Hadoop using jaql and retrieving a table by clr tvf?

Answered How to access IBM Hadoop using jaql and retrieving a table by clr tvf?

  • Wednesday, April 17, 2013 7:45 PM
     
     
    Sign In to Vote
    0

    Hi!

    Given a solution provided by IBM using Hadoop, where you can access data through jaql.

    Is it possible to make an clr tvf taking

    an jaql string as input and giving table back as result set?

    Any code examples?

    Thanks

    Bjorn D. Jensen

    B. D. Jensen

     

All Replies

  • Thursday, April 18, 2013 12:41 AM
    Moderator
     
     Answered
    Sign In to Vote
    1
    Hi Bjorn, a couple of things:
    Does IBM Hadoop have an ODBC driver? Or does it work with Microsoft’s ODBC driver? If so, you’d be better off doing this through a linked server.
     
    What programming language and which API were you considering using for your SQLCLR proc? SQLCLR really doesn’t work well with languages other than C#, VB.NET, and managed C++. And I’m pretty sure that, because there is no Hadoop support in the SQLCLR supported assemblies list, whatever API you’d be using would have to run as an unsafe assembly in SQLCLR.
     
    So, seems like ODBC/linked server is the best choice.
     
    Cheers, Bob