Error in executing .hdbti file

[Former Member]

Hi All,

I created a .hdbti file with the following configuration.

import = [

{

hdbtable = "tmp.import_table::VARIANT_NEW";

file = "tmp.import_table.CSV:data_timestamp.csv";

header = false;

}

];

My hdbtable contains fields with "timestamp" datatype and the CSV file is exported from a table having the same data type. But I get the type mismatch error while activating the .hdbti file. But when I do the same for the tables having the "VARCHAR" or "INTEGER" datatypes only, it successfully activates and the data gets copied successfully. I suppose csv files handle only "VARCHAR" and "INTEGER" data types. Is there any way to handle the "timestamp" or "date" data types for .hdbti configuration? Herewith I have attached the error message I got during activation of .hdbti file.

With Regards

Nitish

[Former Member]

Hi Nitish,

Can you please also paste the content of your .hdbtable and .csv here? From the error message, it seems that the content in your csv file does not match the data type of the column which you defined in .hdbtable.

I've successfully tested the timestamp import with the following code.

timestamp.hdbtable:

table.schemaName = "TESTXS";

table.tableType = COLUMNSTORE;

table.columns = [

  {name = "TIMESTAMP"; sqlType = TIMESTAMP; nullable = false;}

];

timestamp.csv:

2013-07-30 13:12:46.6610000

timestamp.hdbti:

import =

        [

            {

                hdbtable = "testxs.data::timestamp";

                file = "testxs.data.loads:timestamp.csv";       

                header = false;                                            

            }

         ];

Best regards,

Wenjun

[Former Member]

Is the "createOn" column type of 'timestamp'? I guess you need to open the csv file with excel, and change the cell format of the "createOn" values to 'yyyy-m-d h:mm:ss AM/PM'. In this format, you can import the timestamp values.