HANA import command

[Former Member]

Hi Folks,

My earlier thread was rejected, may be i put in very little info.

hdbsql HDB=> IMPORT "TESTING"."<table-name>" from '<location>' WITH REPLACE THREADS 20

* 2048: column store error: table import failed:  [30151] Object not found in the import directory;object=TESTING:<table-name> SQLSTATE: HY000

hdbsql HDB=> select count(*) from "TESTING"."<table-name>"

1 row selected (overall time 139.792 msec; server time 10.954 msec)

This is the problem select count(*) for the table works but import for the table doesnt work. Following the syntax.

http://help.sap.com/saphelp_hanaplatform/helpdata/en/20/f712e175191014907393741fadcb97/content.htm?f...

[lbreddemann]

Please show us what "<location>" looks like and the content of that folder-hierarchy.

[Former Member]

Finally Lars,

I thought you were going to blast me for raising a thread after initial rejection.

[Former Member]

Lars,

Please find the content below.

inside index directory there will be two directories.

%2fB  _S

first directory we have this create.sql  table.xml

In other directory we have five parts and and the subcontents are like below.

attributes  create  $delta$.log  freeUdivStore  RuntimeData

[lbreddemann]

Please post the output of

find <directory of export and index folders> -type d -print

Also please post

head -n 2 RuntimeData

For one of the exported tables.

[lbreddemann]

It's not that dramatic to have a question rejected when the initial search is not done.

Nobody gets hurt and the forum stays a bit cleaner.

[Former Member]

Lars,

This is what i want to acheive and what i have done.

I have a schema named SCHEMA1 and i have exported the table from SCHEMA1 using HANA studio and tried to import into another schema SCHEMA2 using command line.

index

index/SCHEMA1

index/SCHEMA1/%2fB

index/SCHEMA1/%2fB/%2fBIC%2fTABLE1

index/SCHEMA1/_S

index/SCHEMA1/_S/_SYS_SPLIT_%2fBIC%2fTABLE1%7e2

index/SCHEMA1/_S/_SYS_SPLIT_%2fBIC%2fTABLE1%7e2/attributes

index/SCHEMA1/_S/_SYS_SPLIT_%2fBIC%2fTABLE1%7e1

index/SCHEMA1/_S/_SYS_SPLIT_%2fBIC%2fTABLE1%7e1/attributes

index/SCHEMA1/_S/_SYS_SPLIT_%2fBIC%2fTABLE1%7e6

index/SCHEMA1/_S/_SYS_SPLIT_%2fBIC%2fTABLE1%7e6/attributes

index/SCHEMA1/_S/_SYS_SPLIT_%2fBIC%2fTABLE1%7e4

index/SCHEMA1/_S/_SYS_SPLIT_%2fBIC%2fTABLE1%7e4/attributes

index/SCHEMA1/_S/_SYS_SPLIT_%2fBIC%2fTABLE1%7e5

index/SCHEMA1/_S/_SYS_SPLIT_%2fBIC%2fTABLE1%7e5/attributes

index/SCHEMA1/_S/_SYS_SPLIT_%2fBIC%2fTABLE1%7e3

index/SCHEMA1/_S/_SYS_SPLIT_%2fBIC%2fTABLE1%7e3/attributes

This is for one part,

RuntimeData

# SAP NewDB - do not edit

# indexid: SCHEMA1:_SYS_SPLIT_TABLE1~1

Please let me know if you want for all the five parts.

[lbreddemann]

Ok, thanks for the output.

Now we see the schema name.

To change the target schema upon import, you can simply use the IMPORT ... WITH RENAME SCHEMA option.

It's in the documentation ... just next to the IMPORT FROM command (which is a different command).

[Former Member]

Lars,

Guten Tag!

How are you doing?

I checked this link but was unable to find it. I will check for IMPORT with RENAME option.

http://help.sap.com/saphelp_hanaplatform/helpdata/en/20/f712e175191014907393741fadcb97/content.htm?f...