Skip to Content
author's profile photo Former Member
Former Member

HANA and Data Types error

Hi experts,

I'm starting inserting data from Oracle 11g database into HANA via Data Services.

I have a table with a column with numeric values and (null) entries. When trying to import the data into hana, the dataservices job complete sucessfully but when displaying data in hana i have a very strange behavior : The first time i click on "Open Data Preview" in Hana Studio i have a correct display of my data : for exemple i can move to distinct values and see 500 differents value. but when i click a second time on Open Data preview all the values are changed to the character "?".
I don't know why i have this issue if anyone have informations about data types in HANA, i have found this guide : http://help.sap.com/hana/hana_sql_en.pdf p19.

Unfortunatly i am facing an issue : i have a field of this type in database :

Column name : MXR

Data Type NUMBER(12,3)

Nullable

Data default : ( null )

The fields are composed of differents values like { 0,6 ; 1200 ; null )
So when trying to insert data into hana i realized that maybe the null type might be an issue : so i've used update in oracle to replace null by 0. But still didn't change the issue, instead of having the column full of "?" i have now only 0 after a single and successfull display.

To be short : why did my data change on refresh ? : is after a refresh a check is made and the value is changed to default ? Can anyone help me ?

I

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Jun 13, 2012 at 04:34 AM

    Hi Guillaume,

    There is nothing wrong with the data. The values are still null. It is the way null values are displayed in studio. You can change this in the preference setting.

    Admin Console -> Common -> Representation of null values.. change it from ? to null

    Regards,

    Ravi


    show_null.JPG (57.4 kB)
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.