Topic
  • 2 replies
  • Latest Post - ‏2012-10-25T17:12:31Z by jwill20
jwill20
jwill20
12 Posts

Pinned topic DB2 Integration With BigInsights

‏2012-10-25T14:06:22Z |
Trying to understand the User Defined Functions for integration between DB2(also Netezza) and Jaql.

The doc for HDFS_READ says that the HDFS files must be in CSV form(CSV for DB2, Netezza should be pipe delimited but allows specifying some other delimiter).

Just want to verify that these UDFs are implying that I need some process to get my HDFS files into that form (CSV for e.g.) before using the UDFs?

My files in HDFS are key/value pairs and not in CSV form. Do I need to convert to something like this: "key,value" for DB2 and "key|value" for Netezza?
Thanks,
Jim
Updated on 2012-10-25T17:12:31Z at 2012-10-25T17:12:31Z by jwill20
  • SystemAdmin
    SystemAdmin
    603 Posts

    Re: DB2 Integration With BigInsights

    ‏2012-10-25T17:11:00Z  
    Hi Jim,

    Your understanding is correct. You will need to perform the conversion first.

    Thank you,

    Zach
  • jwill20
    jwill20
    12 Posts

    Re: DB2 Integration With BigInsights

    ‏2012-10-25T17:12:31Z  
    Hi Jim,

    Your understanding is correct. You will need to perform the conversion first.

    Thank you,

    Zach
    Thanks Zach