Skip to Content
avatar image
Former Member

Use of Column Store Data Type

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Dec 22, 2014 at 10:59 AM

    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.

    Column Store in SAP HANA

    I hope this helps,

    Cheers,

    Sumit

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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

  • avatar image
    Former Member
    Dec 23, 2014 at 06:44 AM

    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.

    • Are these data types are just being filled up in the UI and not used internally in case of a row table??
    • data types STRING & CS_STRING are totally different as STRING data type is not a defined data type under column store data type?

    Though these aspects are used up internally, I an just curious to know how this works.

    Thanks & Regards,

    Monissha


    Capture.PNG (30.6 kB)
    Add comment
    10|10000 characters needed characters exceeded

    • Hi Monissha,

      • Are these data types are just being filled up in the UI and not used internally in case of a row table?? - It doesn't matter whether the table is row or column store table. Any table you create in HANA(through SQL or UI) will have column store data type for internal usage

      • data types STRING & CS_STRING are totally different as STRING data type is not a defined data type under column store data type? - SQL data types are mapped to column store data types. Refer to the link shared by me in previous reply.

      Regards,

      Vivek