on 2025 Feb 14 1:27 PM
Is there any limitation as to what number of columns can be added in a table in sap hana db . I intend to use the table to create a graph workspace. Since sap hana mainly uses homogenous graphs with single label , hence I plan to add all my columns in a single table.
Hence is there any upper limit as to what number of columns will sap hana support ?
Kindly advice.
Request clarification before answering.
Hej, there is a limit of 64000 columns for a column store table.
I'd like to point out 3 things you might want to consider:
1.) if you run GraphScript algorithms on your graph, it may be ok to include just a minimum number of columns (key columns only), and then add additional data to the result of the algorithm using a relational join afterwards.
2.) you might want to take a look at the HANA JSON document store as a backend for your heterogenous graph. Note that there is currently no OpenCypher support for "Graph on DocStore".
3.) for the upcoming release, we plan to support an RDF triplestore and SPARQL. This might be a good alternative to run pattern matching queries on heterogenous graphs.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 7 | |
| 7 | |
| 7 | |
| 7 | |
| 5 | |
| 4 | |
| 4 | |
| 3 | |
| 3 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.