Stack Overflow
Stack Overflow

Questions tagged [hana]

SAP HANA is SAP SE’s implementation of in-memory database technology. Not to be confused with similarly named products and technologies e.g. S/4HANA, Boost.Hana, SAP HANA Vora, or SAP Cloud (SAPcp)

###About

SAP HANA is a development platform and database management system that uses in-memory database technology allowing the processing of massive amounts in real-time.

It integrates a wide range of data processing capabilities (predictive analytics, SQL, Geospatial, graph processing, data stream analytics, data warehousing, machine learning) with enterprise grade data management and with modern application development/deployment tools (cloud foundry style containers).

SAP HANA is the data processing platform SAP uses for all its products, both on-premises and in the cloud. It is the basis for future developments.

A resource streamlined version of SAP HANA on a free license up to 32 GB (including productive scenarios) is available for download and for deployment in cloud PaaS setups like AWS, MS Azure and Google Cloud Platform (HANA Express Edition, see link below).

Available interfaces & Capabilities

  • JDBC
  • ODBC
  • ODBO (OLE DB for OLAP, used for business intelligence)
  • SQLDBC (C++)
  • Python DBAPI
  • MDX
  • REST APIs
  • node.js HDB library
  • SQL and SQL Script
  • Text Analysis and Text Mining
  • Graph Data processing
  • Hadoop and Spark integration
  • node.js, Java and Bring Your Own Language development
  • Geospatial data processing
  • Predictive Analytics
  • Data Streaming

Links

###Related tags

, , , , , , , , , , , , ,

1915 questions
3
votes
1 answer

When sorting of itab is done in SQL query?

I have a select like this DATA lt_data TYPE SORTED TABLE OF T_TYPE1 WITH NON-UNIQUE KEY col1. SELECT col1, col2 INTO CORRESPONDING FIELDS OF TABLE lt_data where... My question is: will the sorting operation be performed on the DB or on the…
Skalozub
  • 539
  • 7
  • 26
3
votes
1 answer

Access to Table Function in Another HDI Container

I have one HDI container (HDI1) that access an Table Function (TF_1) in another HDI container (HDI2), I create the synonym, It`s OK, working fine. But when the TF_1 calls another Table Function (TF_2) in HDI2 I get "Insufficient Privilege" error. I…
I.B.N.
  • 992
  • 4
  • 15
3
votes
1 answer

HanaDB - Complexity of: SELECT COUNT( * ) FROM dbtab

This question is the same as MySQL - Complexity of: SELECT COUNT(*) FROM MyTable;. The difference is that instead MySQL i want to know the answer for HDB. I Googled it, and looked for it in SAP Knowledge Base without finding an answer. To clarify:…
Dorad
  • 3,413
  • 2
  • 44
  • 71
3
votes
1 answer

Call HANA stored procedure from SQL Server

I have defined a stored procedure in SAP HANA, with 3 IN parameters, that returns a recordset. It works perfectly from the HANA studio when I call it with the CALL sp_name (par1, par2, par3) syntax. Now I need to call it from a Microsoft SQL Server…
davidthegrey
  • 1,205
  • 2
  • 14
  • 23
3
votes
2 answers

How to Unpivot in SQL? (SAP HANA) (Columns to rows)

I need to unpivot some data in SAP HANA. I set up an example table to try it out on, but I still can't get anywhere. The actual table contains 1000's of ID's and ~50 columns, but I want to do this for many tables, so while I can specify the…
ThomasRones
  • 657
  • 8
  • 29
3
votes
2 answers

How to connect SSL on Hana DB - SAP [SQL Error 4321 - only secure connections are allowed]

following the link SAP - Go (golang) Support a made the code below: package main import ( "database/sql" _ "github.com/SAP/go-hdb/driver" "log" ) const ( driverName = "hdb" hdbDsn =…
pedrualves
  • 93
  • 9
3
votes
3 answers

Use second condition instead if rows are not found

I have the following select: SELECT name, text, lang FROM texts WHERE name IN @r_names AND lang IN ( @lv_lang, 'E' ) INTO TABLE @DATA(lt_texts). It will select texts multiple lines of texts for a given name. How do I say that I want texts…
kdobrev
  • 270
  • 1
  • 3
  • 11
3
votes
1 answer

How can I join multiple tables on the same auto generated integer from one "table"?

I want to create a random selected cross-joined table which auto increments its own id and joins on it. Let's say my tables looking like this. Person Firstname, Lastname Hans | Müller Joachim | Bugert Address City, Street,…
Schwenk
  • 225
  • 2
  • 13
3
votes
5 answers

Cannot connect to SAP HANA Express DB using eclipse studio

I am new to SAP HANA database. I have successfully hosted the SAP HANA express database on cloud server. I have created a database and I am able to query it for the CLI. However I have trouble connecting it from eclipse have spent two days on the…
Ether
  • 125
  • 1
  • 9
3
votes
2 answers

SAP HANA SQL how to convert Date and Time to timestamp

I am trying to concatenate the CreateDate and CreateTS columns to make one Timestamp that contains the date and time. Right now the only solution I reached is this: SELECT TO_TIMESTAMP( …
Sano
  • 469
  • 2
  • 6
  • 21
3
votes
1 answer

Effective way to write table to SAP HANA from R

I have a table (df) of about 50,000 rows and 12 columns to write to SAP HANA. I use the RJDBC library and write row by row as follows: # Returns the sql statement to insert one row build_insert_string <- function(db_output, row) { row_string <-…
NRLP
  • 568
  • 3
  • 16
3
votes
2 answers

ORDER_BY with collation in SAP HANA

In my table I've got values with polish diacritics signs. I want to query it and sort the result with the right order. I need collation to do this, but I don't know how to use it in SAP HANA database. Test table CREATE COLUMN TABLE TEST_ORDER_BY ( …
kojot
  • 1,634
  • 2
  • 16
  • 32
3
votes
0 answers

How to setup CORS so that I can access HANA OData from SAP WebIDE (SAPUI5)

I am trying to access my database tables from SAP HANA, and I am encountering a CORS issue I believe in accessing the data without ta Access-Control-Allow-Origin Error, and of all the resources I've been looking at haven't solved the issue yet. So I…
seanjedi
  • 69
  • 1
  • 10
3
votes
2 answers

SAP HANA SQL Query with Dynamic Placeholder

I have a query that is passing the current year as a placeholder parameter that right now is hard coded. How can I have this just pass the current year? I've seen a few different potential solutions but most of them are in HANA Studio or involve…
Andrew
  • 31
  • 1
  • 2
3
votes
2 answers

How to aggregate values from different rows in sql (HANA)?

I have a table of shipments defined like so (the table is stored in a HANA database, if relevant): CREATE COLUMN TABLE SHIPMENTS ( ShipmentID INT PRIMARY KEY, Received INT, Facility NVARCHAR(10), Item NVARCHAR(20) ); Here, the…
Kazim
  • 133
  • 1
  • 5
1 2 3
…
99 100