on 12-22-2014 9:24 AM
Hi,
When I create a table from the UI, I see that there exits a column called Column Store Data Type.
What is the use of it?
Thanks & Regards,
Monissha
Hi Monissha,
In SAP HANA, data is stored as either column based or row based in the tables.HANA is a column oriented database (also called as C-stores) stores the content column wise rather than by row. It is very useful in data compression, Storing data by column results in better compression than the conventional row store. It also performs well while query processing since queries read only the columns which are required.
You can also go through the link.
I hope this helps,
Cheers,
Sumit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Monissha,
Column Store data types are used internally in the column store.
Also check the reply from Lars regarding Column Store data types in the below thread:
http://scn.sap.com/thread/3522274
You can check the mapping between SQL Data types and Column store data types in the below link:
Regards,
Vivek
Hi Monissha,
It is just the way data is stored internally columnar format. When you choose column store while creating the table, HANA internally assigns a data type for storing your specific data and data types which Column store data types. Anyway you dont have to worry about it while creating the table or inserting the data because you dnt use column store data types, which are generally referred as 'CS_', as it is all done internally so you just need to use SQL data types which you have used in provided screenshot. For more info you can refer link given by Vivek.
Cheers,
Sumit
Hi Vivek/Sumit,
Thank you very much for the useful link. I have gone through that as well.
I created a row table and you can see my definition below
So in case if my table is row, the column store data type has values like STRING,INT etc..
My questions are as follows.
Though these aspects are used up internally, I an just curious to know how this works.
Thanks & Regards,
Monissha
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Monissha,
If you have checked the link given above. It gives the relation between the SQL data types and Column store data types. So if you see the different SQL data types which are referred as 'CS_STRING' in column store data types. Those SQL data types are stored as 'CS_STRING' column store data types internally be it row type table or column type table.
Cheers,
Sumit
Hi Monissha,
Regards,
Vivek
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.