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
54
votes
9 answers

How should I start learning about SAP?

I'm working as a MS developer working to provide bridging products between MS technology and SAP. I'm used to the MS space which seems to have an absolutely different philosophy than SAP. And this is starting to be an issue - I can't "get" SAP. So,…
Eli
  • 1,315
  • 1
  • 16
  • 29
16
votes
1 answer

What's the difference between SAP HANA and Memcached, Redis and existing databases hacked to use memory instead of disk?

There's a huge buzz in the business analytics world about the In-Memory database HANA by SAP. I'm struggling to see its real innovation compared to current open source databases. OK, it has indexing, graph support, column storage, etc... but that's…
ksiomelo
  • 1,878
  • 1
  • 33
  • 38
14
votes
5 answers

How to conditionally include a Hibernate annotation?

I have the code below in Play for Scala to access a SAP Hana table with Hibernate. I need to implement the same code with MySql, but the problem is that MySql doesn't support sequences (it works with AUTO_INCREMENT columns) and the code breaks…
ps0604
  • 1,227
  • 23
  • 133
  • 330
14
votes
5 answers

HANA list / show tables SQL Command

How to show / list all tables in SAP HANA via SQL?
Thorsten Niehues
  • 13,712
  • 22
  • 78
  • 113
13
votes
5 answers

Efficient database access to various DBMS from Delphi XE2

My needs I work with Delphi/C++Builder XE2. I need to access at least these DBMSs: Firebird DB2/400 SQL Server SAP HANA (a new in-memory DB, available interfaces: JDBC, ODBC, ODBO, SQLDBC) I need to show and edit data in data-aware visual…
bluish
  • 26,356
  • 27
  • 122
  • 180
11
votes
1 answer

Write to SAP HANA with RJDBC using dbWritetable very slow due to record by record insert

I am trying to write a large dataset (10 cols, 100M records) from R to SAP HANA using RJDBC's dbWritetable in the following way library("RJDBC") drv <- JDBC("com.sap.db.jdbc.Driver", "/data/hdbclient/ngdbc.jar", "'") database <- dbConnect(…
Michiel
  • 179
  • 1
  • 14
10
votes
1 answer

How to Establish Python Connection with HANA using OAUTH/JWT

We are currently using basic authentication in our python connectors to SAP HANA. In our current connection string, we use SQLAlchemy and it looks something like this: def get_engine(host_name): return…
Riley Hun
  • 2,541
  • 5
  • 31
  • 77
10
votes
2 answers

How to return the number of affected rows in a HANA stored procedure?

How does one return the number of rows affected from an insert or update statement while inside a SAP HANA stored procedure? In oracle one would use sql%rowcount but I can't find an equivalent for HANA in their documentation? For example: CREATE…
Chip Allen
  • 280
  • 1
  • 2
  • 12
9
votes
4 answers

HANA CDS Views vs Calculation Views vs Table Functions

In SAP HANA I am used to create Calculation Views. Previously I learned that Calculation Views (which after compilation are column-views) are to be prefered over Database-SQL-Views. Now with CDS-Views I am not sure if this is still the case.…
Thorsten Niehues
  • 13,712
  • 22
  • 78
  • 113
9
votes
3 answers

Want to update dates in date column, with the past dates from yesterday's date

This sounds very strange use case, but I want to update date column with some data. Please find below table. And I'm working on data which is in the JSON format. CityName | data1 | data2 | date Mumbai | 1.234 | 2.3456| Sat Jan 20 2018 12:00:00…
Prasanna
  • 1,752
  • 1
  • 15
  • 27
8
votes
1 answer

Select in SAP HANA + Hibernate throws error: `Method unwrap of com.sap.db.jdbc.CallableStatementSapDBFinalize is not supported`

I have the following table: CREATE column TABLE banks ( sk tinyint NOT NULL GENERATED BY DEFAULT AS IDENTITY, code varchar(10) DEFAULT NULL, name varchar(100) DEFAULT NULL, version smallint DEFAULT NULL, PRIMARY KEY (sk) ); I try to…
ps0604
  • 1,227
  • 23
  • 133
  • 330
7
votes
2 answers

.Net Connector for SAP HANA with .Net Core

We are creating a web API for our organization. API connects and retrieves data from a HANA View. I am referring the sample provided at the below link to establish the…
IamChandu
  • 355
  • 6
  • 18
7
votes
1 answer

How to concatenate multiple rows' fields in a sap hana table

I use SAP-HANA database. I have a simple 2 column table whose columns are id, name. The rows are these: 1 - tom 1 - harry 1 - jack 2 - larry I would like to group the rows by the id, and concatenate the names into a field, and thus obtain this: 1 -…
Nishanth Reddy
  • 589
  • 2
  • 14
  • 27
7
votes
1 answer

error when accessing OData with a number as a filter

I am trying to access an OData source provider, specifically an analytic view exposed by SAP HANA via Odata service. I'am applying a filter containing a number on odata but I am getting an error saying that using the number is not supported because…
Mohamed Ali JAMAOUI
  • 14,275
  • 14
  • 73
  • 117
6
votes
2 answers

How to format date in hana

I need to format date in my hana sql, but I don't know how to. Something like this: SELECT DATE_FORMAT(DATAS,'%Y-%m') as Dat ,sum(SALES_VALUE) as Venda ,sum(SALES_QTY) as Qtd ,sum(SALES_VALUE) / sum(SALES_QTY) as Preco FROM…
Juny
  • 191
  • 1
  • 1
  • 15
1
2 3
…
99 100