on 08-01-2012 11:03 PM
Can Any one shed some light on temporal tables .
The SAP HANA database supports temporal tables that allow queries against a historical state of the data. Write operations on temporal tables do not physically overwrite existing records. Instead, write operations always insert new versions of the data record into the database. The different versions of a data record have timestamp-like attributes that indicate their validity.
Is this purely a BW on HANA functionality , or can I use it in normal HANA operations. and how to use it ?
Hi Rajarshi,
the temporal tables are a pure HANA feature that has nothing to do with SAP BW, although BW uses this feature as well (e.g. for In-Memory-Optimized DSOs).
Temporal or historic tables can be used just like other tables but allow for so called time-travel queries (AS OF UTCTIMESTAMP extension). With these you can access the data in a table as it has been at the timestamp provided.
Best regards,
Lars
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Lars, Now I know that it exists however I cant seem to find any documentation on it. In one of my projects , we are a lot of custom delta replications , so temporal tables can be of value here .
as such i did find a thread on it .. http://scn.sap.com/message/13230759
However my requirement is on a SLT replicated table , in that case .. would be possible to use this feature . ? I mean in replication I dont create the table that i can pass this option ..
Message was edited by: Rajarshi Muhuri
Well actually it is documented, though very briefly...
http://help.sap.com/hana/html/sql_create_table.html
has a paragraph on how to enable/create history tables and how to consume historic data.
The same is true for
http://help.sap.com/hana/html/sql_select.html
where you also find a section on time travel queries.
Anything not documented there is currently not supported for outside SAP use - so maybe it's not exactly what you are looking for...
cheers,
Lars
Got another good article that explains well about doing transactions in a History Column table: http://help.sap.com/hana/html/sql_create_table_history_time_travel.html
Rajarshi - I had the same question regarding enabling time travel on SLT created tables. Did you manage to get an answer on this?
From this link it is pretty clear that you can alter an existing table (that might have been created by SLT) so that seems pretty straightforward. However, it seems that the complication might be the requirement to turn auto-commit off. In this case, would SLT be issuing the commit statement or how would that work?
Thanks,
Justin
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.