Skip to Content
avatar image
Former Member

Postgresql to Hana data migration

Hi,

I am new to the HANA, is there any article which supports data migration from postgresql to HANA database. This is about abstract level question.

In specific I have one doubt about bytearray in postgresql which is used to store image information. Now I want to copy this data to Hana instance. For that I converted postgresql table to CSV file and I import this file into the SYSTEM schema as some table by HANA Studio. At the time of datatype mapping, Hana takes bytearray as blob. But the data which is in CSV file is in text format (correct me if I am wrong), it means ASCII format. Right? But BLOB is for Binary Large Object. So when I am trying to copy the text file (which is in ASCII) how Hana converts it to binary or byte data. As I am trying to fetch the same data from java program through JDBC connection. The program is working fine for postgresql for bytearray. But in case of blob from hana its not. I tried to fetch the blob and then convert it to bytearray.

Its simple blob.getBytes and following methods from http://docs.oracle.com/javase/6/docs/api/java/sql/Blob.html. While debugging I find that object size is retrieving like 4770 bytes (or some thing). but while accessing that object image is not getting created. If byteArray object is really fetched without any error, then I should have get the images properly. But in my case no error or exception from application point of view and no output.

Clear me on, Blob only accepts binary data or we can also give CSV file like explained above.

Kindly help me on this.

Thanks

Tirumala Srinivas Pujyam

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Nov 05, 2012 at 01:53 PM

    Is this question is not relevant? why I am not getting any response? Please do the needful.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • May 31, 2016 at 01:20 AM

    This message was moderated.

    Add comment
    10|10000 characters needed characters exceeded